Lead Data Engineer

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

Location: 751 Broad Street Newark, New Jersey 07068

• 7 plus years of experience in data engineering, with at least 3 years in technical leadership or lead engineer role.
• Extensive hands‑on experience with AWS data services Glue, Redshift, S3, Lambda, EMR/Spark, Kinesis, Athena, RDS, API Gateway, etc.
• Proficient in programming languages such as Python and SQL.
• Experience with Shell scripting and Scala is a plus. Strong experience designing, implementing, and managing data lakes, data warehouses, and data ingestion pipelines on AWS.
• Proven experience with ETL/ELT processes, data modeling, and big data frameworks. Demonstrated ability to lead, mentor, and coach engineers in a collaborative team environment.
• Experience with DevOps practices, CI CD pipelines, and infrastructure-as-code tools like CloudFormation, Terraform.
• Excellent problem‑solving, communication, and organizational skills.