Energy Data Analyst at Octopus Energy

Posted on:
January 5, 2023

🔭 Our mission & vision

Job Description

Our mission is to bring cheaper, green power to customers across the country and shake up the market in Italy

Octopus Energy entered the Italian market in November 2021 with the acquisition of the energy retailer SATO Luce e Gas, which is now rebranding as Octopus Energy Italia and is on a mission to bring cheaper, green power to customers across the country and shake up the market. Octopus Energy Italy is targeting 1 million Italian energy accounts by 2025 (5% of the market) and is now in a start-up phase which means that you will be able to shape the future of energy in Italy from day one.

We're providing a better experience for our customers through transparency, honesty and simplicity. We want to do better for the planet, through real long-term investment in renewable generation and a low CO2 future and better for our customer’s wallets with fair and affordable plans. We're revolutionizing what's possible in energy, through our proprietary platform and custom-built stack, cloud-based billing and sophisticated use of data science. We are relentlessly focused on customer satisfaction and cherish the reward of receiving tremendous reviews from our customers.

We’re looking for a data analyst to join our Italian business to work on energy cost modelling and gross margin calculations. This role will focus on two areas: forecasting energy costs and calculating the gross margin of our supply business. These two activities are at the core of our energy supply operation and inform pricing, planning, financial reporting and operational efficiency. 

This role will require you to combine an in-depth understanding of the Italian energy business with expertise using a modern set of data tools (Python, SQL, dbt, Spark). We’re looking for someone with at least one of these capabilities and who is eager to learn the other.

You’ll work closely with the trading, data, finance and strategy teams and will be supported by cost and gross margin analysts in the UK. This is a great opportunity to be a key part of a young energy business focussed on Net Zero that is transforming how Italians buy energy.

What you'll doBuild and maintain a database of energy costs including (commodity, transmission, distribution, government schemes, metering costs)Build forecasts of uncertain energy costsBuild and maintain a cost model in Python that combines and applies costs to customer usage profilesKeep track of regulatory changes that may affect energy costs Build and maintain gross margin data pipelines that calculate cost, revenue and margin at a customer levelProvide monthly reports of gross margin to the finance and strategy teamsReconcile industry invoices against the gross margin outputWhat you'll needA passion for working in energy and contributing to the energy transitionAn understanding of the industry cost structures and settlement and charging methodologies (or is motivated to learn these)A scripting language (ideally Python) Experience with relational databases (ideally Postgres)The ability to wrangle data outside of a spreadsheet environment (ideally using the Python data toolkit - pandas, numpy, Jupyter)Building data models in dbt (not essential but desirable)Experience in a collaborative cloud based development environment (AWS, Github)To be curious and self driven - when faced with a new problem is capable of seeking out an answer without lots of help and supportAn interest in building robust and useable toolsOur data stack; we run a modern cloud data platform made up of the below componentsPostgres source databasesAWS cloud infrastructureDatabricks Delta Lake for data lake and warehouse storage and queryingSpark for large data processingdbt for data modelling and transformationsPython data ecosystem as main scripting and analytics languageJupyter and Jupyter Hub for notebook analytics and collaborationAirflow for task schedulingKubernetes for orchestration Github, Circle CI, Grafana and Prometheus for version control, deployment and monitoringTableau and Streamlit as data front endsWhy else you'll love it hereOctopus Energy 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!Flexible working environment - genuine work life balance here, we treat you as a human, and do our best to make work and life merge smoothly togetherRelaxation - we don’t count your holidays here, we work hard, and so we know you need to play hard as well (within reason of course)Equity Options Scheme - you own your own part of the business, share options in the whole Octopus Energy Group so we all work together towards successOffice culture - have a certain tech requirement? We’ll do our best to get it. Weekly on a Friday we all get together (this happens virtually too) for company updates and drinks - we call it Family DinnerYour development is important - we support and help with development including internal and external courses, learning, study support etc, all bespoke to you

Apply for this job

Responsibilities & tasks

Ideal candidate

Skills & qualifications

About the team

How to apply

Is something wrong with this job posting? Doesn't match your idea of good?
Let us know and help us maintain the quality of jobs.

Apply for this job

Similar jobs


No related jobs

Want to stay up to date of all new job openings poping up? Subscribe to our newsletter to receive great jobs every week.

Thanks for joining our newsletter.
Oops! Something went wrong.