Senior Data Engineer - End-to-End Pipelines & Data Quality

JCW Group; New York (NY); On-site; USD 120,000 - 160,000; Full time

Job summary

JCW Group has partnered with a leading specialty insurance MGA to hire a Data Engineer who will own the full data ingestion function, from pipeline design and orchestration through data quality and reliability. You will ship production pipelines end-to-end, ensure carrier feeds, policy and claims data land cleanly, and maintain trust in the data before it reaches the business or analytics layers.

This hands-on role thrives in a lean team where your judgment is visible and your work has direct

Qualifications

• 5+ years in data engineering or a closely related role.
• Strong SQL and Python.
• Hands-on experience with a cloud data warehouse such as Snowflake, BigQuery, or Redshift.
• Genuine ownership experience with data ingestion and ELT tools such as Fivetran or Airbyte, not just managing a pre-built setup.
• Experience with pipeline orchestration tools such as Airflow, Dagster, Prefect, or dbt Cloud.
• Solid grounding in relational databases including SQL Server or Azure SQL.
• Track record of owning pipelines end-to-end in production with accountability for failures and fixes.
• Experience with insurance, MGA, or financial services data a plus.
• Familiarity with bordereaux, carrier reporting, or regulated data reporting a plus.
• Salesforce data integration experience and working knowledge of dbt a plus.
• Exposure to AI/ML or LLM-based tooling and awareness of NY DFS cybersecurity regulation a plus.

Responsibilities

• Own the full data ingestion function from pipeline design to data quality and reliability.
• Ensure carrier feeds, policy and claims data arrive on time and land cleanly.
• Own pipelines end-to-end in production with accountability for failures and fixes.
• Collaborate with analytics to provide trusted data for business insights.

Skills

SQL

Python

Data ingestion

Tools

Snowflake

BigQuery

Redshift

Fivetran

Airbyte

Airflow

Dagster

Prefect

dbt Cloud

SQL Server

Azure SQL

Job description

JCW Group has partnered with a leading specialty insurance MGA to hire a Data Engineer who will own the full data ingestion function, from pipeline design and orchestration through data quality and reliability. You will ship production pipelines end-to-end, ensure carrier feeds, policy and claims data land cleanly, and maintain trust in the data before it reaches the business or analytics layers.

This hands-on role thrives in a lean team where your judgment is visible and your work has direct