VP Business Analytics (Hybrid) at Wintrust

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 usAn 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 eligibleComprehensive benefit package including medical dental vision life a 401k plan with a generous company match and tuition reimbursement to name a fewFamily-friendly work hoursWith 175 community bank locations we offer opportunities to grow and develop in your careerPromote from within cultureWhy join this teamWe employ approximately 300 associates and are responsible for more than $35 billion in assetsStrong track record of valuing and investing in existing talent by providing opportunities for growth and advancementWe hold ourselves to the highest standard of service and integrity in the industryWe have a strong reputation for quality service and impeccable ethicsWhat 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 dataCoordinates 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 AnalysisServes as leader in translating data warehouse information to end user business requirementsPartners 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:Bachelors degree in Computer Sciences Analytics Finance Business or Engineering5 10 years of experience working with financial data5 years - SSIS SQL Services Information Services5 years - SSRS SQL Server Reporting Services5 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) processesBackground in the creation and maintenance of databases and business intelligence platformsUnderstands Data Governance Concepts Data Profiling and external file transfer processesProven ability to lead discussions / sessions and to create deliverables based on stated business objectivesAbility to translate business objectives into relevant data structures business intelligence and analyticsExcellent communication skills both verbal and writtenAbility to multi-task and meet deadlinesExceptional interpersonal skills and the ability to foster a collegial team environment across all companies departments and disciplinesBenefits: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 InsuranceCompensation:The estimated salary range for this role is $117000 - $158000 along with eligibility to earn an annual bonus. Actual salaries may vary based on several factors such as a candidates 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.Required Experience:Exec Key Skills Business Development,Financial Services,Revenue Growth,Accounting,Account Management,CRM,Client Relationships,Market Research,Project Management,Strategic Initiatives,Business Relationships,Business Strategy,Sales Goals,Sales Process,Product Development Employment Type : Full-Time Experience: years Vacancy: 1