Senior Data Engineer

Wintrust Financial Corporation; Rosemont (IL); Hybrid; USD 150,000 - 170,000; Full time

Benefits offered by this job

Annual bonus

Job summary

Wintrust Financial Corporation is seeking a Senior Data Engineer to design, develop, and continuously improve complex data systems and pipelines. This hybrid role strengthens transformation workflows, governance practices, and enterprise analytics foundations in Rosemont, IL.

The ideal candidate brings 5+ years in data engineering, expertise in data lineage, ETL/ELT processes, and hands-on experience with Python, SQL, SSIS, and Azure DevOps.

Qualifications

• Master’s degree in CS/CE/IS/Engineering or related field plus 5 years 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.

Responsibilities

• 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 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.

Skills

ETL/ELT design

Data modeling

Mentoring

Data governance

Education

Master’s degree in Computer Science/Engineering/Information Systems or related field

Bachelor’s degree + 7 years experience alternative

Tools

Python

SQL

Microsoft SSIS

Azure DevOps

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.