Sr AWS Data Engineer (Hybrid in Rosemont)

MMD Services; Rosemont (IL); On-site; USD 125,000 - 180,000; Full time

Job summary

MMD Services Inc. is seeking a Senior Data Engineer to own enterprise-scale data pipelines and cloud data warehouses. You will design, build, and support modern data infrastructure while collaborating with IT to advance data practices.

Responsibilities include architecting Redshift solutions, ETL, data lake design, API integrations, and mentoring peers in a lean, fast-moving environment near Chicago. Strong AWS and Python/PySpark skills are essential.

Qualifications

• 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 solutions.
• Experience 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.
• Openness to supporting legacy systems alongside newer technologies.

Responsibilities

• Own enterprise-scale data pipelines and cloud data warehouse solutions from design to deployment.
• 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.

Skills

Python

PySpark

API development

Data pipeline design

Data modeling

Analytical skills

Communication

Independent worker

Tools

AWS

S3

IAM

API Gateway

Glue

Redshift

Lake Formation

RDS

DynamoDB

Job description

Our client, a Chicago-staple in the collision and auto body industry, is looking to hire a Sr Cloud Security Engineer!

Please note! We place high value on collaboration and the value that in-person work offers. We need someone who can commit to three days onsite in Rosemont, just outside Chicago!

We are seeking a Senior Data Engineer to take ownership of enterprise-scale data pipelines and cloud data warehouse solutions. This individual will work independently to design, build, and support modern data infrastructure, while partnering closely with the broader IT organization to advance the team's data engineering practices. This is an excellent opportunity for an experienced data engineer who thrives on solving complex problems, mentoring peers, and driving technical improvements across the organization.

What You'll Do

• 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 solutions
• Experience 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
• Openness to supporting legacy systems alongside newer technologies

Nice to Have

• Exposure to AI or machine learning tooling within a data engineering context (e.g., feeding pipelines into ML models, working with AWS AI services like SageMaker, or supporting AI-driven analytics use cases)

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.