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.
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.
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.
- Aware 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 Midlothian 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 Midlothian
✨Tap into Campus Networks
If you're still in uni, don’t forget to engage with your campus's career services and attend finance-related events. Banks often do presentations and recruitment drives on campus, so put yourself out there and make use of these opportunities to show off your passion for the field.
✨Get Certified
Consider pursuing relevant certifications like the CFA or ACCA while you’re job hunting. They not only beef up your CV but also connect you with professional bodies which can lead to networking opportunities and even job openings in banking and financial services.
✨Connect on Professional Platforms
Join finance-focused groups on platforms like LinkedIn and engage in discussions. This can really help you stand out from the crowd, allowing potential employers to see your knowledge and interest in industry trends. Plus, you might stumble upon job postings shared exclusively within the group.
✨Apply Directly and Be Proactive
Don’t shy away from reaching out directly to firms like Public Sector Resourcing CWS. Use their websites and apply through them, but also consider following up with a polite email to express your enthusiasm. Being proactive can make a huge difference in getting noticed in the competitive financial services sector.
Some tips for your application 🫡
Show Off Your Numbers!:In the banking and financial services world, quantifiable achievements are key. Make sure your CV highlights your grades in relevant subjects, any financial certifications you hold, and specific projects where you've delivered measurable results. Employers love to see how your skills translate into real-world success.
Tailor Your Cover Letter to the Role:When applying for a full-time position, your cover letter should make a direct connection between your experience and the job description. Don't just state your enthusiasm for finance—dive into how your background in banking or financial analysis sets you apart. Let your passion shine through while being specific about what you can bring to Public Sector Resourcing CWS.
Include Relevant Financial Software Experience:If you've worked with financial modelling tools or software like Excel, SAP, or specific analytical tools during your studies or internships, bring that up! Highlighting your proficiency can really make your application pop and show you're ready to hit the ground running in a full-time role.
Research and Reflect:Before hitting that 'apply' button on Public Sector Resourcing CWS's website, do a little digging. Look up their recent projects, values, and culture. Reflecting their ethos in your application can make a huge difference and show you’re genuinely interested in being part of the team!
How to prepare for a job interview at Public Sector Resourcing CWS
✨Brush Up on Financial Analysis Skills
Make sure you're well-versed in financial concepts and analytical techniques relevant to banking and financial services. Get comfortable with tools like Excel for modelling or financial forecasting, as technical questions in this area are common during interviews with Public Sector Resourcing CWS.
✨Prepare for Case Studies
Expect to tackle case studies that demonstrate your problem-solving skills in real-world banking scenarios. Familiarise yourself with the types of problems you might face—think risk assessments or investment evaluations—and be ready to articulate your thought process clearly.
✨Show Your Passion for Finance
Since this is a full-time position, employers at Public Sector Resourcing CWS will be keen to see your genuine interest in finance. Be prepared to discuss recent industry trends or news articles that excite you, showcasing your enthusiasm and engagement with the field.
✨Network with Industry Professionals
Before your interview, reach out to current or former Public Sector Resourcing CWS employees on platforms like LinkedIn. They'll offer unique insights into the company's culture and the interview process, which can give us a delightful edge in showcasing a good fit for the team.
