Financial Analyst

Our client, a leading manufacturing and distribution company based in Newmarket, is seeking a Financial Analyst to join their team for a 1-year contract with the potential for extension. This role is ideal for someone with strong experience in variance analysis and financial forecasting. The position is hybrid, with the successful candidate required to be onsite 3 days per week (initially onsite for training).

Key Responsibilities:

• Prepare monthly analysis of variances between actual results and the mid-month forecast/budget.
• Track and prepare monthly accruals for advertising and promotional expenses.
• Coordinate the collection and entry of mid-month forecast data, including net sales, cost of sales, variances, and operating expenses.
• Complete the quarterly reporting package for submission to U.S. headquarters.
• Review supplier, freight, and duty invoices to ensure proper coding and allocation of operating expenses.
• Prepare and generate special accounting/sales reports for analysis, including ad-hoc reports for U.S. or local management and Stats Canada.

Additional Responsibilities:

• Work with multiple business units or managers to distribute and collect data for variance analysis (AOC – analysis of change).
• Comfortable validating data, asking questions to ensure proper understanding of variances, and working with hundreds of SKUs across different product lines.
• Support the development of budget forecasts, working with multiple forecast files based on different product lines and their P&L.
• Update and upload Excel templates for forecasting, validating the data, and performing checks to ensure accuracy.

Required Qualifications:

• Minimum of 2 years of experience in FP&A with a focus on variance analysis.
• Proficiency in Excel (pivot tables, VLOOKUP) for financial analysis and reporting.
• Experience with Hyperion or Longview for financial analysis is preferred.
• SAP experience
• Ability to work with SKU-level product data and manage multiple forecast files and P&Ls.

Key Skills and Attributes:

• Strong attention to detail, with the ability to spot-check and validate your own work.
• Excellent communication skills and the ability to ask questions to clarify data and ensure accuracy.
• Ability to manage multiple tasks, prioritize, and deliver accurate financial reporting on time.