At a Glance
- Tasks: Build and enhance complex financial models to support strategic decision-making.
- Company: Join a leading financial services firm with a focus on innovation.
- Benefits: Up to £60,000 salary, flexible benefits, and 27 days holiday.
- Other info: Dynamic team environment with opportunities for professional growth.
- Why this job: Make a real impact by delivering insights that drive business performance.
- Qualifications: Advanced Excel skills and experience in financial modelling required.
The predicted salary is between 55000 - 60000 £ per year.
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
Modelling Analyst - Financial Planning & Analysis in Swindon employer: The Openwork Partnership
At Openwork, we pride ourselves on being an exceptional employer that values analytical talent and fosters a collaborative work culture. With competitive benefits including a generous pension scheme, flexible working options, and opportunities for professional development, our Modelling Analysts play a crucial role in driving strategic insights that shape the future of our organisation. Located in a vibrant area, we offer a supportive environment where your contributions are recognised and rewarded, making it an ideal place for those seeking meaningful and impactful careers.
StudySmarter Expert Advice🤫
We think this is how you could land Modelling Analyst - Financial Planning & Analysis in Swindon
✨Tip Number 1
Network like a pro! Reach out to your connections in the finance world and let them know you're on the hunt for an FP&A Modelling Analyst role. You never know who might have the inside scoop on job openings or can put in a good word for you.
✨Tip Number 2
Show off your Excel skills! When you get the chance, demonstrate your advanced Excel techniques during interviews or networking events. Bring examples of your financial models or dashboards to showcase your expertise and make a lasting impression.
✨Tip Number 3
Prepare for those tricky questions! Brush up on your knowledge of forecasting, scenario planning, and sensitivity analysis. Be ready to discuss how you've used these skills in past roles and how they can benefit the company you're applying to.
✨Tip Number 4
Don't forget to apply through our website! We love seeing applications come directly from candidates who are genuinely interested in joining us. Plus, it gives you a better chance to stand out in the crowd!
We think you need these skills to ace Modelling Analyst - Financial Planning & Analysis in Swindon
Some tips for your application 🫡
Show Off Your Excel Skills:Since advanced Excel expertise is a must for this role, make sure to highlight your experience with complex financial models and any cool techniques you've mastered. We want to see how you can use Excel to bring insights to life!
Be Clear and Concise:When you're writing your application, keep it straightforward. Use clear language to explain your experience in FP&A and financial modelling. We appreciate a well-structured application that gets straight to the point!
Tailor Your Application:Make sure to customise your application to reflect the key accountabilities mentioned in the job description. Show us how your skills align with what we're looking for, especially in areas like forecasting and scenario analysis.
Apply Through Our Website:We encourage you to apply directly through our website. It’s the best way for us to receive your application and ensures you don’t miss out on any important updates during the process!
How to prepare for a job interview at The Openwork Partnership
✨Master Your Financial Modelling Skills
Make sure you brush up on your financial modelling skills before the interview. Be prepared to discuss specific models you've built and how they impacted decision-making. Practising with advanced Excel techniques like Power Query and macros will give you a solid edge.
✨Showcase Your Analytical Prowess
During the interview, highlight your analytical capabilities by discussing past experiences where you translated complex data into actionable insights. Use examples that demonstrate your ability to identify trends and quantify risks, as this is crucial for the role.
✨Prepare for Scenario Analysis Questions
Expect questions around forecasting and scenario planning. Prepare to explain your thought process when creating sensitivity analyses and how these have influenced business strategies in your previous roles. This will show your understanding of the key accountabilities.
✨Communicate Clearly and Confidently
As a confident communicator, practice presenting your insights clearly. You might be asked to explain your models or findings to non-financial stakeholders, so being able to convey complex information simply is vital. Remember, clarity can set you apart!
