Octopus Energy

Lead Data Engineer

London, UK Remote Hybrid
SQL Python Spark AWS
Description
Octopus Energy supplies electricity and gas to over 7 million UK householders and is at the forefront of innovation in the drive towards net zero. Our Gross Margin team produces key financial reporting and analysis to support decision making and margin improvements across the UK business. We also support teams in other countries where Octopus operates.

The Gross Margin pipeline - for which you will be responsible along with a team of three engineers - uses a vast amount of data and produces a highly granular view of consumption, revenue and costs. Challenges include the quantity and quality of data and the estimations required where data does not exist. We have a superb pipeline with a very exciting dataset, analysis from which provides valuable information s across the business, e.g. driving development of Octopus’ industry-leading Time Of Use tariffs, refining financial forecasting, and preventing multi-million pound write-offs. 

The Lead Data Engineer will drive the technical vision behind this pipeline as our customer base continues to grow and market development towards net zero requires an increasingly data-heavy calculation of energy consumption, and will also take joint responsibility for the accuracy of our outputs and guiding engineers in the team on their own career progression.

What You'll Do...

  • Product Leadership: You will shape the design of the Gross Margin pipeline so it continues to accurately reflect actual revenue and costs when reconciled against internal billing systems and external industry flow data, whilst also making it more accessible and valuable to teams across the wider Octopus business.
  • People Leadership: You will support and develop the technical progression of top-tier engineering talent while fostering an inclusive and productive team environment.
  • Technical Leadership: You will oversee the technical and delivery outcomes of our Gross Margin pipeline for maximum scalability, efficiency and simplicity whilst driving best practices within the codebase. 

What You'll Need...

  • Proven Track Record: History of shipping product updates, getting things done, and leading teams in high-growth, product-focused organisations.
  • Management and Leadership Experience: 2+ years managing high-performance engineering teams, with a focus on people leadership, providing support, coaching, and development.
  • Modern Data Expertise: 5+ years building highly scalable technology products using SQL and Python. Experience with Databricks, dbt, Spark and AWS would be a big plus.
  • Commercial Mindset: Experience in financial reporting is not required (although a plus), but appreciation for the business implications of what the data shows us is key.
  • Test Driven Development: Passion for ensuring code changes improve our view of Gross Margin and don’t inadvertently break anything else.
  • Hands-on Approach: You are eager to contribute to design and code alongside your team.
  • Engineering Excellence: Fostering a high bar for engineering excellence, holding teams accountable for technical outcomes and individual growth.
  • Balanced Decision-Making: Ability to make trade-offs between product velocity and technical debt to iteratively improve the pipeline.
  • Technical Influence: Partnering with other engineers to drive initiatives that elevate best practices.
  • Stakeholder Relationships: Building strong relationships with other teams to ensure they are able (and know how) to get the most benefit from the pipeline.

Our Data Stack...

  • SQL and Python 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 for data documentation

Octopus Energy
Octopus Energy
Energy Energy Efficiency GreenTech Renewable Energy

0 applies

5 views

Other Jobs from Octopus Energy

Data Analyst - Credit Risk

London, UK Remote Hybrid

Data Scientist

Tokyo, Japan Remote Hybrid

Finance Data Analyst

Milan, Italy Remote Hybrid

Lead Data Engineer - Gross Margin

London, UK Remote Hybrid

There are more than 50,000 engineering jobs:

Subscribe to membership and unlock all jobs

Engineering Jobs

60,000+ jobs from 4,500+ well-funded companies

Updated Daily

New jobs are added every day as companies post them

Refined Search

Use filters like skill, location, etc to narrow results

Become a member

🥳🥳🥳 452 happy customers and counting...

Overall, over 80% of customers chose to renew their subscriptions after the initial sign-up.

To try it out

For active job seekers

For those who are passive looking

Cancel anytime

Frequently Asked Questions

  • We prioritize job seekers as our customers, unlike bigger job sites, by charging a small fee to provide them with curated access to the best companies and up-to-date jobs. This focus allows us to deliver a more personalized and effective job search experience.
  • We've got about 70,000 jobs from 5,000 vetted companies. No fake or sleazy jobs here!
  • We aggregate jobs from 5,000+ companies' career pages, so you can be sure that you're getting the most up-to-date and relevant jobs.
  • We're the only job board *for* software engineers, *by* software engineers… in case you needed a reminder! We add thousands of new jobs daily and offer powerful search filters just for you. 🛠️
  • Every single hour! We add 2,000-3,000 new jobs daily, so you'll always have fresh opportunities. 🚀
  • Typically, job searches take 3-6 months. EchoJobs helps you spend more time applying and less time hunting. 🎯
  • Check daily! We're always updating with new jobs. Set up job alerts for even quicker access. 📅

What Fellow Engineers Say