Application Deadline: 10/31/2025

Address: 100 King Street West

Job Family Group: Finance & Accounting

This individual contributor level role will be focusing on

o Building, owning, and maintaining dashboards in Power BI.

o Gaining understanding of upstream data and processes by partnering with Finance, Technology, and other groups.

o Performing testing and impact assessments of methodology, data and QRM system configuration changes.

o Performing analysis and presenting FTP insights to stakeholders.

Our ideal candidate has experience with financial analysis, treasury analysis and reconciliations with strong Excel, SQL, and Power BI skills. Coding in Python would be an asset.

The Enterprise FTP team within Corporate Treasury is seeking an experienced analyst to support Funds Transfer Pricing (FTP).

The successful candidate will:

• Support the production processes to generate timely and accurate FTP rates and dollar charges.

• Facilitate discussions with business and finance partners to quantify and explain the FTP results.

• Independently lead ad-hoc analysis and drive change to adapt FTP methodology according to the evolving business requirements.

• Stay informed of global market trends and recommend enhancements to the FTP methodology.

• Analyze data and information to provide insights and recommendations.

• Design dashboards and analyses to be performed, and appropriate visualization and analytics tools to use.

• Work with other data and analytics professionals to optimize, refine, automate and scale analysis into repeatable analytics solutions and decision support tools.

• Build various reporting dashboards using the most appropriate data extraction, data cleaning and data visualisation techniques.

• Provide value through insights, reporting and data visualization techniques. Selects, configures, and implements analytics solutions for consistency and repeatability.

• Develop data visualizations of "large" amounts of data that facilitate the intuitive presentation of data to decision makers.

• Document data flow, systems, and processes to improve the design, implementation, and management of business/group processes.

  • Act as a trusted advisor to assigned business/group.
  • Recommend and implement solutions based on analysis of issues and implications for the business.
  • Coordinate the management of databases; ensure alignment and integration of data in adherence with data governance standards.
  • Build effective relationships with internal/external stakeholders.
  • Work independently and regularly manages non-routine situations.

Qualifications:

• Typically, between 5 - 7 years of relevant experience and post-secondary degree in related field of study or an equivalent combination of education and experience.
• Degree in Finance, Business, Computer Science, Mathematics, or other quantitative disciplines preferred.
• Advanced knowledge of Excel, Access, SQL, Dashboards development (e.g., Power BI).
• Knowledge of Quantitative Risk Management (QRM) is desirable.
• Working experience in a Finance environment with exposure to one or more of the following:
  • Risk management, financial market products and pricing, Balance Sheet / Asset Liability management.
• Verbal & written communication skills - In-depth.
• Collaboration & team skills - In-depth.
• Analytical and problem-solving skills - In-depth.
• Influence skills - In-depth.