Vertex Solutions Inc.

Data Engineer - P&C Insurance Industry experience

New York, NY • Posted 1 weeks ago
Hybrid Contract Insurance

Data Engineer – P&C Insurance industry experience

Contract

Remote, EST hours


  • 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
  • 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
  • Working knowledge of Microsoft Fabric: Lakehouse, Data Factory pipelines, notebooks, and Direct Lake semantic models
  • 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)
  • Must be able to work independently and also partner with business SMEs to translate insurance rules into pipeline logic


Vertex Solutions Inc. is an Equal Opportunity Employer and does not discriminate on the basis of race, color, creed, national origin, ancestry, religion, age, citizenship, sex, marital or veteran status, disability or handicap, sexual orientation or any other basis prohibited by applicable law.

Data Engineer - P&C Insurance Industry experience in New York at Vertex Solutions Inc.

This position is listed as contract and hybrid. It was posted last week.

See all Vertex Solutions Inc. jobs on LocalWork →

Back to Job Search