Transaction Modelling Officer

Job Description

Job Title: Transaction Modelling Officer (Investment Operations)

Applying for this role is straight forward Scroll down and click on Apply to be considered for this position.

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. GBE will invest in, develop, build and operate the technologies the UK needs to increase energy independence, while giving communities a direct stake in the transition. GBE is being built to last - our ambition is to become a lasting national institution the public can be proud of, and a developer, constructor and owner of energy that is Clean, Secure and Yours. From our base in Aberdeen, we are establishing GBE as a cornerstone of the UK's energy landscape. Joining GBE means contributing at the very start of this journey: delivering long-term public value, helping shape the UK's energy future, and building your career in a mission-led, values-driven organisation.

Our ambition is to become a lasting national institution that the British public will be proud of; a developer, constructor and owner of homegrown energy that is Clean, Secure and Yours.

From our base in Aberdeen, we are building GBE not just as a company, but as a cornerstone of the UK's energy landscape: a trusted, transparent and innovative public champion that stands shoulder to shoulder with the leading state-owned energy companies of Europe. GBE will become recognised both at home and abroad as a world class energy institution that embodies the values, expertise and ambition of the UK.

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.

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:

* 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. xwwtmva

* 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