Senior Data Engineer

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.