FP&A Analyst

Our client is a growing and dynamic organization seeking a Financial Planning & Analysis (FP& A) Analyst to join its Finance team. Reporting directly to the Group Controller, this is a highly visible role that combines financial reporting, data analytics, dashboard development, and ERP project support. This opportunity is ideal for a recent Business grad with some Accounting knowledge who enjoys working with large datasets, building meaningful reports, and ensuring the accuracy and integrity of financial information. You'll play a key role in providing insights that support strategic decision-making while helping drive an upcoming ERP implementation. If you're a tech savvy individual who thrives in Excel and data management, and takes pride in producing accurate, well-structured financial analysis, we'd love to hear from you.

What You'll Do

Financial Reporting & Analytics

• Build, maintain, and enhance Excel-based dashboards and KPI reporting tools.
• Prepare recurring monthly and quarterly management reporting packages.
• Analyze financial and operational performance data across multiple business units.
• Ensure standardized KPI definitions and reporting consistency across the organization.
• Identify trends, anomalies, and opportunities through detailed analysis and reporting.

Data Management & Reporting Integrity

• Act as the primary contact for finance-related data requests.
• Clean, validate, reconcile, and organize data from ERP and related systems by writing SQL queries.
• Investigate discrepancies and collaborate with stakeholders to resolve data issues at the source.
• Maintain high standards of data quality, accuracy, and reporting integrity.

ERP Implementation Support

• Assist with a major ERP implementation initiative.
• Support data cleanup, mapping, migration validation, testing, and reconciliations.
• Help archive and organize legacy data ahead of system cutover.
• Rebuild recurring reports and dashboards within the new platform.
• Document reporting processes and data flows to support a successful transition.

Business & Ad Hoc Analysis

• Perform analyses related to profitability, inventory, margins, landed costs, customer performance, project performance, and other operational metrics.
• Support budgeting, forecasting, and variance analysis activities.
• Transform complex business questions into actionable financial insights.

Qualifications

Required

• Bachelor's degree in Accounting, Finance, or a related field.
• 2+ years of experience in accounting, financial analysis, or a related finance role.
• Background within distribution, manufacturing, wholesale, industrial services, or related sectors (experience with inventory and COGS is mandatory).
• Advanced Excel skills
• Strong understanding of accounting fundamentals, including: Financial statements, gross profit analysis, inventory accounting, accruals and cost accounting concepts
• Experience cleaning, reconciling, and validating ERP data.
• Excellent attention to detail and commitment to accuracy.
• Strong communication skills with the ability to explain findings to non-finance stakeholders.
• SQL querying and database reporting experience.
• Advanced Excel skills including VBA, Power Query and Power Pivot.
• Power BI, Tableau, or similar business intelligence tools.
• Exposure to ERP implementations, system conversions, or data migration projects.

Robert Half is the world’s first and largest specialized talent solutions firm that connects highly qualified job seekers to opportunities at great companies. We offer contract, temporary and permanent placement solutions for finance and accounting, technology, marketing and creative, legal, and administrative and customer support roles.

Robert Half works to put you in the best position to succeed. We provide access to top jobs, competitive compensation and benefits, and free online training.All applicants applying for Canadian job openings must be authorized to work in Canada.

Only job postings for jobs located in Quebec appear in French.

© 2025 Robert Half. By clicking “Apply,” you’re agreeing to Robert Half’s Terms of Use and Privacy Notice.