Senior Data Engineer; SSIS ETL Developer

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

• 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

• 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

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.

• Design, development and continuous improvement of complex data systems.
• Build processes supporting data transformations, data structures, metadata, dependency and workload management.
• Plan and execute unit tests 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 meet best-in-class standards offering high performance.
• Support and maintain existing data solutions for DW, MDM and Middleware systems for operational and analytical applications.

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

• 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

The estimated salary range for this role is $98,000.00 - $, along with…