Title:  Senior Business Analyst, Scotia Jarislowsky Fraser - Toronto

Requisition ID: 264667 

Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture.

Purpose of Job

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.

Is this role right for you? In this role you will:
1. Develop and maintain a central repository of key financial, client and business metrics

Gather data and key information 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
• 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
• 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
• 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
• 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
• Compliance adherence reporting 

2. Support key strategic initiatives within SJF

Develop recommendations on how to proceed on key strategic initiatives by:

• Formulating conclusions and providing recommendations to Senior Management based on the analysis
• 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
• Ensuring a clear and concise process for monitoring results

3. Support and execute the administration of the SJF compensation plans  

Work 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
• 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
• Maintaining database of non-standard measures that need to be tracked and actioned on a quarterly basis 

4. Provide Superior Service and Support to SJF Staff by:

• Co-ordinating 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
• Responding to daily and ad hoc inquiries from the Relationship Managers and Regional and Market Leadership teams.  

5. 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
• Actively share knowledge and experience to enhance the development of all team members

Do you have the skills that will enable you to succeed in this role? We would love to work with you if you have:

• University Degree or College Diploma or equivalent
• Must have 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

#SWM

Location(s):  Canada : Ontario : Toronto 

Scotiabank is a leading bank in the Americas. Guided by our purpose: "for every future", we help our customers, their families and their communities achieve success through a broad range of advice, products and services, including personal and commercial banking, wealth management and private banking, corporate and investment banking, and capital markets.  

At Scotiabank, we value the unique skills and experiences each individual brings to the Bank, and are committed to creating and maintaining an inclusive and accessible environment for everyone. If you require accommodation (including, but not limited to, an accessible interview site, alternate format documents, ASL Interpreter, or Assistive Technology) during the recruitment and selection process, please let our  Recruitment team know. If you require technical assistance, please click here. Candidates must apply directly online to be considered for this role. We thank all applicants for their interest in a career at Scotiabank; however, only those candidates who are selected for an interview will be contacted.