: Clarity/Insights Developer- (Noida/Goa)
Position Summary The Clarity Developer designs, develops, and supports enterprise reporting and analytics solutions using Duck Creek Clarity and Snowflake. This role combines advanced SQL, reporting, data engineering, and insurance-domain knowledge to deliver accurate, scalable reports, dashboards, and curated datasets that support business and operational decision-making.
Key Responsibilities
- Design, develop, test, deploy, and support reports, dashboards, datasets, and visualizations in Duck Creek Clarity.
- Develop and optimize complex Snowflake SQL, including views, stored procedures, transformations, and performance-tuned queries.
- Translate business and reporting requirements into scalable technical designs and report specifications.
- Assess and migrate legacy reports to Clarity, including SQL logic, calculations, filters, data sources, and output requirements.
- Build and maintain source-to-target mappings, transformation rules, data models, and technical documentation.
- Develop and support Snowflake database objects, including schemas, tables, views, stages, file formats, streams, tasks, and data-loading processes.
- Partner with data engineering and integration teams to support ETL/ELT pipelines and resolve data-quality, timing, mapping, and performance issues.
- Reconcile data across source applications, Snowflake, and Clarity report outputs to ensure accuracy and traceability.
- Support unit testing, system integration testing, user acceptance testing, deployment, and post-production validation.
- Follow established security, access-control, data-governance,
version-control, and deployment standards.
Required Qualifications
- Bachelor’s degree in Computer Science, Information Technology, Data Analytics, or a related field; equivalent experience considered.
- 4+ years of experience in reporting development, business intelligence, analytics, data engineering, or a related technical role.
- Hands-on experience developing reports and dashboards in Duck Creek Clarity or a comparable modern BI/reporting platform.
- Robust Snowflake experience, including advanced SQL, data modeling, database objects, performance tuning, and security concepts.
- Advanced SQL skills, including joins, CTEs, window functions, aggregations, query optimization, and data validation.
- Experience with ETL/ELT processes, data integration, data transformation, and source-to-target mapping.
- Experience troubleshooting data issues across source systems, integration layers, Snowflake, and reporting outputs.
- Understanding of relational databases, data warehousing, dimensional modeling, and data-quality practices.
Preferred Qualifications
- Duck Creek Clarity experience strongly preferred.
- Experience with Duck Creek Policy, Billing, Claims, Distribution Management, Insights, or other Duck Creek applications.
- Experience with Snowflake capabilities such as Snowsight, SnowSQL, Streams, Tasks, Dynamic Tables, and Snowpipe.
- Experience with ETL/ELT or orchestration tools such as Azure Data Factory, dbt, Informatica, Talend, Airflow, Logic Apps, MuleSoft, or Boomi.
- Experience with Power BI, Tableau, Cognos, Jaspersoft, or similar visualization tools.
📌 Clarity/Data Insights Developer (India)
🏢 Palnar
📍 India