Senior Data Engineer (SSIS ETL Developer)

Wintrust Financial Corporation•Rosemont, IL

7d•$98,000 - $132,000•Hybrid

About The Position

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.

Requirements

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

Nice To Haves

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

Responsibilities

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.