At a Glance
- Tasks: Build and enhance complex financial models to support strategic decision-making.
- Company: Join The Openwork Partnership, a dynamic and ambitious company with a supportive culture.
- Benefits: Enjoy a competitive salary, bonus scheme, flexible benefits, and generous holiday allowance.
- Other info: Be part of an inclusive culture that values individuality and promotes personal development.
- Why this job: Make a real impact by delivering insights that drive business performance and growth.
- Qualifications: Advanced Excel skills and experience in financial modelling or FP&A required.
The predicted salary is between 50000 - 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: £50,000 to £60,000
- Bonus scheme: On-target bonus (7.5%)
- 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
Why us?
At The Openwork Partnership, we're a dynamic, fast paced, and growing business with huge ambition. This is all made possible by the brilliant people who are part of The Openwork Partnership family. We're investing heavily in our colleagues, continuously striving to give them the platform to develop personally and professionally and reach their full potential. We’re also very proud of our culture, as one of the Best 100 Large Companies to work for in 2022.
The Openwork Partnership values, and respects individuality and we are committed to building an inclusive culture and environment which truly recognises and celebrates our colleague’s individual differences and identities – just like our financial advice, for us, it’s personal. We believe everyone can make a difference and your race, religion, disability, and gender will never be a barrier. At Openwork, we have a strong ethic of care for each other where you can balance a successful career with your commitments and interests outside of work. We believe that you will bring your best self to work if you are trusted to choose when, where and how you do it.
FP&A Modelling Analyst in Swindon employer: Openwork
Openwork is an exceptional employer that prioritises the success and growth of its self-employed Protection Advisers. With a strong emphasis on a supportive culture, comprehensive resources, and opportunities for professional development, you will thrive while working remotely across the UK. Join a dynamic team where building lasting client relationships is at the heart of what we do, and enjoy the flexibility and autonomy that comes with being part of a broad network.
StudySmarter Expert Advice🤫
We think this is how you could land FP&A Modelling Analyst in Swindon
✨Tip Number 1
Network like a pro! Reach out to people in the industry, attend events, and connect on LinkedIn. You never know who might have the inside scoop on job openings or can refer you directly.
✨Tip Number 2
Prepare for interviews by practising common FP&A questions and showcasing your Excel skills. Use real-life examples from your experience to demonstrate how you've built and interpreted financial models.
✨Tip Number 3
Don’t just apply; follow up! After submitting your application through our website, send a quick email to express your enthusiasm. It shows initiative and keeps you on their radar.
✨Tip Number 4
Stay updated on industry trends and tools. Being knowledgeable about the latest in financial modelling and BI tools will not only impress interviewers but also help you stand out as a candidate.
We think you need these skills to ace FP&A Modelling Analyst in Swindon
Some tips for your application 🫡
Show Off Your Excel Skills:Since advanced Excel expertise is a must for the FP&A Modelling Analyst 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 bring those skills to life in your application!
Be Clear and Concise:When you're writing your application, keep it straightforward. Use clear language to explain your experience and how it relates to the key accountabilities listed in the job description. We appreciate a well-structured application that gets straight to the point!
Tailor Your Insights:Don’t just send a generic application! Tailor your insights to reflect how you can support strategic decision-making and deliver commercial insight. We love seeing candidates who understand our business and can articulate how they can contribute to our goals.
Apply Through Our Website:We encourage you to apply through our website for the best chance of getting noticed. It’s super easy, and you’ll be able to showcase your application in the best light. Plus, we’re always on the lookout for passionate individuals like you!
How to prepare for a job interview at Openwork
✨Master Your Financial Models
Before the interview, brush up on your financial modelling skills. Be prepared to discuss specific models you've built or enhanced, and how they supported strategic decisions. Practising explaining complex concepts in simple terms will help you communicate effectively with stakeholders.
✨Excel Like a Pro
Since advanced Excel skills are crucial for this role, make sure you're comfortable with Power Query, Power Pivot, and macros. Consider doing a quick refresher on these tools and be ready to demonstrate your expertise during the interview, perhaps by discussing a project where you used these techniques.
✨Showcase Your Analytical Skills
Prepare examples that highlight your analytical and problem-solving capabilities. Think of situations where you identified trends or quantified risks and opportunities. Being able to articulate these experiences will show your potential employer that you can deliver meaningful insights.
✨Communicate with Confidence
Practice presenting your insights clearly and confidently. You might be asked to explain your thought process behind a financial model or analysis. Use this opportunity to demonstrate your ability to engage with both finance and business stakeholders, showcasing your communication skills.
