Transaction Modelling Officer

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…