Chennai, Tamil Nadu
Job Summary
Role Summary
The Duck Creek Insights Engineer is responsible for designing, developing, enhancing, and supporting reporting, analytics, and data integration solutions within the Duck Creek ecosystem. The role works closely with business stakeholders, product owners, data analysts, and application teams to deliver actionable reporting and operational insights for Property & Casualty (P&C) insurance operations.
Key Responsibilities
- Design, develop, and maintain Duck Creek Insights reports, dashboards, and analytical solutions.
- Work on Extract Mapper to map the new elements as per the business requirement.
- Develop and optimize SQL queries, stored procedures, and reporting datasets.
- Analyze business and reporting requirements and translate them into technical solutions.
- Troubleshoot report, data, and performance issues across Duck Creek environments.
- Conduct root cause analysis and implement data fixes where required.
- Monitor batch jobs, application logs, data loads, and reporting health checks.
- Perform code investigation, bug fixes, and enhancement development.
- Collaborate with business users, QA teams, and developers during testing and deployment activities.
- Support production incidents and ensure timely issue resolution.
- Create technical documentation, data mapping specifications, and operational procedures.
- Participate in Agile ceremonies including sprint planning, backlog refinement, and retrospectives.
Required Skills
- 4+ years of experience with Duck Creek products, preferably Duck Creek Insights.
- Strong knowledge on DuckCreek Insight Architecture & Extract Mapper.
- Good knowledge on DuckCreek Insight Policy and Claim ERD.
- Strong SQL, T-SQL, database design, and query optimization skills.
- Experience with SSRS, Power BI, or enterprise reporting platforms.
- Knowledge of ETL processes and data warehousing concepts.
- Understanding of Duck Creek Policy, Billing, and Claims data models.
- Experience with Microsoft Azure DevOps (ADO) and Agile methodologies.
- Strong analytical, troubleshooting, and problem-solving skills.
- Ability to work with business stakeholders and technical teams.
Preferred Skills
- Experience in Property & Casualty Insurance.
- Knowledge of insurance policy administration, claims, billing, and underwriting processes.
- Experience with data integration technologies, XML, XSLT, and APIs.
- Exposure to cloud platforms such as Azure.
- Familiarity with data governance, reconciliation, and regulatory reporting requirements.
Qualifications
- Bachelor's degree in Computer Science, Information Technology, Engineering, or related field.
- Relevant Duck Creek certifications are highly desirable.
Key Skills (For SOW / Staffing Request)
- Duck Creek Insights
- SQL Server
- SSRS / Power BI
- Data Analytics & Reporting
- ETL and Data Warehousing
- Insurance Domain (P&C)
- Azure DevOps (ADO)
- Incident Management
- Production Support
- Agile/Scrum
- Root Cause Analysis
- Data Reconciliation & Validation
Key Responsibilities
1. Provide Technical Leadership By Guiding A Team Of Developers In Sql Server Best Practices, Enhancing Their Technical Capabilities, And Fostering A Collaborative Environment For Increased Productivity.
2. Conduct Thorough Code Reviews And Establish Quality Assurance Processes Focusing On Sql Server Performance Optimization And Implementation Of Coding Standards, Ensuring The Successful Delivery Of Complex Projects.
3. Ensure Process Compliance Within Assigned Modules And Actively Participate In Technical Discussions As A Consultant, Assessing Feasibility, Evaluating Technical Alternatives, And Identifying Potential Risks Associated With Sql Server Architecture.
4. Collaborate With Stakeholders To Define Project Scope, Objectives, And Deliverables, And Prepare Comprehensive Status Reports To Minimize Risks And Facilitate Timely Closure Of Escalations.
Skill Requirements
1. Strong Proficiency In Sql Server, Including Database Design, Development, And Optimization Techniques.
2. In-Depth Understanding Of Sql Query Writing, Performance Tuning, And Troubleshooting Complex Database Issues.
3. Solid Knowledge Of Data Modeling, Etl Processes, And Implementing Best Practices In Database Management.
4. Familiarity With Agile Methodologies And Project Management Frameworks.
Other Requirements
1. Optional Certifications: Microsoft Certified: Azure Data Engineer Associate, Microsoft Certified: Sql Server Database Development.
#body.unify div.unify-button-container .unify-apply-now: focus, #body.unify div.unify-button-container .unify-apply-#body.unify div.unify-button-container .unify-apply-now: focus, #body.unify div.unify-button-container .unify-apply-