Wintrust provides community and commercial banking, specialty finance and wealth management services through its 16 bank charters and nine non-bank businesses. Wintrust delivers the sophisticated solutions of a large bank while staying true to the relationship-focused, personalized service of our community banking roots. We serve clients in all 50 states with more than 200 branch banking locations in Illinois, southwestern Florida, northwestern Indiana, west Michigan and southern Wisconsin and commercial banking offices in Chicago, Denver, Milwaukee, Grand Rapids, Mich., and in key branch banking locations throughout Illinois. Our people are the heart of our business and we are proud to rank consistently as a top place to work. Wintrust is a $66 billion financial institution based in Rosemont, Illinois, and listed on the NASDAQ Global Select Market under the symbol “WTFC.”
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.
Skills Required
- Bachelor's degree in Computer Science, Computer Engineering, Information Systems, Engineering, Math, or related field plus 7 years of related experience OR Master's degree plus 5 years of related experience.
- 5 years of experience in Data Engineering designing and implementing data persistence, processing, and integration.
- 5 years of experience designing and building complete data pipelines for ODS, Staging, Data Warehousing, and Data Marts.
- 5 years of experience processing semi-structured and unstructured files using Microsoft SSIS and SQL.
- Experience processing semi-structured and unstructured files using object-oriented scripting languages such as Python.
- 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, data quality checks, and data classification.
- Experience creating, enhancing, and supporting ETL/ELT processes to ensure business continuity and high performance.
- Experience analyzing requirements and preparing technical specifications and detailed design documents.
- Experience building CI/CD pipelines for data pipelines using Azure DevOps.
Wintrust Financial Corporation Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Wintrust Financial Corporation and has not been reviewed or approved by Wintrust Financial Corporation.
-
Affordable Benefits — Employer covers a large share of medical premiums, making health coverage comparatively low cost. Plan options are broad and pair with HSA/FSA choices and wellbeing programs.
-
Parental & Family Support — Paid maternity, parental, and adoption leave are structured and fully paid, with backup childcare access through Bright Horizons. Adoption assistance and family support resources further strengthen caregiving support.
-
Retirement Support — A 401(k) with a company match and an employee stock purchase plan provide multiple savings and ownership avenues. Match mechanics and plan access are noted features of the total rewards offering.
Wintrust Financial Corporation Insights
What We Do
Wintrust Financial (Wintrust) is a financial services holding company based in Rosemont, Illinois, with $50 billion in assets. Wintrust engages in the business of providing traditional community banking services, wealth management services, commercial insurance premium financing, mortgage origination and more.
Gallery
