FP&A Analyst – Budgeting & Forecasting

Applicantz, Inc; Montreal; On-site; CAD 70,000 - 110,000; Full time

Job summary

Applicantz, Inc. is seeking a financial planning analyst to support monthly forecasting, budgeting, and headcount tracking. The role involves updating forecasting models, validating assumptions, and building automated variance analysis tools to improve accuracy.

You will collaborate across FP&A, finance transformation, and department leaders to refine mappings, update allocations, and document data sources for transparency and governance.

Qualifications

• Experience with monthly forecasting cycles and variance analysis.
• Strong analytical and Excel modeling skills.
• Ability to document processes and maintain data lineage.

Responsibilities

• Support monthly forecast preparation and validate assumptions.
• Update forecasting models and build automation for variance analysis.
• Document processes for each forecast submission.
• Consolidate view of expenses versus forecast in Power BI with accuracy.

Skills

Forecasting

Financial analysis

Budgeting

Tools

Microsoft Excel

PowerPoint

SAP

BPC

Job description

Top Skills

• Advanced Microsoft Excel skills
• Advanced PowerPoint skills
• SAP experience
• BPC experience

Job Description:

Monthly Forecast Execution

• Support monthly forecast preparation (Outlook, Forecast 1, Forecast 2).
• Update forecasting models and validate assumptions.
• Build automation or agents for variance analysis.
• Document processes for each forecast submission.

Consolidated View of MX Expenses (Actual vs. Forecast) in Power BI

• Partner with the Finance Transformation team to identify gaps, overlaps, and potential double-counting, including allocations.
• Determine how allocations are treated, tracked, and reflected in actuals.
• Validate employee mapping across functions and cost centers.
• Assess whether G&A and Corporate Communications costs require separate tracking.
• Update forecasts to reflect revised employee mapping and associated costs.
• Support actual versus budget analysis using the new employee mapping.
• Establish a repeatable reconciliation process to ensure completeness, accuracy, and consistency between actuals and forecasts.
• Document data sources, expense treatments, and ownership for each expense category.

FY28 Budget Development

• Support the FY28 planning process by owning a defined workstream and partnering with the FP&A team and department leaders.
• Distribute budget templates, collect submissions, and follow up to ensure planning deadlines are met.
• Consolidate submissions and review for completeness, consistency with planning guidelines, and alignment with revised employee mapping.
• Update budget and forecast projections based on revised employee mapping and associated costs.
• Develop supporting analyses for management review, including variances against current-year forecasts and prior-year actuals.
• Model and compare planning scenarios, documenting key assumptions, drivers, and variances.

Headcount Tracking Process (Ashby)

• Develop a process to track approved headcount budgets, committed costs, and remaining funding by department.
• Establish a review process for new role requests, requiring department leaders to identify offsetting funding within existing budgets.
• Create a framework for evaluating role substitutions, including scenarios where a higher-cost role requires funding from multiple planned positions.
• Document approval requirements and update headcount plans and forecasts to reflect approved changes.
• Support the bi-weekly ARR forecast by collecting inputs, updating projections, and validating assumptions.
• Analyze changes from prior forecasts and highlight key drivers, risks, and opportunities.
• Update revenue and billings forecasts based on revised ARR projections and timing assumptions.
• Refine billings assumptions and forecasting methodologies.
• Prepare supporting analyses and commentary for management review.
• Document forecasting processes, including data sources, assumptions, responsibilities, timelines, and the flow-through impact of ARR changes on revenue and billings.

ARR, ACV, and Billings Alignment

• Support alignment of ARR, ACV, and Billings with metric definitions.
• Document current MaintainX metric definitions, compare them with definitions, and quantify gaps.
• Assist in developing a bridge from current metrics to aligned metrics.
• Support the restatement of historical and forecasted figures under the new definitions