Haystack
← Back to Jobs
Technology

Lead Data Engineer

Acunor InfotechJersey City, NJ🇺🇸United StatesPosted 14 Jul 2026

Quick Overview

Work Type
Hybrid
Level
Mid Senior

Job Description

Job Title: Lead Data Engineer
Location: Jersey City, NJ
We are looking for an experienced Lead Data Engineer to join a growing data engineering team supporting enterprise data modernization initiatives within the Insurance and Financial Services domain. This is a hands-on technical leadership role where you'll design and build scalable cloud-based data solutions while collaborating with cross-functional teams to deliver high-quality data platforms.
Key Responsibilities:
  • Design, develop, and optimize end-to-end data pipelines using PySpark, Snowflake, Python, and AWS.
  • Build scalable ETL/ELT solutions and data warehouse models to support enterprise analytics.
  • Lead cloud data migration and modernization initiatives from legacy platforms.
  • Develop and optimize complex SQL queries, data transformations, and data quality frameworks.
  • Collaborate with business stakeholders to understand requirements and translate them into technical solutions.
  • Coordinate with onshore and offshore engineering teams to ensure timely project delivery.
  • Conduct code reviews, mentor team members, and promote engineering best practices.
  • Troubleshoot performance issues and continuously improve the reliability and scalability of data pipelines.
Required Skills & Experience:
  • 6 9 years of experience in Data Engineering.
  • Strong hands-on experience with Snowflake, including data modeling and performance optimization.
  • Expertise in AWS services such as S3, Glue, Lambda, EMR, Redshift, Step Functions, and CloudWatch.
  • Strong experience with Apache Spark / PySpark, Python, and advanced SQL.
  • Solid understanding of data warehouse design methodologies such as Kimball, Inmon, Data Vault, Star Schema, and Snowflake Schema.
  • Experience with cloud migration and legacy data modernization projects.
  • Familiarity with orchestration tools such as dbt, Apache Airflow, AWS Glue, or similar platforms.
  • Experience working in Insurance, Financial Services, or other regulated industries is preferred.
  • Strong communication, stakeholder management, and technical leadership skills.
  • Experience working in Agile/Scrum environments.

Skills

SQL
AWS
ETL
Scrum
Snowflake
Agile
Airflow
Apache
Apache Spark
Python
Redshift
Stakeholder Management
Vault
dbt

Similar jobs

Apply now