Data Engineer - P&C Insurance Industry experience
vertex solutionsDenver (CO)
Data Engineer - P&C Insurance Industry experience
Posted today
vertex solutionsDenver (CO)
SENIORITY
Senior
About the role
Data Engineer – P&C Insurance industry experienceContractRemote, 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 datasetsProven SSIS experience building batch ETL, including incremental loads, error handling, and deployment via SQL Server AgentExperience with dbt and Python for transformation, testing, and documentation, implementing a medallion architecture (bronze, silver, gold) from raw extracts through conformed and curated reporting layersWorking knowledge of Microsoft Fabric: Lakehouse, Data Factory pipelines, notebooks, and Direct Lake semantic modelsBuilds dimensional models for actuarial, underwriting, and finance reporting, with documented lineage and data quality checksFamiliarity 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 logicVertex 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.
Before you apply
Applying takes about a minute. These four things decide how fast it moves after that.
Your profile is current
It's what we read first. Occupations, seniority and locations matter more than a long history.
Two examples you can talk through
Not a portfolio — just two pieces of work where you can explain the decisions and what you'd change.
A number in mind
What you're on now and what would make you move. We negotiate better when we know both.
Your notice period
Employers plan around it, and it's the question that stalls offers most often.
Once you apply, someone reads it and calls you before anything reaches the employer — usually within two working days.
More like this