
Data Analyst – Renewable Energy PPA
Octopus Energy
full-time
Posted on:
Location Type: Hybrid
Location: London • United Kingdom
Visit company websiteExplore more
About the role
- 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 analysis 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
Requirements
- 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
Benefits
- 💰 Wondering what the salary for this role is? Just ask us! On a call with one of our recruiters it's something we always cover as we genuinely want to match your experience with the correct salary. The reason why we don't advertise is because we honestly have a degree of flexibility and would never want salary to be a reason why someone doesn't apply to Octopus - what's more important to us is finding the right octofit!
- 🎉 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
- 🎁 Visit our UK perks hub - Octopus Employee Benefits
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
data analysisdata modelingrisk management analysisportfolio analysissensitivity analysiscontracting decisionsanalytical reportingdata quality assuranceversion controlautomated analysis
Soft Skills
curiosityself-drivendata literacynumeracycommunicationattention to detailcommitment to qualityfast learnerenthusiasm for learningproblem-solving