Financial Planning Analyst

Pavago

23h•Remote

About The Position

Our client is seeking a Budgeting/Forecasting Specialist to build financial models, manage planning cycles, and provide forward-looking insights that guide strategy. This role requires strong analytical skills, mastery of modeling tools, and the ability to translate numbers into actionable recommendations. You will work closely with finance leaders and department heads to ensure budgets and forecasts are accurate, realistic, and strategically aligned.

Requirements

Bachelor’s degree in Finance, Accounting, Economics, or related field.
3+ years in financial planning/analysis, budgeting, or forecasting.
Advanced Excel/Google Sheets (nested formulas, pivot tables, sensitivity modeling).
Experience preparing variance analyses for leadership.

Nice To Haves

FP&A tool experience (Anaplan, Adaptive Insights, Hyperion, Workday).
MBA, CFA, or CPA credential.
Experience forecasting for SaaS, real estate, or professional services.
Familiarity with BI/analytics platforms (Power BI, Tableau, Looker).

Responsibilities

Lead preparation of annual operating and capital budgets.
Consolidate inputs across departments and business units.
Ensure budgets align with company goals and resource constraints.
Maintain rolling forecasts for revenue, expenses, and cash flow.
Update models monthly or quarterly with actuals, adjusting assumptions.
Build scenario and sensitivity analyses to test potential outcomes.
Compare actual results to budgets/forecasts.
Prepare written commentary to explain variances and recommend corrective actions.
Build dynamic Excel or Google Sheets models (DCF, ROI, IRR, break-even).
Use advanced formulas, macros, or BI tool integrations to improve accuracy.
Prepare management reporting packages with dashboards and visualizations.
Present insights to executives, highlighting risks and opportunities.
Partner with department heads to align forecasts with operational plans.
Work with FP&A teams to refine planning assumptions.
Identify inefficiencies in forecasting workflows.
Implement new FP&A software or improve data integrations (Adaptive Insights, Anaplan, Workday, or equivalent).