We’re looking for an analytical, detail-driven professional to join our Financial Planning & Analysis team. In this role, you will support operational finance across our production sites, with a focus on cost and waste reporting, standard costing, site productivity analysis, and the monthly and quarterly forecast cycle. You will work directly with transactional data from Microsoft Dynamics 365 and build the reporting that Plant Managers, Operations leadership and the Senior Leadership Team rely on to manage performance.
This is a hands-on, build-oriented role suited to someone who is rigorous about where a number comes from. You will also provide analytical support to the Commercial and Corporate finance teams on a scheduled basis, with workload and priorities set by your direct manager.
Responsibilities:
Produce site and department level productivity reporting covering labour, materials and overhead absorption against spend and production volumes, for use by Site General Managers and the Senior Leadership Team
Perform monthly and quarterly variance analysis, investigating root causes across material, labour and overhead, and preparing supporting documentation for review
Maintain multi-level bills of material and standard cost inputs, including labour routings, rate tables and material standards, ensuring they reflect current production processes
Prepare weekly waste reporting package, including extraction and validation of inventory ledger and waste GL data
Support the annual budget, quarterly forecast and long-range planning cycles, including preparation and reconciliation of site level P&Ls
Prepare supporting schedules and analysis for quarterly Board and Senior Leadership reporting, including inventory position by product category
Build and maintain financial models in which each figure is formula driven and traceable to source records such as work orders, bills of material and ledger detail
Automate and streamline recurring reporting through Excel, Power Query and Power BI to improve turnaround time and reduce manual handling
Complete ad hoc analysis and data requests supporting Operations, Commercial and Corporate finance stakeholders
Required Skills:
Bachelor’s degree in Finance, Accounting, Commerce or a related field
2–4 years of relevant experience in financial planning and analysis, cost accounting or operational finance, in manufacturing or consumer packaged goods
Enrolment in or progress toward a CPA or CFA designation is considered an asset
Advanced Microsoft Excel skills, including lookup functions, pivot tables, Power Query and handling of large transactional data sets
Experience extracting and validating data from an ERP system; Microsoft Dynamics 365 experience is considered an asset
Working knowledge of standard costing, bills of material, work order reporting and variance analysis
Experience with Power BI or a comparable data visualization tool is considered an asset
Practical experience using AI assistants su