Business Title:  Financial Reporting Analyst, FP&A
Location: Montreal (Hybrid)
Duration: 3 months
 

Top 3 experience “must haves”:

1. Self-starter with a proactive, ownership mindset
2. Highly organized and impact-driven
3. Advanced Excel and financial modelling skills

    

Job Description: [!--StartFragment--]

Experience Level: Minimum 3 years

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.

Requires a bachelor's degree and a minimum of three years of experience in finance or a related field. Demonstrates knowledge of commonly used concepts, practices, and procedures within the finance function. Works under immediate supervision and follows established guidelines and instructions to perform job responsibilities.

Must possess strong analytical and problem-solving skills and the ability to work effectively with diverse internal stakeholders. Responsible for preparing and maintaining supporting documentation for monthly, quarterly, and annual reporting. Updates and collects business unit reporting packages and assists with ad hoc financial reporting as needed.

Required Skills:

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

Typically reports to a Supervisor or Manager.

---

Tasks and 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.

ARR Forecasting (Bi-Weekly)

• 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.

 
 
At SPECTRAFORCE, we are committed to maintaining a workplace that ensures fair compensation and wage transparency in adherence with all applicable state and local laws.The pay rate for this position is C$50.00/hr.