Business Analyst, Toronto

Scotiabank; Toronto; On-site; CAD 70,000 - 95,000; Full time

Job summary

Scotiabank in Toronto seeks a Business Analyst to drive analytics and reporting for Dynamic Funds activities. You will collaborate with Operations, Compliance, Finance, IT and other partners to identify efficiency gains, support new business initiatives, and help achieve division goals.

You will lead monthly to annual reporting, develop standards for expense management, and troubleshoot systems like Salesforce, Seismic, and MicroStrategy, contributing to data integrity and process improvements.

Qualifications

• University degree or equivalent college diploma is required.
• Advanced proficiency with MS Office (Excel/Access).
• Experience with BI tools (MicroStrategy or Power BI).
• Experience in mutual funds/financial services industry is preferred.
• Excellent problem-solving and decision-making skills.
• Strong verbal and written communication abilities.

Responsibilities

• Performs complex analyses to produce reporting on funds and activity, regularly and ad-hoc.
• Develops processes and standards for expense management and reporting quality.
• Investigates complex calculations for tiered/scaled fees, PROR, and blended discount calculations where required.
• Provides system support for Salesforce, Seismic, MicroStrategy, including mobile versions.
• Contributes toward defining team goals and process improvements within the business unit.

Skills

Analytical thinking

Communication skills

Problem solving

Multitasking

Adaptability

Interpersonal skills

Attention to detail

Education

University Degree or equivalent College Diploma

Tools

Salesforce

Seismic

MicroStrategy

Power BI

Excel

Access

Job description

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

Purpose

The Business Analyst is responsible for using sophisticated analytics and reporting to identify operational impact and efficiency gains on Dynamic Funds activities and initiatives. The Business Analyst will help lead projects supporting new business activities to increase sales quality of output, and work towards meeting division and departmental goals. The Business Analyst will work collaboratively with internal business partners (i.e. Operations, Compliance, Legal, Finance, HR, Marketing, IT) in support of achieving mutually agreeable objectives. The Sales Reporting & Analytics team will have superior knowledge of the Dynamic Funds operational procedures and will be expected to provide ad-hoc reporting and analytics as requested by the Director, Sales Reporting & Analytics.

Is this role right for you? In this role you will:

Reporting and Analysis

• Performs complex analyses to produce reporting on various funds and fund related activity. The frequency of reporting and analysis will be regular (monthly, quarterly, semi-annually, annually) as well as ad-hoc as required.
• Develops and documents processes and standards for expense management, to ensure controls, quality, integrity and delivery of reporting and analysis produced.
• Investigates and performs complex calculations (including manual) pertaining to tiered fees, scaled fees, rebates, personal rates of return (PROR) and blended discount calculations wherever required.
• Provides system support and troubleshooting for: Salesforce, Seismic, MicroStrategy, including mobile versions

Business Process and Continuous Improvement

• Contributes toward defining and meeting team goals that align to corporate goals; investigates methods of increasing productivity, accuracy, and efficiencies within the business unit.
• Provides subject matter expertise regarding Alternative Products, Specialty Programs, Management Fee & Management Fee Rebate business processes including system features and Standard Operating Procedures (SOP’s).
• Works with the Dynamic Sales team and back office support functions (including the Customer Relations Centre, Client Administration, Finance and IT).
• Contributes to streamlining processes regarding exception requests and assists in related issue resolution.
• Develops and administers software tools to identify the need for adding controls to external departments’ business processes, particularly where it impacts data integrity for Dynamic Funds.

Regulatory Impact Awareness

• Works with dealers/clients and Operational groups to support platform level processes. Stays abreast of operational impacts to the business as a result of industry process changes.
• Remains current on regulatory updates through regular communications with Compliance regarding operational issues, alternative products and programs and special projects that directly impact the Dynamic Funds business.
• Conducts preemptive analysis of changes from regulatory bodies such as IIROC/MFDA/AMF to identify areas of greatest impact and allow for the Dealer/Client community to prepare for the changes.

Do you have the skills to enable you to be successful in this role? We would love to work with you if you have:

• University Degree or equivalent College Diploma
• Advanced proficiency in Microsoft Office suite (Access & Excel)
• Proficiency with a BI Tool (preferably Microstrategy or Power BI)
• Experience with the mutual fund / financial services industry
• Completion of IFIC operations and / or CSC an asset
• Knowledge of industry databases (i.e. ifast FundSERV) an asset
• Excellent problem-solving and decision-making skills
• Proven experience leading operational projects
• Excellent verbal and written communication skills
• Ability to multi-task with conflicting priorities
• Ability to accept challenges and adapt to a changing environment
• Strong interpersonal skills with an emphasis on building relationships

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