Senior AWS Data Engineer: Data Lakes, Redshift & Pipelines

MMD Services; Rosemont (IL); On-site; USD 120,000 - 150,000; Full time

Job summary

MMD Services is seeking a hands-on Data Engineer to own enterprise data pipelines and a cloud data warehouse in a rapid-growth environment in Rosemont, IL. You’ll work across AWS services (IAM, S3, Glue, Redshift) and modern orchestration (Airflow) to deliver scalable data solutions and analytics capabilities.

You'll design, build, test, and deploy data pipelines, mentor junior engineers, shape data architecture, and collaborate with IT and business teams to enable fast, data-driven decisions

Qualifications

• Recent hands-on AWS experience with data services and databases.
• Strong Python and PySpark skills for scalable data engineering.
• Experience building APIs and API gateway integration.
• Familiarity with data warehousing and modern ETL/ELT patterns.
• Solid knowledge of relational and NoSQL databases and data modeling.
• Experience with medallion-style data architectures is a plus.
• Able to work independently and communicate effectively.

Responsibilities

• Own enterprise-scale data pipelines and cloud data warehouse solutions from design to deployment.
• Build cloud-based pipelines using modern orchestration tools to power analytics workloads.
• Architect and optimize a Redshift data warehouse for BI and reporting at scale.
• Drive ETL and data lake architecture decisions and lake formation standards.
• Design and build APIs and API gateway integrations to unlock data access.
• Apply medallion architecture concepts to data platforms.
• Collaborate with IT and cross-functional teams in a lean environment.
• Participate in all phases: requirements, design, coding, testing, deployment.
• Troubleshoot and support production platforms essential to the business.
• Identify improvements and advocate for better data solutions.
• Mentor less experienced engineers and help set team priorities.
• Help shape the data engineering practice as the company scales.

Tools

Python

PySpark

Airflow

API Gateway

Terraform

CloudFormation

Redshift

DynamoDB

RDS

S3

Glue

Lake Formation

Job description

MMD Services is seeking a hands-on Data Engineer to own enterprise data pipelines and a cloud data warehouse in a rapid-growth environment in Rosemont, IL. You’ll work across AWS services (IAM, S3, Glue, Redshift) and modern orchestration (Airflow) to deliver scalable data solutions and analytics capabilities.

You'll design, build, test, and deploy data pipelines, mentor junior engineers, shape data architecture, and collaborate with IT and business teams to enable fast, data-driven decisions