Senior Business Analyst, Scotia Jarislowsky Fraser - Toronto

Requisition ID: 268430 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

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

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

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

1. 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, inclusive of the services across Scotia Wealth Management

Expert understanding of the Scotia Jarislowsky Fraser (SJF) strategy and vision

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

High-level understanding of applicable business line objectives within SJF and Scotia Wealth Management

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.