Data engineer

Job Title: Senior Data Engineer P&C Insurance

Location: Remote US-Based Only

Core Hours: Aligned to US Eastern Time

Job Summary

We are looking for an experienced Senior Data Engineer with strong hands-on experience in Property & Casualty (P&C) insurance data and modern Microsoft data technologies. The ideal candidate will have expertise in SQL Server/T-SQL, SSIS, Microsoft Fabric, dbt, Python, dimensional data modeling, and ETL/ELT development .

This role will focus on transforming complex insurance data-including policies, premiums, claims, losses, and reserves -into reliable, governed datasets for actuarial, underwriting, finance, and reporting needs.

Key Responsibilities

• Design, develop, and maintain scalable data pipelines and ETL/ELT processes for P&C insurance data.
• Develop complex T-SQL queries, stored procedures, indexing strategies, and performance-tuned solutions in SQL Server.
• Build and maintain SSIS batch ETL packages , including incremental loads, error handling, logging, and data validation.
• Deploy and schedule ETL workflows using SQL Server Agent .
• Develop data solutions using Microsoft Fabric , including:
  • Fabric Lakehouse
  • Data Factory pipelines
  • Notebooks
  • Direct Lake semantic models
• Use dbt and Python for data transformation, testing, documentation, and pipeline automation.
• Implement medallion architecture across Bronze, Silver, and Gold layers, transforming raw extracts into conformed and curated reporting datasets.
• Design and maintain dimensional data models supporting actuarial, underwriting, finance, and business reporting.
• Implement data quality checks, validation rules, and documented data lineage across critical insurance datasets.
• Partner with business SMEs, actuarial teams, underwriting teams, and finance stakeholders to translate insurance business rules into robust pipeline and transformation logic.
• Work with P&C source systems, including policy administration, billing, and claims platforms .
• Support insurance data standards and formats such as bordereaux and ISO statistical reporting .
• Leverage ACORD standards where applicable.
• Troubleshoot data pipeline failures, data quality issues, performance problems, and integration challenges.
• Document data models, transformation logic, lineage, pipeline processes, and data quality rules.
• Independently manage development priorities and deliver solutions in a remote contractor environment.

Required Skills & Experience

• 5+ years of professional data engineering experience .
• Hands-on experience working with Property & Casualty (P&C) insurance data , including:
  • Policy
  • Premium
  • Claims
  • Losses
  • Reserves
• Strong SQL Server development experience.
• Advanced T-SQL , stored procedures, indexing, query optimization, and performance tuning.
• Strong hands-on SSIS experience with batch ETL.
• Experience with incremental data loads, error handling, logging, and SQL Server Agent deployments.
• Working knowledge of Microsoft Fabric , including Lakehouse, Data Factory pipelines, notebooks, and Direct Lake.
• Experience with dbt and Python for transformation, testing, and documentation.
• Experience implementing Bronze/Silver/Gold medallion architecture .
• Strong understanding of dimensional data modeling .
• Experience with data lineage, data quality, validation, and governance.
• Ability to translate complex insurance business rules into technical data pipeline logic .
• Strong communication and collaboration skills with business and technical stakeholders.

Preferred Experience

• Experience with P&C policy administration, billing, and claims systems .
• Knowledge of bordereaux and ISO statistical reporting .
• Familiarity with ACORD standards.
• Experience supporting actuarial, underwriting, and finance reporting .
• Experience with modern data platforms and cloud-based data engineering.
• Experience working independently in a remote contract environment .