Advanced Data Engineer

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

Why join us?

• An award-winning culture! We are rated a Top Workplace by the Chicago Tribune (past 11 years) and Employee Recommended award by the Globe & Mail (past 6 years)

• Competitive pay and discretionary or incentive bonus eligible

• Comprehensive benefit package including medical, dental, vision, life, a 401k plan with a generous company match and tuition reimbursement to name a few

• Promote from within culture

Why join this team?

• This position has the opportunity to interface with and have a positive impact on multiple areas of Wintrust's business

• We hold ourselves accountable to high standards, share wins, operate ethically, and have fun

Position Overview

Senior Data Engineer is responsible for the 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. This is a senior role that will be engaged in all phases of the Data Enablement lifecycle and will be called upon to mentor less experienced team members as necessary. Successful candidate will have a proven track record demonstrating in-depth technical and business knowledge.

What You’ll Do

• Design, development and continuous improvement of complex data systems.

• Build processes supporting data transformations, data structures, metadata, dependency and workload management.

• Plans and executes unit test to ensure the developed code is free of functional defects.

• Design systems that reliably and efficiently provide interactive query performance on large amounts of multi-modal data.

• 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 meets best-in-class standards offering high performance.

• Support and maintain existing data solutions for DW, MDM and Middleware systems for operational and analytical applications.

Qualifications

• Bachelor’s degree with 7+ years’ experience or Master’s degree with 5+ years’ experience in Computer Science, Engineering, Math, or other quantitative field.

• 5+ years’ experience in Data Engineering - designing, implementing data persistence, data processing, data integration and MDM Solutions.

• Experience with building CICD pipelines for data pipelines using Azure DevOps is a plus.

• Experience in designing and building complete data pipelines moving and transforming data for ODS, Staging, Data Warehousing and Data Marts, MDM, including Middleware Integrations.

• Strong understanding of DW concepts including 3NF and Dimensional data models, Middleware concepts for modern integration infrastructures such as API management and ESB, and MDM Concepts.

Benefits

Medical Insurance • Dental • Vision • Life insurance • Accidental death and dismemberment • Short-term and long-term Disability Insurance • Parental Leave • Employee Assistance Program (EAP) • Traditional and Roth 401(k) with company match • Flexible Spending Account (FSA) • Employee Stock Purchase Plan at 5% discount • Critical Illness Insurance • Accident Insurance • Transportation and Commuting Benefits • Banking Benefits • Pet Insurance

Compensation

The estimated salary range for this role is $85,000.00 - $110,000.00, along with eligibility to earn an annual bonus. Actual salaries may vary based on several factors, such as a candidate’s qualifications, skills and experience.

#LI-Hybrid

#LI-JB1

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.