Data engineer

iShare Inc; New Jersey; Remote; USD 120,000 - 160,000; Full time

Job summary

iShare Inc. is seeking a Senior Data Engineer specialized in Property & Casualty insurance data.

You will design and maintain scalable data pipelines using SQL Server, SSIS, Python, and Microsoft Fabric to transform policies, premiums, claims, and reserves into governed datasets for actuarial and finance teams. This remote US-based role requires strong SQL, T-SQL, data modeling, data governance, and collaboration with SMEs to translate business rules into robust ETL/ELT processes and

Qualifications

• 5+ years of professional data engineering experience.
• Hands-on P&C insurance data experience (policies, premiums, claims, losses, reserves).
• Strong SQL Server development and T‑SQL skills; SSIS batch ETL.
• Working knowledge of Microsoft Fabric, Data Factory pipelines, notebooks, and Direct Lake.
• Experience with dbt and Python for data transformation and testing.
• Knowledge of medallion architecture and dimensional modeling.
• Data lineage, quality, governance, and validation capabilities.
• Ability to translate insurance business rules into robust data pipelines.

Responsibilities

• Design, develop, and maintain scalable data pipelines and ETL/ELT processes for P&C data.
• Develop complex T-SQL queries, stored procedures, indexing, and performance tuning.
• Build and maintain SSIS batch ETL packages with incremental loads and validation.
• Deploy ETL workflows using SQL Server Agent and schedule data jobs.
• Leverage Microsoft Fabric components: Lakehouse, Data Factory pipelines, notebooks, Direct Lake.
• Use dbt and Python for transformation, testing, and documentation.
• Implement Bronze/Silver/Gold medallion architecture and dimensional models.
• Collaborate with SMEs across actuarial, underwriting, and finance to translate rules into pipelines.

Skills

P&C insurance data

SQL Server

T-SQL

SSIS

Microsoft Fabric

dbt

Python

ETL/ELT

data modeling

data governance

Tools

SQL Server Agent

Data Factory

Notebooks

Direct Lake

Job description

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.