Modelling Analyst – Financial Planning & Analysis

Company: The Openwork Partnership
Apply for the Modelling Analyst – Financial Planning & Analysis
Location: Swindon
Job Description:

We are seeking an FP&A Modelling Analyst to bring strong analytical capability, advanced Excel expertise, and a proven ability to build and interpret complex financial models.

This is a key role in supporting strategic decision-making, evaluating business performance, and delivering meaningful commercial insight across the organisation.

The Benefits

  • Salary: up to £60,000
  • Pension: Contribute up to 5% with a matched 5% from Openwork
  • Critical illness cover
  • Income protection
  • Death in service (4x salary)
  • 27 days holiday + bank holidays, with option to buy up to 10 additional days
  • Flexible benefits including private medical and dental insurance

Key Accountabilities

  • Build, enhance, and maintain complex financial models for forecasting, budgeting, pricing, and scenario analysis
  • Develop dynamic models to support strategic and commercial decision-making
  • Translate model outputs into clear insights, highlighting risks, opportunities, and actions
  • Deliver detailed sensitivity, variance, and scenario analysis
  • Produce high-quality reporting, dashboards, and forecasting outputs
  • Support monthly, quarterly, and annual planning and reporting cycles
  • Partner with Finance teams to support delivery of the Value Creation Plan
  • Apply advanced Excel techniques (Power Query, Power Pivot, macros, dynamic arrays, automation)
  • Leverage BI tools and financial systems to improve efficiency
  • Ensure strong data integrity, governance, and model documentation

What will you need to succeed?

  • Proven experience in FP&A, Financial Modelling, or Commercial Finance
  • Advanced Excel skills with strong modelling expertise
  • Experience in forecasting, scenario planning, and sensitivity analysis
  • Experience creating dashboards or automated reporting
  • Ideally ACA, ACCA, or CIMA qualified (or working towards)
  • Financial Services experience beneficial but not essential
  • Strong analytical and problem-solving capability
  • Ability to build and maintain complex financial models
  • Confident communicator, able to present insights to finance and business stakeholders
  • High attention to detail and accuracy
  • Ability to interpret data, identify trends, and quantify risks and opportunities

#J-18808-Ljbffr…

Posted: May 27th, 2026