Financial Planning & Reporting Analyst
- Montreal, QC, Canada
Full-time
Applications open in a new tab.
Job details
- Job type
- Full-time
- Apply by
- Posting language
- English
- Posted
Original job description
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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
More about this job
Responsibilities
Support monthly forecasting, annual budget development, expense and headcount control, and ARR, ACV, revenue, and billings forecasting. Prepare financial analyses and management reports, reconcile financial data, improve forecasting and reporting processes, and document assumptions and methodologies.
Requirements
Requires at least three years of experience in finance or a related field, a bachelor's degree, advanced Excel and PowerPoint skills, and experience with financial modeling, SAP, and BPC. Candidates should be analytical, organized, proactive, detail-oriented, and effective at collaborating with diverse stakeholders; experience in forecasting, budgeting, Power BI, headcount planning, and ARR forecasting is preferred.
Skills
- Financial Forecasting
- Budget Development
- Financial Modeling
- Advanced Microsoft Excel
- Advanced PowerPoint
- SAP
- BPC
- Power BI
- Expense Reconciliation
- Variance Analysis
- Headcount Planning
- ARR Forecasting
- ACV and Billings Alignment
- Scenario Modeling
- Financial Reporting
- Stakeholder Collaboration
Visa sponsorship
Not detected in the job text
Categories
- Finance & Accounting
- Data & Analytics
- Management & Leadership
- Technology
Keywords
- Financial Planning
- Financial Forecasting
- Budget Development
- Expense Management
- Revenue Planning
- Management Reporting
- Financial Modeling
- Microsoft Excel
- PowerPoint
- SAP
- BPC
- Power BI
- Ashby
- Variance Analysis
- Expense Reconciliation
- Headcount Planning
- Annual Recurring Revenue
- Annual Contract Value
- Billings Forecasting
- Scenario Modeling
- Forecast Automation
- Employee Mapping
- Cost Centers
- Actual-versus-Budget Analysis
- Financial Data Reconciliation
- Forecasting Assumptions
- Financial Analysis
- Budget Control