Senior Data Analyst

Wintrust Financial Corp.; Illinois; On-site; USD 98,000 - 130,000; Full time

Benefits offered by this job

Medical Insurance

Dental

Vision

Life insurance

Disability Insurance (Short/Long Term)

401(k) with company match

FSA

Employee Stock Purchase Plan

Job summary

Wintrust Financial Corp. in Rosemont, IL seeks a Senior Data Analyst to lead analytics initiatives from problem definition through delivery.

You will partner with business stakeholders and data engineers to translate requirements into actionable data solutions and ensure data quality and governance across projects. The role requires hands-on SQL and Python, experience with data warehousing, and the ability to communicate complex findings to both technical and non-technical audiences.

Qualifications

• Bachelor's degree in a relevant field and 5+ years of data analytics/warehousing experience.
• Strong SQL and Python skills with data profiling and mapping experience.
• Experience with data warehousing concepts, star schemas, and data governance.

Responsibilities

• Lead complex analytics initiatives from requirements through delivery.
• Collaborate with stakeholders to translate business needs into data solutions.
• Perform source-to-target data analysis, profiling, and quality checks.
• Develop and maintain data documentation and data governance alignment.

Skills

SQL

Python

Data analysis

Data mapping

Data warehousing

Education

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

Tools

Power BI

Job description

## Senior Data AnalystApply: Rosemont, IL: Full time: Posted Yesterday: 261731Wintrust 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.