Senior AWS Data Engineer — Real-Time Data & Lakehouse

Capgemini; New York (NY); Hybrid; USD 81,000 - 91,000; Full time

Benefits offered by this job

Paid time off (vacation, holidays, and

Sick leave

Medical, dental, vision coverage

401(k) retirement plan

Job summary

Capgemini is seeking an experienced AWS Data Engineer to design and optimize scalable cloud-based data solutions. You will build ETL/ELT pipelines, develop real-time ingestion, and shape data lakes and warehouses on AWS.

The role requires 5+ years in data engineering, strong Python/SQL skills, and experience with S3, Redshift, Glue, and EMR. Hybrid work from Day 1 in Whippany, NJ with strong collaboration across teams.

Qualifications

• 5+ years of experience in Data Engineering and cloud-based data platforms.
• Hands-on with AWS data services (S3, Redshift, Glue, Athena, EMR, DynamoDB).
• Proficiency in Python, SQL, Spark; ETL/ELT development and data warehouse design.
• Experience with real-time data processing and distributed architectures.
• Knowledge of Terraform/CloudFormation, CI/CD, and DevOps.

Responsibilities

• Design and implement scalable data architectures on AWS (S3, Redshift, Glue, Athena, EMR).
• Build and optimize ETL/ELT pipelines for structured and unstructured data.
• Develop real-time and batch ingestion pipelines using AWS services and Kafka.
• Tune data models, schemas, partitioning, and query performance.
• Automate IaC and CI/CD pipelines; monitor pipelines and security practices.

Skills

AWS

Python

SQL

Spark

ETL/ELT

Data modeling

Problem solving

Communication

Education

Bachelor's degree in CS/IT/Engineering

Tools

S3

Redshift

Glue

Athena

EMR

DynamoDB

Lambda

Kinesis

Kafka

Terraform

CloudFormation

Airflow

Job description

Capgemini is seeking an experienced AWS Data Engineer to design and optimize scalable cloud-based data solutions. You will build ETL/ELT pipelines, develop real-time ingestion, and shape data lakes and warehouses on AWS.

The role requires 5+ years in data engineering, strong Python/SQL skills, and experience with S3, Redshift, Glue, and EMR. Hybrid work from Day 1 in Whippany, NJ with strong collaboration across teams.