Senior Data Analyst

Wintrust Financial Corporation; Rosemont (IL); On-site; USD 98,000 - 130,000; Full time

Benefits offered by this job

Medical Insurance

Dental

Vision

Life insurance

401(k) with company match

Tuition reimbursement

Parental Leave

Employee Assistance Program (EAP)

Stock Purchase Plan at 5% discount

Critical Illness Insurance

Accident Insurance

Transportation and Commuting Benefits

Banking Benefits

Pet Insurance

Job summary

Wintrust Financial Corporation is seeking a Senior Data Analyst to lead data analytics initiatives across the organization. You will translate business needs into actionable data insights, work with stakeholders and engineers, and deliver data-driven solutions using SQL, Python, Power BI, and data warehousing concepts.

The role requires strong technical and communication skills to support enterprise data initiatives and mentor junior analysts.

Qualifications

• Bachelor’s degree required; related field may apply.
• 5+ years of data analysis and data warehousing experience.
• Strong SQL, Python, Power BI, data mapping and data warehousing skills.

Responsibilities

• Lead complex data analysis initiatives from requirements through delivery.
• Collaborate with stakeholders and technical teams to map requirements to technical specifications.
• Perform source-to-target data analysis, profiling, transformation, and data quality checks.
• Query large datasets with SQL to uncover trends and drive data-driven solutions.
• Apply dimensional modeling concepts to support enterprise data initiatives.
• Maintain data documentation and support data governance and quality.

Skills

SQL

Python

Data Analysis

Data Mapping

Data Warehousing

Education

Bachelor’s degree in Computer Science, Data Analytics, Information Science, or a related field

Tools

Power BI

Job description

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

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.

What You’ll Do

• 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

Compensation

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.

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.