Data Engineer (Finance)
London, UK
Octopus Energy
Octopus customers pay less: Cheaper than price-cap prices, rewards for using less when the grid is stressed, and smart tariff savings for your home, car or battery
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 Gross Margin team is responsible for producing key financial outputs to report on the profitability of the business and the different products we offer to customers.
We’re looking for a Data Engineer to help us develop and maintain the automated data pipeline that drives the Gross Margin output, keeping it as accurate as possible against the views of revenue and costs presented by our billing system and industry flow data whilst also optimising the way we process large datasets to be scalable for further exponential growth.
This is a fantastic opportunity to take on a role that combines complex data engineering with in-depth market understanding and financial analytics to deliver critical business reporting.
We’re looking for a Data Engineer to help us develop and maintain the automated data pipeline that drives the Gross Margin output, keeping it as accurate as possible against the views of revenue and costs presented by our billing system and industry flow data whilst also optimising the way we process large datasets to be scalable for further exponential growth.
This is a fantastic opportunity to take on a role that combines complex data engineering with in-depth market understanding and financial analytics to deliver critical business reporting.
What Will You Be Doing:
- Ensuring teams get the regular reporting they need: finance to support accounting and audit requirements, operations to support billing & settlement accuracy;
- Finding and solving problems leading to changing trends or irregularities in the financial numbers caused by changes in source data;
- Working with a wide variety of Octopus teams to align and improve logic where possible;
- Designing and implementing flexible tools that allow different teams to take advantage of the highly granular calculations we’re already performing;
- Setting up dashboards to automate reporting and track data health;
- Taking any opportunity to optimise existing pipeline architecture to be more scalable for exponential customer growth;
- Building new pipeline architecture for new projects;
- Supporting gross margin accountants and analysts to level up their coding skills.
Who Are We Looking For:
- Strong aptitude with SQL and Python;
- Keen eye for detail to find root causes and solve problems;
- Ability to quickly understand new domain areas and visualise data effectively;
- Ability to translate technical code logic for a variety of business stakeholders;
- Team player excited at the idea of ownership across lots of different projects and tools;
- Experience with dbt, Airflow and Spark optimisation would be a big plus.
Our Data Stack:
- SQL-based dbt pipelines running on Databricks
- Analysis via Python notebooks
- Pyspark jobs on Databricks workflows for heavy lifting
- Streamlit and Python for dashboarding
- Airflow 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
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: Airflow Architecture Databricks dbt Engineering ETL Finance Pipelines PySpark Python Spark SQL Streamlit
Perks/benefits: Flex hours Health care
Region:
Europe
Country:
United Kingdom
Job stats:
1
0
0
Category:
Engineering Jobs
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Business Intelligence Engineer jobs
- Open Lead Data Analyst jobs
- Open Data Engineer II jobs
- Open Power BI Developer jobs
- Open Senior Business Intelligence Analyst jobs
- Open Marketing Data Analyst jobs
- Open Data Science Manager jobs
- Open MLOps Engineer jobs
- Open Junior Data Scientist jobs
- Open Business Data Analyst jobs
- Open Data Scientist II jobs
- Open Business Intelligence Developer jobs
- Open Product Data Analyst jobs
- Open Data Analytics Engineer jobs
- Open Data Analyst Intern jobs
- Open Sr Data Engineer jobs
- Open Principal Data Scientist jobs
- Open Sr. Data Scientist jobs
- Open Junior Data Engineer jobs
- Open Senior Data Architect jobs
- Open Data Engineering Manager jobs
- Open Big Data Engineer jobs
- Open Research Scientist jobs
- Open Data Quality Analyst jobs
- Open Manager, Data Engineering jobs
- Open GCP-related jobs
- Open Java-related jobs
- Open Data quality-related jobs
- Open ML models-related jobs
- Open Business Intelligence-related jobs
- Open Data management-related jobs
- Open Privacy-related jobs
- Open PhD-related jobs
- Open Data visualization-related jobs
- Open Deep Learning-related jobs
- Open Finance-related jobs
- Open NLP-related jobs
- Open PyTorch-related jobs
- Open TensorFlow-related jobs
- Open LLMs-related jobs
- Open APIs-related jobs
- Open Generative AI-related jobs
- Open CI/CD-related jobs
- Open Consulting-related jobs
- Open Snowflake-related jobs
- Open Kubernetes-related jobs
- Open Hadoop-related jobs
- Open Data governance-related jobs
- Open Databricks-related jobs
- Open Airflow-related jobs