VP Business Analytics (Hybrid)

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

• We employ approximately 300 associates and are responsible for more than $35+ billion in assets
• Strong track record of valuing and investing in existing talent by providing opportunities for growth and advancement
• We hold ourselves to the highest standard of service and integrity in the industry
• We have a strong reputation for quality service and impeccable ethics
• What You Will Do :
• The ideal candidate will be responsible for various data warehouse / business intelligence functions including, but not limited to the following :
• Partners with managers across the firm to build business intelligence and management information in support of business processes and decisions.
• Partners with the technology department, to ensure cost-effective design, development, implementation and maintenance of the wealth management data warehouse platform and reporting capabilities.
• Creates, runs and / or monitors daily data processing updates from / to various third-party vendors and resolve data transfer issues.
• Performs quality control and data validation processes of data housed within the Data Warehouse.Data Collection and validation :
• Establishes, performs and documents procedures for data preparation including data cleaning, validation, standardization and analysis.
• Educates front line data entry individuals on data quality standards and availability of clearing firm and direct to firm customer information.
• Creates various exception and control reports to improve the quality of data
• Coordinates the scheduling, receipt and transfer of data from / to third parties and internal sources; ensuring appropriate transformation into appropriate databases.
• Partners with management and technology teams to assess and improve data warehousing software and hardware solutions.
• Troubleshoots, resolves and escalates, data submission errors and data error issues that impact the business unit databases.
• Coordinates file layout updates from vendors with responsible parties.
• Provides on-going ideas for the improvement of corporate-wide reporting. Strategy, Data Reporting and Analysis
• Serves as leader in “translating” data warehouse information to end user business requirements
• Partners with users throughout the business units to understand their current and future reporting needs and creates plans to meet their needs.
• Prepares ad hoc reporting and analysis for regulators and various functions of the firm as needed i.e. sales management, compliance, operations and finance.
• Coordinates with the technology team on access and use of data sources outside of wealth management, however relevant to the business strategy.
• Creates, schedules and runs user-defined monthly, quarterly and annual data reports for various firm functions that are available on demand through reporting portals and tools.
• Employs a “playing with the data” mentality to lead sessions with senior management on how to define and use data across businesses.
• Develops and maintains a public access and / or limited access data research portal for Executive Management.The position will report to the Business Line Information Systems Officer for Wealth Management.
• Qualifications :
• Bachelor’s degree in Computer Sciences, Analytics, Finance, Business or Engineering
• 5 – 10 years of experience working with financial data
• 5 years - SSIS – SQL Services Information Services
• 5 years - SSRS – SQL Server Reporting Services
• 5 years of experience in a data visualization tool (i.e. Power BI, Tableau, Alteryx)
• 3 - 5 years of experience with ETL (Extract Transform and Load) processes
• Background in the creation and maintenance of databases and business intelligence platforms
• Understands Data Governance Concepts, Data Profiling and external file transfer processes
• Proven ability to lead discussions / sessions and to create deliverables based on stated business objectives
• Ability to translate business objectives into relevant data structures, business intelligence and analytics
• Excellent communication skills, both verbal and written
• Ability to multi-task and meet deadlines
• Exceptional interpersonal skills and the ability to foster a collegial team environment across all companies, departments, and disciplines
• 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 $117,000 - $158,000, 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.#LI-HYBRIDFrom 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.
• An award-winning culture! We are rated a Top Workplace by the Chicago Tribune (past 9 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
• Family-friendly work hours
• With 175+ community bank locations, we offer opportunities to grow and develop in your career
• Promote from within culture

#J-18808-Ljbffr