At a Glance
- Tasks: Develop and review financial models to support investment decisions and commercial activities.
- Company: Join Great British Energy, a pioneering public energy company focused on clean energy.
- Benefits: Enjoy competitive salary, performance bonuses, generous leave, and flexible working options.
- Other info: Collaborative environment with opportunities for professional growth and development.
- Why this job: Be part of a mission-driven team shaping the UK's clean energy future.
- Qualifications: Experience in financial modelling and strong analytical skills required.
The predicted salary is between 63000 - 77000 £ per year.
Location: Aberdeen / Edinburgh
Reporting to: Head of Transaction Support (Interim: Head of Investment Portfolio Management)
Number of Roles Available: 1
Company Overview:
Great British Energy (GBE) is a new publicly owned energy company with a clear purpose: to power Britain with clean, secure, home-grown energy and to help position the UK as a global leader in the clean energy transition. Our mission is Public Ownership of Energy with Purpose. We exist to accelerate clean energy deployment, strengthen energy security, and ensure that UK workers, communities and taxpayers share directly in the benefits of a cleaner, more resilient energy system.
About the Role:
The Transaction Modelling Officer will support Great British Energy's investment and commercial activity by developing, operating and reviewing financial and transaction models that inform structuring, appraisal, negotiation and decision-making regarding investment opportunities available to GBE. The role will work across pipeline, transaction and portfolio activity, helping ensure that modelling outputs are robust, transparent and decision-useful.
Key Responsibilities:
- Build, maintain and update financial and transaction models to support investment appraisal, structuring, negotiations and portfolio analysis.
- Run sensitivities, scenarios and downside cases on transaction models to assess the financial implications of different transaction terms, input assumptions, risk adjustments and diligence outputs.
- Support the preparation of financial analysis for business cases, Investment Committee papers, approval submissions and negotiation materials, including internal valuations of target projects/investees.
- Work with deal teams, structuring colleagues, finance and portfolio teams to gather assumptions, validate inputs and ensure model outputs reflect the latest position and a robust base case for investment.
- Assist in assessing valuation ranges, value for money, returns, funding requirements and risk-adjusted outcomes across potential opportunities.
- Document model logic, assumptions, key judgments and outputs clearly so that models are transparent, reviewable and auditable.
- Carry out quality assurance, sense-checking and version control across models and analytical outputs.
- Help translate modelling outputs into clear charts, summaries and decision-support materials for non-technical stakeholders.
- Support continuous improvement in modelling standards, templates and analytical tools across the transaction support and investment portfolio management functions.
- Contribute to ad hoc analytical work on portfolio performance, pipeline prioritisation, restructurings or underperforming investments where required.
- Ensure modelling outputs support later monitoring by distinguishing between supply chain investment value drivers and energy project investment value drivers, including appropriate base case assumptions, sensitivities and downside cases.
Qualifications and Experience:
Essential:
- Experience building or operating financial models, business models or analytical models in a corporate finance, investment, infrastructure, project finance or similar environment.
- Experience of modelling infrastructure, energy, project finance or asset-backed transactions.
- Strong numerical and analytical skills, with the ability to interpret complex information accurately and draw clear conclusions.
- Advanced Excel modelling skills and confidence working with structured models, assumptions, sensitivities and data sets.
- Good written and verbal communication skills, including the ability to explain analysis clearly to non-specialist audiences.
- High attention to detail, with a disciplined approach to quality control, documentation and version management.
- Ability to work collaboratively across teams and manage multiple priorities in a developing and fast-paced environment.
- Sound judgement and professionalism when handling confidential or commercially sensitive information.
Desirable:
- Familiarity with investment appraisal, discounted cash flow analysis, scenario analysis and risk assessment.
- Experience supporting committee papers, business cases or senior decision-making materials.
- Awareness of public-sector governance, approvals or value-for-money considerations.
Qualifications (if required):
- Relevant degree or equivalent experience in finance, economics, mathematics, engineering, business or a related field.
- Evidence of completing training in a relevant modelling discipline would be advantageous.
- Progress towards or interest in a relevant professional qualification such as ACA, ACCA, CIMA or CFA would be advantageous.
What We Offer:
- Competitive base salary
- Performance-related bonus scheme
- Excellent pension scheme
- 4x salary life assurance
- Group income protection
- 38 days annual leave
- Flexible working arrangements
- Ongoing professional development and training
- Supportive, inclusive working environment
How to Apply:
For further information please contact: Ciara Lynn, Lead Sourcing Specialist
Application Close Date: 21st August
Transaction Modelling Officer in Bonnyrigg employer: Public Sector Resourcing CWS
Great British Energy - Nuclear is an exceptional employer, offering a dynamic and inclusive work culture that prioritises collaboration, trust, and innovation. With a strong focus on employee growth and development, team members are encouraged to engage in meaningful projects that contribute to the UK's energy security and net-zero goals. Located in Warrington or London, the hybrid working model allows for flexibility while being part of a pioneering organisation at the forefront of nuclear technology advancement.
Contact Details:
Public Sector Resourcing CWS Recruitment Team
StudySmarter Expert Advice🤫
We think this is how you could land Transaction Modelling Officer in Bonnyrigg
✨Tip Number 1: Tap Into Professional Networks
The finance world loves a good connection, so jump into industry-specific groups on platforms like LinkedIn where you can find discussions on financial controlling. Engaging in these communities can expose you to hidden job leads that aren't openly advertised!
✨Tip Number 2: Attend Finance Events and Conferences
Make it a mission to attend finance-related events and conferences, even virtual ones! This is a golden opportunity to network face-to-face with people from companies like Public Sector Resourcing CWS. You never know who might be your next boss or a crucial contact!
✨Tip Number 3: Showcase Your Expertise
Consider writing articles or sharing insights related to financial controlling or industry trends. Publish these on platforms like LinkedIn to establish yourself as a knowledgeable player in the field. This not only increases your visibility but also catches the attention of recruiters from Public Sector Resourcing CWS.
✨Tip Number 4: Apply Directly on Company Websites
Since you're going for a full-time gig, don't forget to keep an eye on the careers page of companies you're interested in, like Public Sector Resourcing CWS. Many companies prefer candidates who apply through their website as it shows genuine interest and makes your application stand out!
We think you need these skills to ace Transaction Modelling Officer in Bonnyrigg
Some tips for your application 🫡
Show Off Your Numbers Game:In financial controlling, detail is everything! Make sure your CV showcases your proficiency with numbers—highlight any relevant experience in budgeting, forecasting, or working with financial software. Quantifying your past achievements will make you stand out, so don’t be shy about flaunting those impressive percentages or cost savings you've implemented.
Tailored Cover Letter is Key:Your cover letter is a chance to shine, especially for a full-time role. Use it to express your genuine interest in Public Sector Resourcing CWS and the specific impact you hope to make in financial controlling. Mention any relevant qualifications or experiences that align with the company’s goals, and don’t forget to show that you're ready for a long-term commitment!
Certifications Matter:List relevant certifications such as ACCA or CIMA on your CV. These qualifications not only showcase your dedication to the field but also your technical competence in financial principles. If you have any ongoing training or courses, make sure to mention those as well to demonstrate your commitment to continual learning in financial controlling.
Don’t Overlook Soft Skills:While numbers are crucial, so are those soft skills! Financial controllers need strong communication and analytical reasoning abilities. We recommend embedding examples of these skills in your CV and cover letter, like how you’ve successfully delivered financial reports to stakeholders or collaborated with teams to improve processes. Let’s show Public Sector Resourcing CWS how you can be a team player!
How to prepare for a job interview at Public Sector Resourcing CWS
✨Brush Up on Technical Skills
Make sure you're comfortable with key financial concepts, especially around forecasting, budgeting, and variance analysis. Sometimes, interviewers may throw in technical questions or case studies, so practicing these types of scenarios will help you shine!
✨Showcase Your Financial Acumen
If you've had experience with specific financial software like SAP or Oracle, make it known! Be ready to discuss how you used these tools to improve processes or reporting, as this hands-on knowledge can really set you apart in a full-time role with Public Sector Resourcing CWS.
✨Know Your Numbers
In full-time interviews, especially in financial controlling, be prepared for numerical reasoning tests or questions. Brush up on your mental maths and understand how to interpret and analyse financial statements on the spot, as this may come up during the assessment.
✨Connect with Company Goals
Familiarise yourself with Public Sector Resourcing CWS's financial objectives and any recent developments. During the interview, try to weave your understanding of their business model and challenges into your answers—this shows your genuine interest and alignment with their goals!
