Senior Data Analyst

Wintrust•Rosemont, IL

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.” 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: We are seeking a highly motivated and experienced Senior Data Analyst to join our growing team and play a key role in driving data informed decision making across the organization. This individual will lead complex analytics initiatives from problem definition through delivery, partnering closely with business stakeholders to translate business needs into actionable insights and data driven solutions. The ideal candidate combines strong technical expertise in SQL, Python, data visualization, and data analysis with the business acumen and communication skills needed to work effectively with both technical and non-technical stakeholders. This is a hands-on role for someone who can independently manage analytics projects, identify meaningful trends and opportunities within data, and communicate findings that influence business decisions.

Requirements

Bachelor’s degree in Computer Science, Data Analytics, Information Science, or a related field.
5+ years of experience in data analysis and data warehousing, including experience supporting complex enterprise data projects.
Strong experience with SQL, Python, Power BI, Data Analysis, Data Mapping, and Data Warehousing.
Strong hands-on SQL expertise with demonstrated experience performing complex data analysis, data profiling, and source-to-target data mapping.
Strong understanding of data warehousing and data modeling concepts, including dimensional modeling, star schemas, dimension tables, and fact tables.
Demonstrated ability to independently analyze source data, work through ambiguous requirements, and partner with business and development teams to translate business requirements into technical mappings and data solutions.

Responsibilities

Lead complex data analysis initiatives, taking ownership of assignments from initial requirements gathering and problem definition through analysis, mapping, documentation, and delivery.
Partner directly with business stakeholders and technical teams to understand business needs and translate requirements into detailed technical mappings and specifications.
Perform comprehensive source-to-target data analysis and mapping, including data profiling, validation, transformation requirements, and identification of data quality issues.
Query and analyze large, complex datasets using SQL to identify relationships, trends, anomalies, and business rules and support data-driven solutions.
Apply strong data warehousing and dimensional modeling concepts, including star schemas, dimension tables, and fact tables, to support enterprise data initiatives.
Develop and maintain clear data documentation while supporting data governance standards, data quality, and integrity across assigned projects.
Collaborate closely with data engineers, data architects, analysts, and business users while developing domain expertise and providing guidance and mentorship to junior analysts.