Job Information

Scotiabank Senior Business Analyst, Private Investment Counsel (PIC) - Toronto in Toronto, Ontario

Senior Business Analyst, Private Investment Counsel (PIC) - Toronto

Requisition ID: 200775

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

Scotia Wealth Management

Purpose of Job:

The incumbent 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.

Reports to: Senior Manager, PIC (No direct reports)

Major Accountabilities:

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:

  • Ensure a robust understanding of the underlying information and systems to identify inconsistencies within data sources;

  • Address systematic issues when required to improve the accuracy of direct data extraction;

  • Take corrective measures when necessary to correct and validate raw data.

Develop and maintain reporting and analysis for Private Investment Counsel (PIC):

  • Conduct analysis independently by reviewing, monitoring and analyzing large sets of data to derive trends and important developments;

  • Identify and investigate issues to ensure validity of conclusions.

Support for strategic growth initiatives:

  • Formulate conclusions and provide recommendations to Senior Management based on analysis;

  • Ensure the analysis is clear, logical, accurate and properly documented.

Ownership of monthly, quarterly and ad-hoc reporting:

  • Business results reporting in the form of robust dashboards leveraging key performance indicators;

  • Client management reporting for sales staff to assist in client relationship management and sales prospecting efforts;

  • Compliance adherence reporting.

Support key strategic initiatives within PIC:

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

  • Formulate conclusions and provide recommendations to Senior Management based on the analysis;

  • Ensure the analysis is clear, logical, accurate and properly documented.

Track and monitor progress and levels of success (sales trending):

  • Develop and implement key performance indicators;

  • Ensure a clear and concise process for monitoring results.

Support and execute the administration of the PIC compensation plans.

Work with internal partners in administration efforts:

  • Track and monitor results and assist in applying parameters/drivers of the compensation plans for measurement;

  • Calculate and reconcile new business compensation factors for purposes of payment;

  • Calculate and reconcile quarterly IPF scores;

  • Review and validate measurement are accurate and transparent;

  • Develop and maintain distribution procedures of payment information and supporting data.

Liaise with participants of the plan(s) to address questions or concerns:

  • Leverage repository of client and financial results to investigate payments if required;

  • Maintain database of non-standard measures that need to be tracked and actioned on a quarterly basis.

Provide Superior Service and Support to PIC Staff:

  • Co-ordinate the development and launch of key initiatives with end users and stakeholders;

  • Liaise with and co-ordinate internal departments to resolve issues being encountered with field staff;

  • Identify and develop tools and resources to assist PIC relationship managers in their efforts to deliver an outstanding client experience;

  • Respond to daily and ad hoc inquiries from the Relationship Managers and Regional and Market Leadership teams.

Contribute to the effective functioning of the Private Investment Counsel 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.

Key success measures include:

  • Key initiatives/projects delivered on time and within budget;

  • Feedback from Managing Director of PIC along with business unit heads, support unit heads and key partners;

  • Internal stakeholder satisfaction/relationships;

  • Discretion with extremely confidential information.

Education/Work Experience/Designations:

  • 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 Private Investment Counsel (PIC) 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 Microsoft Word, PowerPoint and Microsoft Access; Knowledge of Power BI is an asset;

  • 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 Private Investment Counsel and Scotia Wealth Management.

Working Conditions:

  • Complex matrix-management work environment;

  • Fast-paced and high stress industry prone to frequent and rapid change;

  • High degree of inter-dependency with multiple stakeholders and subject matter experts;

  • Frequent ad hoc requests from senior officers, deadlines and unplanned operational problems are expected;

  • Standard office environment involving long periods of time working on a PC;

  • Some travel may be required (ad hoc).

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, pleaseclick here (https://www.scotiabank.com/careers/en/careers/technical-support-for-applicants.html) . 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.