Data Engineer

Position: Data engineer
Location: Remote
Engagement: 6-month contract, potential for extension or conversion to full-time | Remote, US-based only | Core hours aligned to US Eastern time
Experience: 7+ years
Visa: EAD, H1b
Client: AIG
Notes:

1. Property & Casualty (P&C) insurance experience is required.


2. Healthcare insurance experience is not required.


3. The candidate’s current client must be in the direct insurance domain and have experience associated with PNC Bank. Please ensure the current client is not AIG.


4. The candidate’s current job title should be Data Engineer. The second client’s job title should be Data Scientist and should include experience with Statistical Reporting.


5. Do not mention ISO anywhere in the resume.
   Required Skills:
   • 5+ years of data engineering experience, including hands-on work with property and casualty insurance data (policy, premium, claims, losses, reserves)
   • Strong SQL Server development: complex T-SQL, stored procedures, indexing, and query tuning against large transactional and reporting datasets
   • Proven SSIS experience building batch ETL, including incremental loads, error handling, and deployment via SQL Server Agent
   • Working knowledge of Microsoft Fabric: Lakehouse, Data Factory pipelines, notebooks, and Direct Lake semantic models
   • Experience with dbt and Python for transformation, testing, and documentation, implementing a medallion architecture (bronze, silver, gold) from raw extracts through conformed and curated reporting layers
   • Builds dimensional models for actuarial, underwriting, and finance reporting, with documented lineage and data quality checks
   • Familiarity with P&C source systems and standards (policy admin, billing, claims platforms; bordereaux, ISO statistical reporting, ACORD a plus)
   • Self-directed contractor who partners with business SMEs to translate insurance rules into pipeline logic