Data Analyst – Pricing / Commercial

Job Category: Finance and Business
Job Type: Full Time
Job Location: England
Company Name: Octopus Energy

Company Overview

We’re on a mission to make a big green dent in the universe by building a truly sustainable energy system globally. That means making power greener, smarter, and more affordable for everyone. We put customers at the heart of everything we do: with always-fair prices, transparency and outrageous customer service. We drive system change: with transformative tech to make renewable energy the norm and end global reliance on fossil fuels.
At Octopus, we’ve led the way in innovating new ways to price energy to give customers more control over their energy costs, stamp out the loyalty penalty seen in much of the industry and engage customers to use energy when it is greenest and cheapest. We’re looking for a smart, passionate analyst to join the pricing and commercial function within our data team to help us manage and develop our energy products, and understand customer choices.

Our team takes a technology- and data-driven approach to managing our complex pricing portfolio and sales channels. We apply modern open data and analytics tools like Python, Pandas and Jupyter Notebooks to build pricing tools and customer behaviour models. We’re passionate about automating workloads and processes so we can concentrate on the interesting problems. We’re looking for someone who is equally motivated by using technology to solve problems.

This is a fantastic opportunity to work on problems that genuinely move us closer to Net Zero with a company that is passionate about building great technology and products that change the way customers use energy.

A little heads-up: With some of our team taking some well-deserved annual leave over the next couple of weeks, we may not get around to carefully reviewing all applications until the new year. Every application gets reviewed by a real human, and we’ll be in touch to let you know either way—whether it’s a yes or, sadly, a no this time round. Thanks for your patience and understanding!

What You’ll Do…

  • Produce regular reports and deliver insight into sales and losses, across our different sales channels
  • Perform competitor and market analysis
  • Analyse customer switching behaviour and influences (internal e.g. tariff choice or contract renewals; and external e.g. competitor pricing or house moves)
  • Support operational reporting to monitor and improve growth across our acquisition channels (e.g. commissions reporting, sales incentive performance)
  • Execute and optimise tariff reprices according to our pricing principles
  • Build tools and pricing dashboards to visualise product offerings and report margins
  • Work closely with a broad range of teams including Cost, Procurement, Strategy, Sales and Marketing teams
  • Provide regulatory and policy support on switching and pricing

What You’ll Need…

  • We don’t need prior energy supplier experience (we can teach that), although experience working in energy retail is a bonus.
  • Ideally 2 years of professional experience
  • To be passionate about working in energy and contributing to the energy transition
  • To be curious and self-driven – when faced with a new problem is capable of seeking out an answer without lots of help and support
  • To be highly data literate and numerate – can make sense of lots of data and shape it into a coherent story
  • To have great attention to detail
  • To communicate complex ideas clearly

You will also need to have experience with some of the below technologies:

  • A scripting language (ideally Python with pandas)
  • Wrangling data outside of a spreadsheet environment
  • Writing performant queries in SQL / dbt
  • Building reports and dashboards in a BI tool (ideally Tableau or Streamlit)
  • To be passionate about building robust and useable tools

    APPLY

Apply for this position

Allowed Type(s): .pdf, .doc, .docx