Transaction Modelling Officer

Description

Job Title: Transaction Modelling Officer

Location: Aberdeen or Edinburgh

Salary: 80,000 - 85,000

Reporting to: Head of Transaction Support

Number of Roles Available: 1

Company Overview:

Join Great British Energy and be part of powering the UK's Clean Energy Future.

At GBE, we're not just building an energy company - we're shaping the future of the UK's energy landscape.

Our mission is clear:

Drive clean energy deployment across the UK as a strategic developer, investor, and owner of renewable projects

Deliver benefits for communities and taxpayers, ensuring the clean energy transition creates jobs, boosts local economies, and increases public ownership

We focus on innovation, sustainability, and impact, working on projects that matter - from large-scale national renewable investments to empowering local and community energy initiatives.

Joining GBE means

Purpose-driven work Be part of a national effort to accelerate the clean energy transition

Career growth Opportunities to develop expertise in cutting-edge energy technologies and strategic investment

Collaboration and flexibility Work with passionate professionals in a dynamic, forward-thinking environment

If you want to make a real difference and help power a greener, fairer future for the UK, GBE is the place for you.

We welcome applications from all backgrounds and communities. If you require reasonable adjustments during the recruitment process, please let us know.

About the Role:

The Transaction Modelling Officer will lead the development and governance of Great British Energy's transaction modelling capability on deals, ensuring investment, commercial and portfolio decisions are supported by robust, consistent and decision-ready financial analysis.

The role will work across pipeline, transaction and portfolio activity, helping ensure that modelling outputs are robust, transparent and decision-useful.

The postholder will support the assessment of investment opportunities, commercial options and downside scenarios, while helping improve the consistency and quality of modelling across GBE's sector verticals.

The role will suit an individual with strong modelling experience, attention to detail and the ability to translate complex analysis into clear insight for colleagues and decision-makers.

Key Responsibilities:

Lead the development and governance of Great British Energy's transaction modelling capability

Take responsibility for strategic financial modelling advice and recommendations to Deal Teams, Investment Committee decision-makers and other executive decision-makers, leveraging significant expertise in modelling transactions to shape investment structures, commercial negotiations and funding decisions

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.

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.

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.

Personal Qualities:

Takes ownership, shows confidence in decision-making, and is willing to challenge constructively

Focuses on delivering meaningful outcomes and making a positive, lasting impact

Works collaboratively, valuing different perspectives and building inclusive relationships

Proactive and adaptable, with a curiosity to explore new ideas and improve ways of working

Resilient and resourceful in a fast-paced environment

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: 15th September

Ad ID: 5418928693