← Back to jobsJob ID col-cmwp7biz10792d8hajgcwnj1w

ShimentoX TechnologiesPosted 2 days ago

Data Analyst DuckCreekNew

Full-time
Remote
5+ years
Competitive
Posted 2 days ago

ShimentoX Technologies is seeking a Senior Data Analyst to connect Duck Creek insurance processing systems with enterprise analytics. The role focuses on data modeling and extraction, Clarity pipelines, reporting, cross-functional analytics, data quality, SQL optimization, and documentation across Property & Casualty insurance operations.

Posted
2 days ago
Source
linkedin.com
Sector
Information Technology & AI

Opens the employer's application page in a new tab

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

  • 5+ years of data analysis experience in the Property & Casualty (P&C) insurance industry
  • Direct, hands-on experience working with data structures across Duck Creek Policy, Duck Creek Claims, and Duck Creek Billing
  • In-depth knowledge of Duck Creek Clarity architecture, data mapping, out-of-the-box feeds, and schema customization
  • 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
  • Solid understanding of core P&C metrics, including written/earned premium, loss ratios, loss development, combined ratio, reserve changes, and billing collection cycles
  • Proven ability to present complex technical and analytical concepts clearly to non-technical business leaders and technical engineering teams

Preferred

  • 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
  • Duck Creek Clarity Migration

Required skills

AWS RedshiftAzure SynapseBigQueryDuck Creek ClarityLookerPower BIProperty and Casualty InsuranceSQLSnowflakeTableauXML/JSON

Full job description

ShimentoX Technologies is seeking a Senior Data Analyst to connect Duck Creek insurance processing systems with enterprise analytics. The role focuses on data modeling and extraction, Clarity pipelines, reporting, cross-functional analytics, data quality, SQL optimization, and documentation across Property & Casualty insurance operations.

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

Preferred

  • 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
  • Duck Creek Clarity Migration
  • Duck Creek Insights
  • Cloud-Native ETL
  • dbt
  • Azure Data Factory
  • Duck Creek Certifications
  • Insurance Data Frameworks

Benefits

  • Remote work (Work in Pacific Time)

Company

  • AI/ML, cloud, big data, and financial risk consulting
  • Walnut Creek, California, USA
  • https://shimentox.ai/
  • Founded in 2009
  • 201-500 employees

Qualifications

  • 5+ years of data analysis experience in the Property & Casualty (P&C) insurance industry
  • Direct, hands-on experience working with data structures across Duck Creek Policy, Duck Creek Claims, and Duck Creek Billing
  • In-depth knowledge of Duck Creek Clarity architecture, data mapping, out-of-the-box feeds, and schema customization
  • 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
  • Solid understanding of core P&C metrics, including written/earned premium, loss ratios, loss development, combined ratio, reserve changes, and billing collection cycles
  • Proven ability to present complex technical and analytical concepts clearly to non-technical business leaders and technical engineering teams
  • 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
  • 5+ years of data analysis experience in the Property & Casualty (P&C) insurance industry.

Required skills

  • AWS Redshift, Azure Synapse, BigQuery, Duck Creek Clarity, Duck Creek Policy, Claims, and Billing, Looker, Power BI, Property and Casualty Insurance, SQL, Snowflake, Tableau, XML/JSON

Experience

  • 5+ years

Job details

Employment type

Full-time

Seniority level

5+ years

Date posted

Nov 19, 2026

Work mode

Remote

Job source

linkedin.com

Company

ShimentoX Technologies

Information Technology & AI

AI/ML, cloud, big data, and financial risk consulting

  • Walnut Creek, California, USA
  • Information Technology & AI
  • 201-500 employees
  • Founded 2009
  • shimentox.ai

Similar jobs

Matched on role, skills and location · live jobs only

See more Data Analyst jobs

Dice

1d ago

New

Hiring: Technical Data analyst with insurance exp. || Wilmington, DE

TemporaryHybridWilmington, DECompetitive

Key2Source is recruiting for an unnamed client for a Technical Data Analyst role focused on insurance-related data analysis and engineering.

Why similarSame roleBigQueryPower BI

Kodeva LLC

1d ago

New

Senior Data Analyst

Full-timeOn-sitePlano, TXCompetitive

Kodeva LLC is seeking a Senior Data Analyst for an on-site role in Plano, Texas. The role focuses on analyzing Snowflake data and trends, visualizing insights, automating processes, and working with risk managers and product owners.

Why similarSame roleSQLSnowflake

Voya Financial

1d ago

New

Analyst, Securities Referential Data

Full-timeOn-siteAtlanta, GA$95K – $115K/yr

Voya Investment Management is hiring an Analyst to maintain accurate and complete investment security referential data.

Why similarSame rolePower BISQL

Get new Data Analyst jobs by email

Create job alert

Data Analyst DuckCreek

ShimentoX Technologies · Competitive

Apply on company site