Senior Data Analyst – Duck Creek Technologies (Policy, Claims, Billing & Clarity)
Location: Remote
Role Overview We are seeking an experienced Senior Data Analyst with deep domain expertise across the core Duck Creek Suite (Policy, Claims, and Billing) and Duck Creek Clarity. In this role, you will bridge the gap between core insurance processing systems and downstream enterprise analytics, designing robust data models, building reporting frameworks, and unlocking critical business insights across underwriting, policy administration, billing operations, and claims management.
Key Responsibilities
Duck Creek Data Modeling & Extraction: Design, develop, and optimize data models utilizing the Duck Creek Suite (Policy, Billing, Claims) schema and Duck Creek Clarity data stores (Operational Data Store and Analytical Data Store).
Clarity Pipelines & Analytics: Leverage Duck Creek Clarity to ingest, transform, and expose operational and transactional data for business intelligence, statutory reporting, and executive dashboards.
Cross-Functional Analytics: Partner with Underwriting, Actuarial, Claims, and Finance stakeholders to translate complex business requirements into clear analytical definitions, KPIs, and visualizations.
Data Quality & Reconciliation: Establish automated data quality frameworks and reconciliation pipelines between Duck Creek source applications (Transact/Server), Clarity data layers, and target enterprise data warehouses.
SQL & Pipeline Optimization: Author high-performance SQL queries, views, and ETL/ELT procedures to support high-volume, low-latency reporting environments.
Documentation & Governance: Maintain comprehensive data dictionaries, data lineage documentation, and governance standards for all Duck Creek entities and attributes.
Qualifications & Experience
Core Experience: 5+ years of data analysis experience in the Property & Casualty (P&C) insurance industry.
Duck Creek Mastery: Direct, hands-on experience working with data structures across Duck Creek Policy, Duck Creek Claims, and Duck Creek Billing.
Clarity Expertise: In-depth knowledge of Duck Creek Clarity architecture, data mapping, out-of-the-box feeds, and schema customization.
Technical Skills
Advanced SQL proficiency (window functions, stored procedures, complex joins, and query optimization).
Hands-on experience with modern cloud data platforms (e.g., Snowflake, BigQuery, AWS Redshift, or Azure Synapse).
Proficiency with BI/visualization tools (Power BI, Tableau, or Looker).
Familiarity with XML/JSON payloads used in Duck Creek integrations.
Insurance Domain Knowledge: Solid understanding of core P&C metrics, including written/earned premium, loss ratios, loss development, combined ratio, reserve changes, and billing collection cycles.
Communication: Proven ability to present complex technical and analytical concepts clearly to non-technical business leaders and technical engineering teams.
Preferred Qualifications
Prior experience migrating legacy reporting systems to Duck Creek Clarity.
Familiarity with Duck Creek Insights or integration with cloud-native ETL tools (e.g., dbt, Azure Data Factory).
Professional certifications in Duck Creek Technologies or insurance data frameworks.