Senior Data Analyst

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

Benefits offered by this job

Medical Insurance

Dental Insurance

Vision Insurance

401(k) with company match

Parental Leave

EAP

Job summary

Wintrust Financial Corp is seeking a highly motivated Senior Data Analyst to lead analytics initiatives across the organization. The role focuses on translating business needs into actionable data solutions, leveraging SQL, Python, and data visualization to inform decisions.

You will partner with stakeholders, perform thorough data profiling and mapping, and apply dimensional modeling to support enterprise data initiatives.

Qualifications

• Bachelor's degree in a related field.
• 5+ years of experience in data analysis and data warehousing.
• Strong experience with SQL, Python, Power BI, Data Analysis, Data Mapping, and Data Warehousing.
• Strong hands-on SQL expertise with data profiling and mapping.
• Understanding of data warehousing concepts including star schemas and fact tables.

Responsibilities

• Lead complex data analysis initiatives from requirements through delivery.
• Partner with stakeholders to translate business needs into technical mappings.
• Perform source-to-target data analysis, profiling, and data quality checks.
• Query and analyze large datasets using SQL to identify trends and rules.
• Develop data documentation and support data governance and quality.

Skills

SQL

Python

Data analysis

Data mapping

Data warehousing

Data visualization

Dimensional modeling

Education

Bachelor's degree in Computer Science, Data Analytics, Information Science, or 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.

Wintrust provides community and commercial banking, specialty finance and wealth management services, delivering the sophisticated solutions of a large bank through a relationship-focused approach built from our community banking roots. Wintrust may collect personal information from you in connection with the application process. Wintrust complies with the California Consumer Privacy Act of 2018, and its policy may be found here Click here for Equal Opportunities.