Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Analyse power market trends and deliver insights for renewable energy projects.
- Company: Join a leading team in the renewable energy sector focused on Net Zero.
- Benefits: Competitive salary, flexible working, and opportunities for professional growth.
- Why this job: Make a real impact in the transition to renewable energy while developing your data skills.
- Qualifications: 2+ years in data analysis, strong SQL and Python skills, and a passion for renewables.
- Other info: Dynamic team environment with a focus on innovation and collaboration.
The predicted salary is between 36000 - 60000 £ per year.
The Global Energy Markets team makes sure 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'll 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'll 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.
We love getting to know our applicants! To make sure we have enough time to give every application a thoughtful review, we may occasionally hit pause on new submissions. If you're excited about this role, we'd love to see your application sooner rather than later.
Responsibilities
- 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
Qualifications
- 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
Data Analyst - Renewable Energy PPA in City of Westminster employer: Octopus Energy Ltd
Contact Detail:
Octopus Energy Ltd Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Analyst - Renewable Energy PPA in City of Westminster
✨Tip Number 1
Network like a pro! Reach out to folks in the renewable energy sector, especially those in data roles. Attend industry events or webinars, and don’t be shy about sliding into DMs on LinkedIn. We all know that sometimes it’s not just what you know, but who you know!
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your data analysis projects, especially those related to renewable energy or market trends. Use platforms like GitHub to share your code and visualisations. This way, we can see your work in action and how you tackle real-world problems.
✨Tip Number 3
Prepare for interviews by brushing up on your SQL and Python skills. We love candidates who can demonstrate their technical prowess. Practice common data analysis scenarios and be ready to discuss how you’ve used data to drive decisions in past roles.
✨Tip Number 4
Apply through our website! It’s the best way to ensure your application gets the attention it deserves. Plus, we’re always excited to see passionate candidates who are eager to join our mission in the renewable energy space. Don’t wait too long; get your application in sooner rather than later!
We think you need these skills to ace Data Analyst - Renewable Energy PPA in City of Westminster
Some tips for your application 🫡
Show Your Data Skills: Make sure to highlight your experience with SQL, Python, and any data modelling you've done. We want to see how you've turned complex data into actionable insights in your previous roles.
Tailor Your Application: Don’t just send a generic application! Take the time to tailor your CV and cover letter to reflect how your skills and experiences align with our mission in renewable energy and PPA activities.
Be Clear and Concise: When writing your application, keep it clear and to the point. We appreciate well-structured applications that make it easy for us to see your qualifications and enthusiasm for the role.
Apply Early!: We love getting to know our applicants, so don’t wait too long to submit your application. Apply through our website as soon as you can to ensure we have enough time to review your submission thoughtfully.
How to prepare for a job interview at Octopus Energy Ltd
✨Know Your Data Inside Out
Make sure you’re well-versed in the key datasets related to power markets and PPAs. Brush up on your SQL and Python skills, and be ready to discuss how you've used data to drive decision-making in previous roles.
✨Showcase Your Analytical Skills
Prepare to share specific examples of how you've conducted market analysis or built dashboards in the past. Highlight any experience with tools like Streamlit or Lightdash, as this will demonstrate your ability to create actionable insights from complex data.
✨Communicate Clearly
Practice explaining technical concepts in simple terms. You’ll need to convey your findings to non-technical stakeholders, so being able to translate data into a compelling narrative is crucial. Think about how you can make your insights relatable.
✨Demonstrate Your Curiosity
Be ready to discuss how you approach new challenges and seek out solutions independently. Share examples of when you’ve taken the initiative to learn new technologies or methodologies that have benefited your work.
