Data Engineer - Margin Assurance

Number of employees

3800

London, UK, United Kingdom

Posted on: 2024-02-16

Category: energy

Apply now

Please let Octopus Energy know you found this job on Work in Green. This will help us grow!

Employment type:

Full time

Experience required:

Intermediate

Salary

Salary not provided

About the company:

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.

Octopus Energy Group is made up of 10 businesses spanning 6 countries across 3 continents, including: Octopus Energy Retail, Kraken Technologies, Octopus Energy Generation, Kraken Flex, Octopus Electric Vehicles, and the Octopus Centre for Net Zero. More on OEG @ octopusenergy.group

Overview

Do you love data engineering? Do you also have experience analysing and getting value from financial and settlement data? If you’re a “strong yes” to both of those questions then you’ll love this role……

Octopus Energy is now one of the largest suppliers of gas and electricity to UK householders, with 6.5 million customers and a multi-billion pound turnover. Our Margin Assurance team delivers value to the business through product development, reporting & bespoke analysis relating to the margin gap created by inflated costs and missed revenue opportunities.

The Margin Assurance Product aims to build on existing pipelines that produce a highly granular view of consumption, revenue and costs for every register and settlement period within the time range specified, accounting for the majority portion of Octopus’ financials and the basis for financial reporting to many stakeholders, including Octopus board, CFO and several teams within Octopus. 

The product will identify where there is an imbalance between cost to serve and revenue generated, breaking down historical financial reporting by root causes, summarising areas of opportunity in the operational business to resolve and rebalance, generating gross margin for the retail business.

The more of the below skills you have, the higher the probability that you’ll be a good fit for this role. Our perfect person would meet a minimum standard in all of these areas… but we place an equally high value on an ability to pick up new skills and knowledge … and nobody (least of all us) is perfect! 

Desirable Skills

  • dbt modelling and testing (SQL and Python)
  • Python analysis on Jupyter Hub
  • Pyspark coding in Databricks notebooks
  • Spark job optimisation on Databricks
  • Inksacio dashboards
  • Process mapping in MIRO
  • Documentation in Notion and/or Secoda
  • What kind of responsibilities does this job include

  • Leading product engineering, including design and delivery.
  • Automating and expanding the product's suite of reconciliations to assure accuracy of output
  • Expanding the use cases of the output and making it easily accessible so other teams can benefit from its granular detail
  • Setting up dashboards to automate reporting and track data integrity.
  • Designing and implementing easy-to-use processes that allow for highly flexible adjustments to the GM Assurance output for spontaneous operational and accounting requirements
  • Ensuring the Margin Assurance and Industry Ops teams gets the output they need on a weekly/monthly basis
  • Finding, troubleshooting and solving problems leading to shifting trends or irregularities in the margin assurance numbers caused by changes in Kraken, industry or coding logic, including new changes in the market
  • Working with a wide variety of teams across Kraken and OE Business to align and improve logic where possible, particularly with regards to customer edge cases
  • Supporting related Gross Margin team projects
  • Our Data Stack:

  • This is the tool suite we currently use and will help you learn in this role:
  • SQL-based pipelines built with dbt on Databricks
  • Analysis via Python jupyter notebooks
  • Pyspark in Databricks workflows for heavy lifting
  • Streamlit and Python for dashboarding
  • Airflow DAGs with Python for ETL
  • Notion/Secoda for data documentation
  • Why else you'll love it here

  • 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 won best company to work for in 2022, on Glassdoor we were voted 50 best places to work in 2022 and 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 and most recently The Sunday Times, Best Places To Work 2023
  • Visit our UK perks hub - Octopus Employee Benefits
  • Similar climate jobs

    These are some of our top picks for great climate jobs on Work in Green.

    View all jobs
    Octopus Energy logo
    United Kingdom
    Octopus Energy logo
    United Kingdom
    Number of employees

    3800

    Full time
    Energy
    Octopus Energy logo
    United Kingdom
    Octopus Energy logo
    United Kingdom
    Octopus Energy logo
    United Kingdom

    518 Energy jobs at Octopus Energy

    Octopus Energy is hiring Area Manager - Low Carbon Heating - Bristol,Electrician - England,Area Manager - Low Carbon Heating - Berkshire, and more.

    View all jobs at Octopus Energy
    Octopus Energy logo
    United Kingdom
    Octopus Energy logo
    United Kingdom
    Number of employees

    3800

    Full time
    Energy
    Octopus Energy logo
    United Kingdom
    Octopus Energy logo
    United Kingdom
    Octopus Energy logo
    United Kingdom