Duck creek Insights Sr Developer/ Tech Lead
JOB SUMMARY
This is a client-facing role requiring communication and stakeholder management. Coordination with offshore and nearshore teams is required.
Key Responsibilities
• Act as technical SME for Duck Creek Insights Data Insights Clarity 7x 8x
• Perform Duck Creek Policy and Insights upgrade
• Understand E2E architecture of Duck Creek Policy Claims datastores and downstream consumers
• Monitor and optimize batch jobs referencing to crosstable loads
• Identify database/query bottlenecks and optimize data extraction and transformation logic
• Own technical design and implementation decision for insights enhancements
• Conduct technical impact assessments for enhancements, upgrades, defects, and production changes
• Develop and troubleshoot ETL/data processing workflows
• Validate source-to-target mappings and transformation logic
• Investigate and perform RCA for missing, duplicate, delayed, or incorrectly transformed records
• Support batch and scheduled data processing activities
• Ensure data reconciliation between source Duck Creek applications and Insights
• Optimize data processing workflows for performance and reliability
• Coordinate Insights changes across development, QA, UAT, staging, and production environments for development teams
• Translate complex technical issues into understandable business impact for non-technical stakeholders
• Create and maintain technical design documents, architecture diagrams, dataflow diagrams, source-to-target mapping documents, interface specifications, configuration documentation, deployment procedures, troubleshooting guides, and production support runbooks
Required Qualifications
• 10 years of experience with SQL, SQL Server/Oracle or relational databases, MSBI tools (SSIS, SSRS, SSAS), ETL and data integration frameworks, XML/JSON and API/interface concepts
• 8 years of experience with Duck Creek Insights Data Insights Clarity 7x 8x
• Experience in performing Duck Creek Policy and Insights upgrade
• Understanding of E2E architecture of Duck Creek Policy Claims datastores and downstream consumers
• Knowledge of Datawarehouse concepts such as star schema, Snowflake schema
• Experience in monitoring and optimizing batch jobs referencing to crosstable loads
• Ability to identify database/query bottlenecks and optimize data extraction and transformation logic
Preferred Qualifications
• Insurance background and PC insurance preferred
• Good knowledge of CICD and release management processes preferred