Financial Analyst – Multi-Currency Forecasting & Power BI

The Mason Group - Strategic Search Partners; Vaughan; On-site; CAD 65,000 - 90,000; Full time

Job summary

The Mason Group is seeking a Financial Analyst in Vaughan, Ontario to develop and maintain financial reports and leadership dashboards for budgets, actuals, and forecasts.

You will build automated reports and KPI dashboards from the Jonas ERP platform, linking data with SQL/DAX for multi-currency consolidation and scenarios. Strong Excel, IFRS knowledge, and 2–5 years of experience are required.

Qualifications

• Bachelor's degree in Finance or Accounting.
• High level of proficiency in Excel required.
• Strong knowledge of SQL, DAX, Excel & Power BI Reporting.
• CPA designation (or enrollment) is an asset.
• Experience using Jonas software is an asset.
• 2–5+ years' experience building financial statements, models and dashboards.
• Foreign Exchange/multi-currency exposure is an asset.
• Complete knowledge of full accounting cycle and IFRS reporting.

Responsibilities

• Develop and maintain automated monthly reports for statements, budgets, and forecasts.
• Create dashboards for KPI and financial metrics using Jonas ERP data.
• Build out multi-currency financial packages (P&L, Balance Sheet, Cash Flow) with SQL/DAX links.
• Develop what-if scenarios and financial models in a changing business environment.
• Collaborate with Finance to meet reporting deadlines and improve processes.
• Identify and drive reporting enhancements, including ad-hoc reports and Excel dashboards.
• Liaise with Senior Management on financial insights and issue resolution.

Skills

Excel

SQL

Power BI

DAX

IFRS

Financial modeling

Multi-currency

CPA (asset)

Jonas

Communication

Budgeting

Forecasting

Education

Bachelor's degree in Finance or Accounting

Tools

Jonas

Job description

The Mason Group is seeking a Financial Analyst in Vaughan, Ontario to develop and maintain financial reports and leadership dashboards for budgets, actuals, and forecasts.

You will build automated reports and KPI dashboards from the Jonas ERP platform, linking data with SQL/DAX for multi-currency consolidation and scenarios. Strong Excel, IFRS knowledge, and 2–5 years of experience are required.