Financial Planning Analyst
Summary
The role involves creating financial plans, forecasting revenue/expenses/cash flow, analyzing performance variances, and building dynamic financial models (DCF, ROI, IRR) to support leadership decisions using Excel/Google Sheets and FP&A tools.
Budgeting & Forecasting Specialist – FP&A, Financial Modeling & Variance Analysis | Remote
Position Type: Full-Time, Remote
Working Hours: U.S. Client Business Hours
About the Role
At Pavago, one of our clients is hiring a Budgeting & Forecasting Specialist to own financial planning, forecasting, financial modeling, and variance analysis.
This is a hands-on FP&A role focused on building reliable budgets and forecasts, analyzing business performance, and providing forward-looking insights that help leadership make better decisions.
You’ll partner with finance leaders and department heads to ensure financial plans are accurate, realistic, and aligned with business strategy.
What You’ll Own
Budgeting & Financial Planning
- Lead preparation of annual operating and capital budgets
- Consolidate financial inputs across departments and business units
- Align budgets with company goals, operational plans, and resource constraints
- Partner with department leaders to validate assumptions and spending plans
Forecasting & Scenario Planning
- Maintain rolling forecasts for:
- Revenue
- Expenses
- Cash flow
- Update forecasts with actual results and revised assumptions
- Build scenario and sensitivity analyses to evaluate potential outcomes
- Identify emerging financial risks and opportunities
Variance Analysis
- Compare actual performance against budgets and forecasts
- Identify key drivers behind financial variances
- Prepare clear written commentary for leadership
- Recommend corrective actions based on performance trends
Financial Modeling
- Build dynamic financial models using Excel and Google Sheets
- Develop models for:
- DCF
- ROI
- IRR
- Break-even analysis
- Scenario planning
- Use advanced formulas, pivot tables, macros, and data integrations to improve modeling efficiency and accuracy
Reporting & Executive Insights
- Prepare management reporting packages, dashboards, and visualizations
- Translate complex financial data into clear business insights
- Present risks, opportunities, trends, and recommendations to leadership
- Support strategic and operational decision-making with financial analysis
FP&A Process Improvement
- Identify inefficiencies in budgeting and forecasting workflows
- Improve planning cycles, data inputs, and reporting processes
- Support implementation or optimization of FP&A platforms such as:
- Anaplan
- Adaptive Insights
- Workday
- Hyperion
Requirements
- Bachelor’s degree in Finance, Accounting, Economics, or a related field
- 3+ years of FP&A, budgeting, forecasting, or financial analysis experience
- Advanced Excel / Google Sheets skills, including:
- Nested formulas
- Pivot tables
- Sensitivity modeling
- Financial modeling
- Experience building and maintaining budgets and rolling forecasts
- Experience preparing variance analysis and commentary for leadership
- Strong analytical and problem-solving skills
- Ability to build financial models from scratch
- Strong written and verbal English communication
- Comfortable working independently during U.S. business hours
Nice to Have
- Experience with Anaplan, Adaptive Insights, Hyperion, Workday, or similar FP&A tools
- Familiarity with Power BI, Tableau, or Looker
- MBA, CFA, or CPA
- Experience in SaaS, real estate, or professional services
- Experience improving or automating forecasting processes
What Success Looks Like
- Forecast accuracy maintained within approximately ±5–10%
- Budgets completed accurately and on schedule
- Variance explanations delivered within 2–3 days of close
- Financial models remain accurate and consistently updated
- Leadership receives clear, actionable financial insights
- Forecasting cycle time improves through automation and process optimization
Interview Process
- Initial Phone Screen
- Spark Hire Video Interview
- Recruiter Interview
- Practical Financial Modeling & Sensitivity Analysis Task
- Client Interview
- Offer & Background Verification
Apply Now
If you’re an FP&A professional who excels at budgeting, forecasting, financial modeling, variance analysis, and turning financial data into actionable business insights, we’d love to hear from you.
#FP&A #FinancialPlanning #FinancialAnalysis #Budgeting #Forecasting #FinancialModeling #VarianceAnalysis #Excel #FinanceJobs #RemoteFinance #RemoteJobs
As published by workable
First name, Last name, Email, Phone, Resume
- Which financial models have you built from scratch, and what were they used for? written answer
- Which FP&A tools or platforms have you worked with beyond Excel? written answer
- How do you ensure forecast accuracy and adjust assumptions over time? written answer
- Walk me through your process for variance analysis — how do you present findings? written answer
- Describe a scenario analysis you built that influenced an executive decision. written answer
- Do you hold MBA, CFA, CPA, or other financial certifications? written answer
- Please share your LinkedIn Profile URL.
- What is your salary expectation for this position? (In USD per month)