Data Analyst - Renewable Energy PPA

Octopus Energy is a global energy leader revolutionising the way people use energy. We are not just an energy supplier - we are a tech company building a cleaner, smarter energy future. The Global Energy Markets team ensures we always have the electricity and gas we need to power our customers’ homes and businesses, while supporting the grid to accelerate the transition to Net Zero. To deliver on this mission, we are looking for a Data Analyst to join the Energy Markets team and support our PPA activities by delivering high-quality market, project and portfolio analysis.

You will identify power market trends, run financial and operational analysis of the renewable projects we contract, and assess portfolio-level performance, risk and diversification. You will work closely with commercial, trading and risk teams to turn data into clear decision-ready insights that support PPA structuring, valuation and ongoing portfolio optimisation, ensuring our contracting and risk management decisions are grounded in robust analysis. You will excel at listening, understanding stakeholder challenges and taking ownership for translating them into pragmatic analysis and scalable data products (reports, models and dashboards).

This is a fantastic opportunity to work at the intersection of renewables, markets and data in an award-winning team for a high growth business that is at the forefront of the transition to net zero.

What you will do:

• Work across Octopus Energy Group to support PPA operations and portfolio growth by liaising with Trading, Risk, Forecasting and Engineering teams.
• Become a subject matter expert on power market, generation and PPA-related datasets.
• Analyse power market trends, prices, volatility and capture rates to support contracting decisions.
• Develop and maintain data models used for PPA and portfolio reporting (including testing and version control).
• Build and maintain dashboards and analytical views for PPA performance and portfolio monitoring (e.g. Streamlit/Lightdash BI tools).
• Build, maintain and assure analytical reports for commercial, trading and risk financial and operational analysis of renewable projects under contract.
• Perform portfolio-level analysis across technologies, geographies and contract types.
• Support risk management analysis across the PPA portfolio, including price, volume and shape risk.
• Deliver one-off deep dive analyses and investigations using SQL and Python, automating recurring analyses where possible.
• Support valuation, repricing and sensitivity analysis for new and existing PPAs.
• Provide analytical support for internal reviews, audits and regulatory reporting where required.
• Consider and propose creative risk-reducing structures, including insurance, derivatives, hybrid, long-term value development.

What you will need:

• At least 2+ years experience working in a similar data position delivering actionable insights that support strategic decision-making.
• A curious and self-driven mentality – when faced with a new problem is capable of seeking out an answer with minimal support.
• Highly data literate and numerate – able to make sense of lots of data from various sources and of different types, and shape it into a coherent story.
• A great communicator – can explain complex technical problems to non-technical teams and translate business problems into efficient data solutions.
• Strong attention to detail and a commitment to data quality.
• Learns fast and is enthusiastic about learning new technologies.
• Proficient with SQL, Python, Excel and Google Sheets.

Nice to have:

• Experience building dashboards or lightweight data apps (e.g. Streamlit or Lightdash).
• Experience working in the renewable energy industry, ideally with PPA or power market analysis.
• Experience working in a modern cloud data environment, including using cloud data warehouses, version-controlled analytics codebases (e.g. git), and building analytical data models (e.g. using dbt).
• Experience working collaboratively on codebases using git.

Why else you will love it here:

• Wondering what the salary for this role is? Just ask us! On a call with one of our recruiters it is something we always cover as we genuinely want to match your experience with the correct salary.
• Octopus Energy Group is a unique culture. An organisation where people learn, decide, and build quicker. Where people work with autonomy, alongside a wide range of amazing co-owners, on projects that break new ground.
• We want your hard work to be rewarded with perks you actually care about! We were recently named the UK's top company to work for, and we ranked in the top ten in the Sunday Times Best Places to Work 2024.
• Our Group CEO, Greg has recorded a podcast about our culture and how we empower our people.
• We’ve also been placed in the top 10 companies for senior leadership.

If this sounds like you then we would love to hear from you. Our process usually takes up to 4 weeks, but we will always do our best to flex around what works for you. Along the way, you will chat with our recruitment team and your Recruiter will help you throughout different stages. Got any burning questions before then? Drop us a message at talent@octoenergy.com and we would love to help!

Are you ready for a career with us? We want to ensure you have all the tools and environment you need to unleash your potential. Need any specific accommodations? Whether you require specific accommodations or have a unique preference, let us know, and we will do what we can to customise your interview process for comfort and maximum magic!

Studies have shown that some groups of people, like women, are less likely to apply to a role unless they meet 100% of the job requirements. Whoever you are, if you like one of our jobs, we encourage you to apply as you might just be the candidate we hire. Across Octopus, we are looking for genuinely decent people who are honest and empathetic. Our people are our strongest asset and the unique skills and perspectives people bring to the team are the driving force of our success. As an equal opportunity employer, we do not discriminate on the basis of any protected attribute. Our commitment is to provide equal opportunities, an inclusive work environment, and fairness for everyone.