Job Title: Duck Creek Clarity Engineer (SQL & Snowflake)
Experience: 3 – 15Years
Location: Hyderabad/Remote
Department: Development ( Developer | Lead | Architect)
The Duck Creek Insights Database Developer is responsible for designing, developing, maintaining, and optimizing the Duck Creek Insights data platform, reporting databases, ETL processes, data models, and analytics solutions. The role supports reporting, operational intelligence, regulatory reporting, and business analytics across Duck Creek Policy, Billing, Claims, and related insurance systems.
Key Responsibilities
Data & Database Management
- Design and maintain Duck Creek Insights databases and data warehouses.
- Develop, optimize, and troubleshoot SQL Server databases.
- Create and maintain database schemas, tables, views, stored procedures, functions, and indexes.
- Implement database performance tuning and optimization.
- Monitor database health, storage utilization, and query performance.
ETL Development
- Design and develop ETL/ELT solutions for data extraction, transformation, and loading.
- Build and support data feeds from:
- Duck Creek Policy
- Duck Creek Billing
- Duck Creek Claims
- Third-party systems
- Ensure data integrity and reconciliation across source and target systems.
Reporting & Analytics
- Build operational and executive reports.
- Develop dashboards and KPI reporting solutions.
- Support business intelligence and analytics initiatives.
- Validate reporting outputs and business calculations.
- Assist business users with ad-hoc reporting requirements.
Duck Creek Insights Administration
- Maintain Insights data models and metadata.
- Support job execution, scheduling, monitoring, and troubleshooting.
- Manage batch processes and report generation.
- Participate in Insights upgrades, migrations, and production support.
Data Quality & Governance
- Define data validation and reconciliation processes.
- Implement data quality controls.
- Support audit, compliance, and regulatory reporting requirements.
Solution Design
- Work with Business Analysts and SMEs to understand reporting requirements.
- Translate business requirements into data models and technical specifications.
- Estimate and implement reporting enhancements.
Required Technical Skills
Duck Creek Skills
- Duck Creek Insights
- Duck Creek Data Insights
- Duck Creek Policy
- Duck Creek Billing
- Duck Creek Claims
- Understanding of Duck Creek data architecture
Database Skills
- Microsoft SQL Server
- T-SQL
- Query Optimization
- Indexing Strategy
- Database Performance Tuning
- Database Design & Normalization
BI & Reporting Tools
Preferred experience with:
- SSIS
- SSRS
- SSAS
- Power BI
- Tableau
Data Engineering
- ETL Development
- Data Warehousing
- Data Modeling
- Data Migration
- Data Reconciliation
- Master Data Management