Rosemont, IL

Data Jobs in Rosemont, IL

2 jobs found

Include remote jobs

Today

Senior Data Engineer

MMD Services, Inc Rosemont, IL

Rosemont, IL

Today

$130k - $150k/yr Full time Senior Apache Airflow API

Apply Now

Job Description

MMD Services, Inc is hiring a Senior Data Engineer for a hybrid role based in Rosemont, IL. In this position, you will own enterprise-scale data pipelines and cloud data warehouse solutions on AWS, spanning design, implementation, and ongoing production support.

Key Responsibilities

Take ownership of enterprise-scale data pipelines and cloud data warehouse solutions from design through deployment, with a direct impact on how the business operates
Build AWS-based pipelines using modern orchestration tooling to support real analytics workloads across the company
Architect and optimize an AWS Redshift data warehouse for business intelligence and reporting at scale
Drive ETL and data lake architecture decisions, including standards for cataloging and lake formation
Design and implement APIs and API gateway integrations to connect systems and improve data access across the organization
Deliver medallion architecture and modern data standards in practice
Collaborate closely with IT and cross-functional teams in a lean environment where ideas move quickly
Participate across the build lifecycle, including requirements, design, coding, testing, and deployment
Troubleshoot and support production data platforms used daily by the business
Identify broken or outdated components and implement improvements
Mentor less experienced engineers and help set team priorities through demonstrated knowledge
Contribute to the evolution of the data engineering practice as the company scales rapidly

Required Qualifications

Recent, hands-on experience building and supporting AWS solutions, including IAM, S3, API Gateway, Glue (or similar), Lake Formation, Redshift, and relational or NoSQL databases such as RDS and 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 scalable data engineering development
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 layered data architecture standards
Demonstrated, stable and progressive career history with depth in data engineering roles
Strong analytical skills and excellent written and verbal communication
Ability to operate independently with minimal supervision while collaborating effectively across teams

Technical Environment

AWS, IAM, S3, API Gateway, Lambda, Glue, Lake Formation, Redshift, DynamoDB, RDS
Airflow, Terraform, CloudFormation
Python, PySpark
API, Step Functions

Compensation

$130,000.00 - $150,000.00 per year

Benefits

401(k)
401(k) matching
Dental insurance
Health insurance
Life insurance
Paid time off
Professional development assistance
Vision insurance

Work Location

Hybrid remote in Rosemont, IL 60018

View full job page →

2d ago

Senior Data Engineer

Wintrust Financial Corporation Rosemont, IL

Rosemont, IL

2d ago

$161k - $161k/yr Full time Senior Azure DevOps CI/CD

Apply Now

Job Description

Wintrust Financial Corporation is hiring a Senior Data Engineer to design, develop, and continuously improve complex data systems and pipelines. This hybrid role supports the data enablement lifecycle by strengthening transformation workflows, governance practices, and enterprise-ready analytics foundations.

What you’ll do

Design, develop, and continuously improve complex data systems.
Build processes that support data transformations, data structures, metadata, dependency management, and workload management.
Ensure adherence to data governance policies by implementing and validating data lineage, data quality checks, and classification.
Support, enhance, and create Daily/Monthly ETL/ELT processes to ensure business continuity, meeting best-in-class standards with high performance.
Create enterprise datasets that support analytics needs for data scientists and analytics teams.
Develop Conceptual, Logical, and Physical Data Models for data solutions.
Identify opportunities for continuous process improvement, including automating manual work and optimizing data delivery.
Analyze requirements and produce technical specifications and detailed level design documents.
Serve as a resource for escalated issues, and analyze/design specifications for less experienced team members.
Design and implement best-in-class data processing solutions across data modeling, loading, delivery, availability, performance, and security.
Engage across the data enablement lifecycle and mentor less experienced team members as needed.
Design and build complete data pipelines that move and transform data for ODS, Staging, Data Warehousing, Data Marts, MDM, including middleware integrations.
Process semi-structured and unstructured files using traditional SQL and modern object-oriented scripting languages such as Python.
Build CI/CD pipelines for data pipelines using Azure DevOps.

Required qualifications

Master’s degree in Computer Science, Computer Engineering, Information Systems, Engineering, Math, or a related field plus 5 years of experience in a related occupation (or Bachelor’s degree plus 7 years as an alternative).
5 years of data engineering experience designing, implementing data persistence, data processing, and data integration.
5 years designing and building complete data pipelines for ODS, Staging, Data Warehousing, and Data Marts.
5 years processing semi-structured and unstructured files using Microsoft SSIS and SQL.
3 years with medium-scale data and query optimization techniques.
Experience with data warehouse concepts, including 3NF and the Dimensional data model.
Experience implementing and validating data lineage, quality checks, and classification.
Experience creating, enhancing, and supporting ETL/ELT processes for business continuity, best-in-class standards, and high performance.
Experience analyzing requirements and preparing technical specifications and detailed level design documents.
Experience building CI/CD pipelines for data pipelines using Azure DevOps.

Technologies

Python
SQL
Microsoft SSIS
Azure DevOps

Location and schedule

Rosemont, IL (hybrid)
Some telecommuting flexibility, with a requirement to physically be in the Rosemont, IL office once a week.

Compensation

USD 160,555 per year.

Benefits

Eligibility to earn an annual bonus.

View full job page →

Data Jobs in Rosemont, IL

Senior Data Engineer

Senior Data Engineer

Get Data Jobs in Rosemont, IL alerts