Financial Planning & Reporting Analyst

Job Title: Financial Planning & Reporting Analyst
Job Location: Hybrid (Montreal, QC)
Job Type: T4 Contract
Experience: 3+ Years
Rate: CAD 45 - 50 per hour

Role Summary: NearSource is seeking a Financial Planning & Reporting Analyst to support financial forecasting, budgeting, expense management, revenue planning, and management reporting. The role will collaborate with finance and business stakeholders to strengthen financial data accuracy, improve forecasting processes, and deliver actionable insights that support business decisions.

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.

Apply now, or share your resume with salary expectations at [email protected]. Thank you for considering a career with us! Once you submit your application, our Talent Acquisition team will review your resume thoroughly. If there's a strong match, we'll reach out to discuss your experience, role details, benefits, compensation, and next steps. While we strive for transparency, we may not be able to respond to every applicant due to high volume, but we genuinely appreciate your time and interest.

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.