W

Wintrust

Community banking and wealth management provider

Senior Data Analyst

Data AnalysisPosted on Nov 10
Full-timeRosemont, IL, USAIn-person

About the Job

Requirements

  • A bachelor's degree in Computer Science, Data Analytics, Information Science, or a related field is required.
  • At least five years of experience in data analysis and data warehousing, including experience supporting complex enterprise data projects, is required.
  • Strong experience with SQL, Python, Power BI, data analysis, data mapping, and data warehousing is required.
  • Demonstrated hands-on SQL expertise performing complex data analysis, data profiling, and source-to-target data mapping is required.
  • A strong understanding of data warehousing and data modeling concepts, including dimensional modeling, star schemas, dimension tables, and fact tables, is required.
  • The 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 is required.

Responsibilities

  • Lead complex data analysis initiatives from initial requirements gathering and problem definition through analysis, mapping, documentation, and delivery.
  • Partner with business stakeholders and technical teams to understand business needs and translate requirements into detailed technical mappings and specifications.
  • Perform 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 data warehousing and dimensional modeling concepts, including star schemas, dimension tables, and fact tables, to support enterprise data initiatives.
  • Develop and maintain data documentation while supporting data governance standards, data quality, and integrity across assigned projects.
  • Collaborate with data engineers, data architects, analysts, and business users while developing domain expertise and providing guidance and mentorship to junior analysts.

About the Company

Wintrust

Community banking and wealth management provider

Wintrust is a financial holding company that coordinates a family of banks to offer community and commercial banking, wealth management, premium financing for insurance, and mortgage origination across 175+ locations in the Midwest and Florida. Customers access services through checking and savings accounts, loans and lines of credit, cash management, and investment advisory; premium financing spreads insurance payments over time; mortgage origination helps clients obtain home loans. It differentiates itself by serving distinct local markets with a broad set of tailored banking and financial services across a wide regional footprint. The company aims to provide accessible, comprehensive financial solutions to individuals and businesses while expanding its network of community banks and financial services.

Company size
1,001-5,000
Company stage
IPO
Headquarters
Rosemont, IL
Founded
1995

Recently Posted Jobs

Explore more opportunities at Wintrust

See more jobs