Sr. Data Engineer (AWS)

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

Our client is a large, multi-location, service-based enterprise with well over a thousand sites across the U.S. and Canada. It's in the middle of an aggressive growth phase - recent annual revenue growth in the 20%+ range, a public multi-year plan to nearly double revenue, and a recent public listing that's brought new visibility and momentum to the business.

That scale is exactly what makes this role matter. Every new location, every new system, every new data source adds weight to a platform that's still being built out, which means the work you do here won't sit quietly in the background. It'll show up in how fast the business can see its own data, make decisions, and scale further.

You'll be hands-on across the full AWS data stack including data lakes, analytical warehousing, and pipeline orchestration with real ownership of what you build and the autonomy to make it better. You will work across IAM, S3, API Gateway, Lambda, Glue, Lake Formation, Redshift, DynamoDB, RDS, Airflow, and Terraform/CloudFormation - with the latitude to bring in new tools where they make sense.

Responsibilities:

• Own enterprise-scale data pipelines and cloud data warehouse solutions from design to deployment. Your work directly shapes how the business runs
• Build cloud-based pipelines using modern orchestration tools that power real analytics workloads across the company
• Architect and optimize a Redshift data warehouse that fuels business intelligence and reporting at scale
• Drive ETL and data lake architecture decisions. Your ideas on cataloging and lake formation will shape the standard, not just follow it
• Design and build APIs and API gateway integrations that connect systems and unlock data access across the org
• Bring medallion architecture and modern data standards to life
• Work shoulder to shoulder with IT and cross-functional teams. This is a lean group where every voice matters and good ideas move fast
• Take part in every phase of the build. Requirements, design, coding, testing, deployment.
• Troubleshoot and support production platforms that the business depends on every day
• Spot what's broken or outdated and bring the fix, this team wants people who see a better way and speak up
• Mentor less experienced engineers and help set team priorities, leadership here is earned through knowledge, not just title
• Help shape the data engineering practice as the company scales at a rapid pace. Get in early and leave your fingerprint on how this team grows

Required:

• Recent, hands-on experience building and supporting solutions on AWS, including IAM, S3, API Gateway, Glue or similar data integration services, Lake Formation, Redshift, and relational/NoSQL databases (RDS, DynamoDB)
• Strong working knowledge of a modern workflow orchestration tool for scheduling and managing data pipelines (Airflow, Step Functions, or similar)
• Proficiency in Python and PySpark for building scalable data engineering solutionsExperience developing and integrating APIs, including API gateway configuration
• Solid understanding of relational database concepts and data modeling best practices
• Familiarity with medallion-style or similarly layered data architecture standards
• Stable, progressive career history demonstrating depth of experience in data engineering roles
• Strong analytical skills paired with excellent written and verbal communication
• Comfortable operating independently with minimal supervision, while collaborating effectively across teams

MMD Services Inc. is an equal opportunity employer. All applicants are considered for all positions without regard to race, religion, color, sex, gender, sexual orientation, pregnancy, age, national origin, ancestry, physical/mental disability, medical condition, military/veteran status, genetic information, marital status, ethnicity, alienage, or any other protected classification, in accordance with applicable federal, state, and local laws.