Note: The job is a remote job and is open to candidates in USA. ShimentoX Technologies is seeking an experienced Senior Data Analyst specializing in Duck Creek Technologies and Property & Casualty insurance analytics. The role bridges Duck Creek insurance processing systems with enterprise analytics by designing data models, developing reporting and data pipelines, ensuring data quality, and delivering insights for underwriting, policy administration, billing, and claims management.
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
Skills
- 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
Benefits
- Remote work
Company Overview
Company H1B Sponsorship