Manager corporate treasury, data analytics, funds transfer pricing

BMO Financial Group; Toronto; On-site; CAD 74,000 - 139,000; Full time

Job summary

An established industry player is seeking a skilled analyst to join their Corporate Treasury team. This role focuses on building and maintaining dashboards using Power BI, performing financial analysis, and collaborating with various departments to optimize data processes. The ideal candidate will have strong expertise in financial analysis and treasury management, along with advanced skills in Excel and SQL. With a commitment to innovation and continuous improvement, this company provides a supportive environment for professional growth and development, making it an exciting opportunity for those looking to make a significant impact in the finance sector.

Benefits

Health Insurance

Tuition Reimbursement

Accident Insurance

Life Insurance

Retirement Savings Plans

Performance-Based Incentives

Discretionary Bonuses

Qualifications

• 5-7 years of relevant experience in finance or related field.
• Advanced knowledge of Excel, SQL, and dashboard development.

Responsibilities

• Support production processes for accurate FTP rates.
• Analyze data to provide insights and recommendations.

Skills

Financial Analysis

Treasury Analysis

Excel

SQL

Power BI

Python

Education

Degree in Finance

Degree in Business

Degree in Computer Science

Degree in Mathematics

Tools

Power BI

Excel

SQL

Access

Job description

Application Deadline:

05/29/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.

Salary :

$74,800.00 - $138,600.00

Pay Type:

Salaried

The above represents BMO Financial Group’s pay range and type.

Salaries will vary based on factors such as location, skills, experience, education, and qualifications for the role, and may include a commission structure. Salaries for part-time roles will be pro-rated based on number of hours regularly worked. For commission roles, the salary listed above represents BMO Financial Group’s expected target for the first year in this position.

BMO Financial Group’s total compensation package will vary based on the pay type of the position and may include performance-based incentives, discretionary bonuses, as well as other perks and rewards. BMO also offers health insurance, tuition reimbursement, accident and life insurance, and retirement savings plans. To view more details of our benefits, please visit:https://jobs.bmo.com/global/en/Total-Rewards

About Us

At BMO we are driven by a shared Purpose: Boldly Grow the Good in business and life. It calls on us to create lasting, positive change for our customers, our communities and our people. By working together, innovating and pushing boundaries, we transform lives and businesses, and power economic growth around the world.

As a member of the BMO team you are valued, respected and heard, and you have more ways to grow and make an impact. We strive to help you make an impact from day one – for yourself and our customers. We’ll support you with the tools and resources you need to reach new milestones, as you help our customers reach theirs. From in-depth training and coaching, to manager support and network-building opportunities, we’ll help you gain valuable experience, and broaden your skillset.

To find out more visit us at https://jobs.bmo.com/ca/en .

BMO is committed to an inclusive, equitable and accessible workplace. By learning from each other’s differences, we gain strength through our people and our perspectives. Accommodations are available on request for candidates taking part in all aspects of the selection process. To request accommodation, please contact your recruiter.

Note to Recruiters: BMO does not accept unsolicited resumes from any source other than directly from a candidate. Any unsolicited resumes sent to BMO, directly or indirectly, will be considered BMO property. BMO will not pay a fee for any placement resulting from the receipt of an unsolicited resume. A recruiting agency must first have a valid, written and fully executed agency agreement contract for service to submit resumes.