Financial Planning & Reporting Analyst

NEARSOURCE TECHNOLOGIES; Montreal; Hybrid; CAD 62,000 - 69,000; Full time

Job summary

NearSource Technologies is seeking a Financial Planning & Reporting Analyst for a hybrid role in Montreal, QC. You will support monthly forecasts, consolidate reporting, and assist in FY28 budgeting and ARR forecasting.

The ideal candidate has 3+ years of finance experience, strong Excel and PowerPoint, and knowledge of SAP/BPC, with a proven ability to automate analyses and collaborate across departments. This T4 contract offers CAD 45-50 per hour and a dynamic environment helping transform

Qualifications

• 3+ years of experience in finance or a related field.
• Bachelor's degree.
• Advanced Microsoft Excel skills.
• Advanced PowerPoint skills.
• Financial modelling and analytical skills.
• Experience with SAP.
• Experience with BPC.
• Strong analytical and problem-solving capabilities.
• Self-starter with a proactive, ownership-oriented mindset.
• Highly organized, detail-oriented, and impact-driven.
• Ability to collaborate effectively with diverse internal stakeholders.

Responsibilities

• Monthly forecast execution, including Outlook, Forecast 1 and Forecast 2, with model updates and variance analysis.
• Consolidated expense reporting and Power BI analysis, tracking allocations and data sources.
• FY28 budget development: gather submissions, consolidate, and align with revised mappings.
• Headcount tracking and budget control using Ashby and review of new role requests.
• ARR forecasting: bi-weekly updates, drivers, risks, and billings alignment.
• Financial reporting and analysis: prepare reports, reconciliations, and management commentary.
• Document forecasting processes, data sources, responsibilities, timelines, and version control.

Skills

Advanced Excel

Advanced PowerPoint

Financial modelling

Analytical skills

Self-starter

Organized

Collaboration

Education

Bachelor's degree

Tools

SAP

BPC

Power BI

Job description

Job Title: Financial Planning & Reporting Analyst

Job Location: Hybrid (Montreal, QC)

Job Type: T4 Contract

Experience: 3+ Years

Rate: CAD 45 - 50 per hour

Key Responsibilities

1. Monthly Forecast Execution

• Support monthly forecast submissions, including Outlook, Forecast 1, and Forecast 2.
• Update forecasting models, validate assumptions, and maintain the accuracy of financial projections.
• Develop automation solutions or agents to support variance analysis.
• Document forecasting procedures, assumptions, and submission requirements for each forecast cycle.

2. Consolidated Expense Reporting and Power BI Analysis

• Partner with the Finance Transformation team to identify gaps, overlapping expenses, potential double-counting, and allocation discrepancies.
• Determine how allocations are treated, tracked, and reflected in actual financial results.
• Validate employee mapping across functions and cost centers.
• Assess whether General & Administrative (G&A) and Corporate Communications expenses require separate tracking.
• Update forecasts and actual-versus-budget analyses to reflect revised employee mapping and associated costs.
• Establish a repeatable reconciliation process to ensure completeness, accuracy, and consistency between actuals and forecasts.
• Document data sources, expense treatments, allocation methodologies, and ownership for each expense category.
• Support the consolidated view of expenses, including actual-versus-forecast reporting in Power BI.

3. FY28 Budget Development

• Own a defined workstream within the FY28 budget planning process, collaborating with the FP&A team and department leaders.
• Distribute budget templates, collect submissions, and follow up with stakeholders to meet planning deadlines.
• Consolidate budget submissions and validate completeness, consistency with planning guidelines, and alignment with revised employee mapping.
• Update budget and forecast projections to reflect approved employee mapping changes and associated costs.
• Prepare management analyses comparing proposed budgets with current-year forecasts and prior-year actuals.
• Develop and compare planning scenarios, documenting assumptions, financial drivers, and variances.
• Support management reviews by providing clear financial analysis and supporting documentation.

4. Headcount Tracking and Budget Control

• Develop a process to track approved headcount budgets, committed costs, and remaining departmental funding using Ashby.
• Establish a review process for new role requests, requiring department leaders to identify offsetting funding within existing budgets.
• Develop a framework for evaluating role substitutions, including scenarios in which higher-cost positions require funding from multiple planned positions.
• Document approval requirements and maintain updated headcount plans and forecasts to reflect approved changes.

5. Annual Recurring Revenue (ARR) Forecasting

• Support bi-weekly ARR forecasting by collecting inputs, updating projections, and validating assumptions.
• Analyze changes from previous forecasts and identify 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 financial analyses and commentary for management review.
• Document forecasting processes, including data sources, assumptions, responsibilities, timelines, and the impact of ARR changes on revenue and billings.

6. ARR, ACV, and Billings Alignment

• Support the alignment of Annual Recurring Revenue (ARR), Annual Contract Value (ACV), and billings with established metric definitions.
• Document existing metric definitions, compare them with the applicable target definitions, and quantify discrepancies.
• Assist in developing reconciliation bridges between current and aligned metrics.
• Support the restatement of historical and forecasted figures using revised metric definitions.

7. Financial Reporting and Analysis

• Compile and analyze financial information to support organizational planning and decision-making.
• Develop integrated revenue and expense analyses, projections, reports, and presentations.
• Prepare and maintain supporting documentation for monthly, quarterly, and annual financial reporting.
• Ensure financial information is accurately recorded and reconciled.
• Identify financial trends and developments in relevant competitive environments and present findings to management.
• Perform financial forecasting, internal account reconciliation, and variance analysis.
• Collect and update business unit reporting packages and support ad hoc financial reporting requests.
• Collaborate with internal stakeholders to resolve reporting discrepancies and improve the quality and consistency of financial information.

Must-Have Skills

• Minimum 3 years of experience in finance or a related field.
• Bachelor's degree.
• Advanced Microsoft Excel skills.
• Advanced PowerPoint skills.
• Financial modelling and analytical skills.
• Experience with SAP.
• Experience with BPC.
• Strong analytical and problem-solving capabilities.
• Self-starter with a proactive, ownership-oriented mindset.
• Highly organized, detail-oriented, and impact-driven.
• Ability to collaborate effectively with diverse internal stakeholders.

Nice-to-Have / Preferred Skills

• Experience supporting monthly forecasting cycles and annual budget development.
• Experience with actual-versus-forecast analysis, expense reconciliation, and variance reporting.
• Experience with Power BI for financial reporting and expense analysis.
• Experience with headcount planning and budget control processes using Ashby.
• Experience with ARR, ACV, revenue, and billings forecasting.
• Familiarity with financial metric alignment, scenario modelling, and forecasting process automation.

About NearSource

NearSource Technologies is a trusted partner for future-ready software consulting, enabling Fortune 500 enterprises to accelerate digital transformation. Our global engineering teams build and deploy impactful technology for some of the world's most admired brands, working directly on long-term client initiatives.

Equal Opportunity Statement

NearSource is an equal opportunity employer committed to fostering an inclusive and respectful environment. We celebrate diversity and do not discriminate based on race, gender, religion, sexual orientation, age, disability, or background. Innovation thrives when everyone feels empowered to contribute.