Senior Data Engineer

Wintrust Financial Corporation; California (MO); Hybrid; USD 144,000 - 177,000; Full time

Job summary

Wintrust Financial Corporation is seeking a senior Data Engineer to design and enhance complex data systems, build robust data pipelines, and ensure governance and quality across data assets. The role includes mentoring team members and delivering scalable data solutions across ODS, Staging, and Data Warehouses.

The candidate will work in a hybrid environment in Rosemont, IL, with emphasis on ETL/ELT, data modeling, and CI/CD practices using Azure DevOps.

Qualifications

• Bachelor’s degree in CS/CE/IS/Engineering/Math plus 7 years of related experience.
• Alternatively, a Master’s degree plus 5 years of related experience.
• 5 years of Data Engineering experience designing, implementing data persistence and integration.
• 5 years building complete data pipelines for ODS, Staging, Data Warehousing and Data Mart.
• 5 years processing semi-structured and unstructured files using SSIS and SQL.
• 3 years of experience with medium-scale data and query optimization techniques.
• Experience with Data Warehouse concepts, including 3NF and dimensional models.
• Experience in implementing and validating data lineage, quality checks, classification.
• Experience creating, enhancing, and supporting ETL/ELT processes for business continuity.
• Experience building CI/CD pipelines for data pipelines using Azure DevOps.

Responsibilities

• Design, develop, and improve complex data systems.
• Build processes supporting data transformations, structures, metadata, and workloads.
• Ensure data governance policies through lineage and quality checks.
• Support ETL/ELT processes to ensure business continuity and performance.
• Create enterprise data sets for analytics and data science teams.
• Model data as conceptual, logical, and physical designs.
• Mentor junior teammates and lead data enablement initiatives.
• Develop data pipelines for ODS, Staging, Data Warehousing, and Data Marts.
• Create and support data pipelines and middleware integrations.
• Build CI/CD pipelines for data pipelines using Azure DevOps.

Skills

Data Engineering

ETL/ELT

SQL

Python

Data Modeling

Azure DevOps

CI/CD

Data Governance

Education

Bachelor’s degree in Computer Science / Computer Engineering / Information Systems / Engineering / Math

Master’s degree in related field

Tools

SSIS

Azure DevOps

SQL

Job description

Location:

Job location –Rosemont, IL- Hybrid position with some telecommuting flexibility, but requirement to physically be in the Rosemont, IL office once a week.

Responsibilities:

• Design, develop, and continuously improve complex data systems.
• Build processes supporting data transformations, data structures, metadata, dependency, and workload management.
• Ensure data governance policies are followed by implementing and validating data lineage, quality checks, classification etc.
• Support/enhance/create Daily/Monthly ETL/ELT processes to ensure business continuity, ensuring all related data pipelines meet best-in-class standards, offering high performance.
• Create enterprise data sets for analytics and data scientist team members for advanced analytics.
• Create Conceptual/Logical/Physical Data Models for all data solutions.
• Seek opportunities to deliver continuous process improvement, automating manual processes and optimizing data delivery.
• Analyze the requirements and prepare technical specifications and detailed level design documents.
• Serve as a resource to internal and third‑party team members on escalated issues and analyze and design specifications for less experienced team members.
• Sees opportunities to deliver continuous process improvement, automating manual processes and optimizing data delivery.
• Design, development, test, and implementation of best‑in‑class Data Processing solutions for the organization, including Data Modeling, Data Loading, Data delivery, Data availability, Performance, and Security.
• Engage in all phases of the Data Enablement lifecycle and will be called upon to mentor less experienced team members as necessary.
• Design and build complete data pipelines moving and transforming data for ODS, Staging, Data Warehousing and Data Marts, MDM, including Middleware Integrations.
• Process semi structured and unstructured files using different traditional SQL and modern object‑oriented scripting languages such as Python, etc.
• Build CICD pipelines for data pipelines using Azure DevOps.

Requirements:

Requires a Bachelor’s degree in Computer Science, Computer Engineering, Information Systems, Engineering, Math, or a related field of study plus 7 years of experience in a related occupation. As an equivalent alternative, employer will also accept a 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

The position also requires:

• 5 years of experience in Data Engineering, designing, implementing data persistence, data processing, and data integration.
• 5 years of experience in designing and building complete data pipelines moving and transforming data for ODS, Staging, Data Warehousing and Data Mart.
• 5 years of experience in 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 the Dimensional data model.
• Experience in implementing and validating data lineage, quality checks, classification.
• Experience in creating, enhancing, and supporting ETL/ELT processes to ensure business continuity, meet best‑in‑class standards and offer high performance.
• Experience in analyzing the requirements, preparing technical specifications and detailed level design documents.
• Experience in building CICD pipelines for data pipelines using Azure DevOps.

Compensation

The salary for this role is $160,555.00, along with eligibility to earn an annual bonus.

From our first day in business, Wintrust has been proud to serve a variety of unique communities and people from all walks of life. To build a company that reflects the communities we serve, we believe that fostering a unique and inclusive workplace where everyone feels valued and empowered to succeed will support our ongoing success. Wintrust Financial Corporation, including community banking and financial services subsidiaries, is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, national origin, disability, veteran status, genetic information, and other legally protected categories.