VP, Data Engineering (Insurance Experience Required)

Location: Morristown, NJ

Time Type: Full time

Job Description

At Coaction, we’re 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 : $197,000-$270,000 + 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 qualifications.  In 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. Coaction’s 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 [email protected] asking you to contact a member of the Coaction Recruiting Team. Any other method of contact may be fraudulent.