Rosemont, IL

Engineer 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

Lead the design and delivery of enterprise data pipelines and cloud data warehouse capabilities on AWS in a hybrid role based in Rosemont, IL.

Responsibilities

Own enterprise-scale data pipelines and cloud data warehouse solutions from design through deployment
Build cloud-based pipelines using modern orchestration tools for company-wide analytics workloads
Architect and optimize a Redshift data warehouse to support business intelligence and reporting at scale
Own ETL and data lake architecture decisions, including cataloging and lake formation standards
Design and implement APIs and API gateway integrations to connect systems and enable data access across the organization
Bring medallion architecture and modern data standards into production
Collaborate closely with IT and cross-functional teams in a lean environment
Participate across the build lifecycle: requirements, design, coding, testing, and deployment
Troubleshoot and support production platforms used in day-to-day business operations
Identify broken or outdated components and drive improvements
Mentor less experienced engineers and contribute to team priorities
Help shape the data engineering practice as the company scales rapidly

Requirements

Hands-on experience building and supporting solutions on AWS, including IAM, S3, API Gateway, and Glue (or similar), plus Lake Formation and Redshift
Experience with relational and NoSQL databases, including RDS and DynamoDB
Strong knowledge of a workflow orchestration tool for scheduling and managing pipelines (e.g., Airflow, Step Functions, or similar)
Proficiency in Python and PySpark for scalable data engineering
Experience developing and integrating APIs, including API gateway configuration
Solid understanding of relational database fundamentals and data modeling best practices
Familiarity with medallion-style or similarly layered data architecture standards
Stable, progressive career history with depth in data engineering roles
Strong analytical skills and excellent written and verbal communication
Ability to work independently with minimal supervision while collaborating across teams

Technologies

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

Compensation

$130,000 - $150,000 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 seeking a Senior Data Engineer to design, build, and continuously improve complex data systems and pipelines that support analytics and data science needs. This hybrid role is based in Rosemont, IL, with an expectation to be in the Rosemont office once a week.

In this position, you will focus on end-to-end data enablement, including ETL/ELT development, data modeling, governance practices such as lineage and quality validation, and performance and security of data processing solutions. The role also includes implementing CI/CD pipelines for data workflows using Azure DevOps.

What you’ll do

Design, develop, and continuously improve complex data systems.
Build processes for data transformations and structures, including metadata, dependencies, and workload management.
Ensure data governance policies are followed through implementation and validation of data lineage, quality checks, and classification.
Support, enhance, and create Daily/Monthly ETL/ELT processes to ensure business continuity and deliver high performance with best-in-class standards.
Create enterprise data sets for analytics and data scientist teams to support advanced analytics.
Develop Conceptual/Logical/Physical Data Models for data solutions.
Identify opportunities for continuous process improvement by automating manual steps and optimizing data delivery.
Analyze requirements and prepare technical specifications and detailed level design documents.
Act as a resource for internal and third-party team members on escalated issues and provide analysis and design support for less experienced team members.
Design, develop, test, and implement best-in-class data processing solutions, including 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 data pipelines that move and transform data for ODS, Staging, Data Warehousing and Data Marts, MDM, including middleware integrations.
Process semi-structured and unstructured files using SQL and modern object-oriented scripting languages such as Python.
Build CI/CD pipelines for data pipelines using Azure DevOps.

Required qualifications

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

Technologies

Python
SQL
Microsoft SSIS
Azure DevOps

Compensation and benefits

Salary: USD 160,555 per year.
Eligibility to earn an annual bonus.

Location

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

View full job page →

Engineer Jobs in Rosemont, IL

Senior Data Engineer

Senior Data Engineer

Get Engineer Jobs in Rosemont, IL alerts