VP, Data Engineering (Insurance Experience Required)

At Coaction were a unique mix of leaders achievers thinkers and team players with a high-performance mindset and a diverse skillset. We bring our industry expertise together to continually push the boundaries of what insurance can be for our clients.

We are seeking a hands-on Data Engineering leader to modernize our enterprise data platform and accelerate migration from legacy datamarts to a scalable AWS-based analytics ecosystem.

This role will lead CI/CD enablement for data pipelines implement DataOps best practices and ensure reliable high-quality governed data delivery across underwriting claims actuarial finance and operations domains.

The ideal candidate combines deep technical expertise in cloud data engineering with strong operational discipline enabling fast safe releases while improving reliability scalability and auditability.

Key Responsibilities

Data Platform Modernization (Legacy AWS/Redshift)
Lead migration of legacy datamarts and transformation logic into Amazon Redshift.
Refactor legacy stored procedures and scripts into modular version-controlled ELT pipelines.
Define dimensional modeling and data mart standards aligned to insurance business domains.
Establish structured cutover and decommission strategy for legacy environments.

CI/CD & DataOps Engineering Excellence
Design and implement CI/CD pipelines for data engineering workflows.
Establish code review standards automated testing and controlled deployment processes.
Implement automated validation gates including schema validation reconciliation checks and business rule tests.
Drive release discipline and rollback strategies for production stability.

Pipeline Engineering & Reliability
Design scalable batch and incremental ETL/ELT pipelines.
Implement orchestration monitoring alerting retry logic and operational runbooks.
Optimize Redshift performance workload management and cost controls.
Ensure production-grade resilience and disaster recovery readiness.

Data Quality & Observability
Implement data quality engineering framework (completeness accuracy timeliness consistency).
Establish observability metrics such as pipeline success rate SLA adherence and incident resolution time.
Partner with governance stakeholders to ensure lineage metadata and audit compliance.

Business & Domain Partnership
Partner with Underwriting Claims Actuarial and Finance teams to ensure trusted data products.
Enable domain-aligned data models and consistent KPI definitions.
Support analytics and advanced modeling readiness through stable data foundations.

Required Qualifications

• Experience in insurance is must
• Understanding of Data Domains Data Products is must
• 10 years of experience in Data Engineering with production-scale pipelines
• Strong expertise in SQL and Python.
• Proven experience implementing CI/CD for data pipelines (GitHub Actions Azure DevOps Jenkins or similar).
• Strong AWS experience including Amazon Redshift S3 IAM and orchestration tools.
• Experience migrating legacy data warehouse/datamart systems to modern cloud platforms.
• Strong understanding of data modeling and warehouse optimization.
  

Preferred Qualifications

• Experience with dbt or similar transformation frameworks in AWS.
• Knowledge of data quality frameworks (Great Expectations Deequ etc.).
• Infrastructure-as-Code experience
• Experience implementing data observability and monitoring platforms.
• Exposure to regulatory and audit requirements in insurance environments.

Salary range specific to for this role : $197000-$270000 discretionary incentive bonus benefits depends on various factors including without limitation individual and organizational performance. The offered rate of compensation will be based on individual education experience and addition employees are eligible for standard benefits package including paid time off medical dental and retirement.

Equal Opportunity Employer

Coaction is an Equal Employment Opportunity employer. Coactions policy is not to discriminate against any applicant or employee based on race color religion national origin gender age sexual orientation gender identity or expression marital status mental or physical disability and genetic information or any other basis protected by applicable law. Coaction also prohibits harassment of applicants or employees based on any of these protected categories.

If your application is selected you will receive an email directly from the Coaction Recruiting Team at asking you to contact a member of the Coaction Recruiting Team. Any other method of contact may be fraudulent.