Senior Business Analyst, Scotia Jarislowsky Fraser - Toronto

Scotiabank•Toronto, ON

7d•Onsite

About The Position

The Senior Business Analyst, Scotia Jarislowsky Fraser (SJF) is responsible for the effective development, design and implementation of the core data management and analytical processes of the business. Areas of focus will be twofold with an emphasis on management / sales staff reporting and analytics used to inform and monitor key growth and sales initiatives. Main responsibilities will involve working towards an increase in customer profitability, growth drivers of the business, and production of a central repository of high quality information to support strategic initiatives.

Requirements

University Degree or College Diploma or equivalent
Good knowledge of the broad Wealth Management offering
At least 2 years of related experience with an emphasis on data and trend analysis and research
Strong mathematical aptitude, analytical skills and knowledge of statistical concepts and methodology
Advanced excel knowledge required to effectively write queries, develop reports, analyze data, identify trends and create graphical illustrations for presentations
Proficiency in Power BI, Excel, Microsoft Word, PowerPoint
Strong verbal and written communication skills
Ability to work both as a team member and independently with general oversight
Excellent organizational skills, attention to detail, flexibility and commitment to follow through
Significant level of expertise in the mining, gathering and analyzing of relevant information / data with a focus on maintaining a high level of data validity, effective and efficient extraction of information and the ability to distribute and present results in a highly professional format

Responsibilities

Develop and maintain a central repository of key financial, client and business metrics by leveraging source systems and databases for direct data/information extracts, identifying alternative information sources, compiling/consolidating data/information from multiple sources, gathering information through interviewing, questionnaires, source documents, liaising with other departments and key stakeholders, and organizing the data collected in a clear, consistent manner.
Maintain data integrity of core information sources by ensuring a robust understanding of the underlying information and systems to identify inconsistencies within data sources, addressing systematic issues when required to improve the accuracy of direct data extraction, and taking corrective measures when necessary to correct and validate raw data.
Develop and maintain reporting and analysis for SJF by conducting analysis independently by reviewing, monitoring and analyzing large sets of data to derive trends and important developments, and identifying and investigating issues to ensure validity of conclusions.
Support for strategic growth initiatives by formulating conclusions and provide recommendations to Senior Management based on analysis, and ensuring the analysis is clear, logical, accurate and properly documented.
Own monthly, quarterly and ad-hoc reporting which include business results reporting in the form of robust dashboards (Power BI) leveraging key performance indicators, client management reporting for sales staff to assist in client relationship management and sales prospecting efforts, and compliance adherence reporting.
Support key strategic initiatives within SJF by developing recommendations on how to proceed on key strategic initiatives by formulating conclusions and providing recommendations to Senior Management based on the analysis, and ensuring the analysis is clear, logical, accurate and properly documented.
Track and monitor progress and levels of success (sales trending) by developing and implementing key performance indicators and ensuring a clear and concise process for monitoring results.
Support and execute the administration of the SJF compensation plans by working with internal partners in administration efforts by tracking and monitoring results and assisting in applying parameters/drivers of the compensation plans for measurement, calculating and reconciling compensation factors for purposes of payment, calculating and reconciling quarterly performance scores, reviewing and validating that measurement is accurate and transparent, and developing and maintaining distribution procedures of payment information and supporting data.
Liaise with participants of the plan(s) to address questions or concerns by leveraging repository of client and financial results to investigate payments if required, and maintaining database of non-standard measures that need to be tracked and actioned on a quarterly basis.
Provide Superior Service and Support to SJF Staff by coordinating the development and launch of key initiatives with end users and stakeholders, liaising with and coordinating internal departments to resolve issues being encountered with field staff, identifying and developing tools and resources to assist SJF relationship managers in their efforts to deliver an outstanding client experience, and responding to daily and ad hoc inquiries from the Relationship Managers and Regional and Market Leadership teams.
Contribute to the effective functioning of the SJF Head Office team by participating actively in team learning development activities and team performance achievements, building effective working relationships across the team and with various business lines and corporate function contacts, maintaining a high level of customer service, facilitating a culture of open and honest communication, actively participating and contributing to touch bases and team meetings, encouraging the generation of new ideas and approaches, and actively sharing knowledge and experience to enhance the development of all team members.