Senior Data Analyst

About the role

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

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.

Qualifications

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

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

Pay

The estimated salary range for this role is $98,000.00 - $130,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.