Treasury Data Analytics Lead – FTP Insights

BMO Financial Group; Toronto; On-site; CAD 75,000 - 142,000; Full time

Job summary

A leading financial institution in Toronto is looking for an experienced analyst to support Funds Transfer Pricing (FTP). The successful candidate will be responsible for building dashboards in Power BI, performing financial analysis, and collaborating with finance partners. Ideal candidates will possess strong Excel, SQL, and Power BI skills with 5-7 years of relevant experience. The role offers a competitive salary range of $75,900 to $141,900.

Benefits

Health insurance

Tuition reimbursement

Retirement savings plans

Performance-based incentives

Discretionary bonuses

Qualifications

• Typically, between 5 - 7 years of relevant experience.
• Advanced knowledge of Excel, Access, SQL, Dashboard development.
• Knowledge of Quantitative Risk Management (QRM) is desirable.

Responsibilities

• Build and maintain dashboards in Power BI.
• Support production processes for timely FTP rates.
• Analyze data and present insights to stakeholders.

Skills

Financial analysis

Treasury analysis

Reconciliations

Strong Excel skills

SQL

Power BI

Python

Education

Degree in Finance, Business, Computer Science, Mathematics

Tools

Power BI

Excel

SQL

Job description

A leading financial institution in Toronto is looking for an experienced analyst to support Funds Transfer Pricing (FTP). The successful candidate will be responsible for building dashboards in Power BI, performing financial analysis, and collaborating with finance partners. Ideal candidates will possess strong Excel, SQL, and Power BI skills with 5-7 years of relevant experience. The role offers a competitive salary range of $75,900 to $141,900.