Data Engineer - Margin Assurance

Octopus Energy

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!

Apply to job

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

6295 Energy jobs