Lead Data Engineer — AWS Data Lakes & Pipelines

SANS Consulting Services, Inc.; Newark (NJ); On-site; USD 130,000 - 180,000; Full time

Job summary

SANS Consulting Services, Inc. in Newark, New Jersey is seeking a data engineering lead with 7+ years of data engineering experience and 3+ years in technical leadership to design and guide scalable data pipelines on AWS.

You will mentor engineers, own data lake and data warehouse architectures, and collaborate across teams to deliver high‑quality data solutions using Python, SQL, and AWS services.

Qualifications

• 7+ years of data engineering experience, including 3+ years in leadership.
• Strong experience designing and managing data lakes and data warehouses on AWS.
• Proficient in Python and SQL; Shell scripting; Scala a plus.
• Experience with DevOps, CI/CD, and IaC (CloudFormation, Terraform).
• Excellent problem-solving and communication skills.

Responsibilities

• Lead, mentor, and coach engineers in a collaborative team.
• Design, implement, and maintain data pipelines on AWS.
• Drive data modeling and ETL/ELT processes and big data frameworks.
• Ensure scalable data infrastructure and data quality across the stack.

Skills

Data engineering

Technical leadership

Python

SQL

Shell scripting

Scala

ETL/ELT design

Big data frameworks

Mentoring engineers

Communication

Problem-solving

Tools

AWS Glue

Amazon Redshift

Amazon S3

AWS Lambda

EMR/Spark

Amazon Kinesis

Amazon Athena

Amazon RDS

API Gateway

CloudFormation

Terraform

Job description

SANS Consulting Services, Inc. in Newark, New Jersey is seeking a data engineering lead with 7+ years of data engineering experience and 3+ years in technical leadership to design and guide scalable data pipelines on AWS.

You will mentor engineers, own data lake and data warehouse architectures, and collaborate across teams to deliver high‑quality data solutions using Python, SQL, and AWS services.