Senior Data Engineer – P&C Insurance (Remote)

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

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