Financial Reporting Analyst - FP&A

Applicantz, Inc; Montreal; On-site; CAD 85,000 - 120,000; Full time

Job summary

Applicantz, Inc. is seeking a Financial Analyst FP&A in Montreal to compile and analyze financial information, develop integrated revenue and expense analyses, projections, reports and presentations.

The role supports monthly, quarterly, and annual reporting, forecasts, and headcount and ARR/billings alignment, requiring 3+ years of experience and a Bachelor's degree. The position emphasizes advanced Excel, PowerPoint, and SAP/BPC skills and collaboration with the Finance team.

Qualifications

• 3+ years of FP&A experience
• Bachelor's degree required
• Strong Excel and PowerPoint skills
• Experience with SAP/BPC and BI tools

Responsibilities

• Monthly forecast execution: support forecast prep, update models, document processes
• Consolidated view of expenses in Power BI; assess allocations and mappings
• FY28 budget development: own a defined workstream and consolidate submissions
• Headcount tracking: monitor budgets, approvals, and ARR forecasts
• ARR, ACV, and billings alignment: restate metrics and forecast impact

Skills

Advanced Microsoft Excel skills

Advanced PowerPoint skills

SAP & BPC experience

Education

Bachelor's degree

Tools

SAP

BPC

Job description

Looking for a Financial Analyst FP&A, who compiles and analyzes financial information for the organization. Develops integrated revenue and expense analyses, projections, reports, and presentations. Creates and analyzes monthly, quarterly, and annual reports while ensuring financial information is accurately recorded. Identifies trends and developments in competitive environments and presents findings to senior management. Performs financial forecasting and reconciliation of internal accounts. Need to have 3+ years of experience and a Bachelor's degree

Top Skills

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

Responsibilities

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