Energy Data Analyst
Milan, IT
Applications have closed
Octopus Energy
The UK's most awarded energy supplier. We're doing energy better - for you and the environment.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 do
- Build and maintain a database of energy costs including (commodity, transmission, distribution, government schemes, metering costs)
- Build forecasts of uncertain energy costs
- Build and maintain a cost model in Python that combines and applies costs to customer usage profiles
- Keep 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 level
- Provide monthly reports of gross margin to the finance and strategy teams
- Reconcile industry invoices against the gross margin output
What you'll need
- A passion for working in energy and contributing to the energy transition
- An 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 support
- An interest in building robust and useable tools
Our data stack; we run a modern cloud data platform made up of the below components
- Postgres source databases
- AWS cloud infrastructure
- Databricks Delta Lake for data lake and warehouse storage and querying
- Spark for large data processing
- dbt for data modelling and transformations
- Python data ecosystem as main scripting and analytics language
- Jupyter and Jupyter Hub for notebook analytics and collaboration
- Airflow for task scheduling
- Kubernetes for orchestration
- Github, Circle CI, Grafana and Prometheus for version control, deployment and monitoring
- Tableau and Streamlit as data front ends
Why else you'll love it here
- Octopus 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 together
- Relaxation - 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 success
- Office 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 Dinner
- Your development is important - we support and help with development including internal and external courses, learning, study support etc, all bespoke to you
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: Airflow AWS Databricks Data pipelines Finance GitHub Grafana Jupyter Kubernetes NumPy Pandas Pipelines PostgreSQL Python RDBMS Spark SQL Tableau
Perks/benefits: Equity Flex hours Startup environment Transparency
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 Marketing Data Analyst jobs
- Open MLOps Engineer jobs
- Open AI Engineer jobs
- Open Junior Data Scientist jobs
- Open Data Engineer II jobs
- Open Senior Data Architect jobs
- Open Sr Data Engineer jobs
- Open Senior Business Intelligence Analyst jobs
- Open Data Analytics Engineer jobs
- Open Power BI Developer jobs
- Open Manager, Data Engineering jobs
- Open Product Data Analyst jobs
- Open Principal Data Engineer jobs
- Open Business Data Analyst jobs
- Open Data Quality Analyst jobs
- Open Data Manager jobs
- Open Sr. Data Scientist jobs
- Open Data Scientist II jobs
- Open Big Data Engineer jobs
- Open Business Intelligence Developer jobs
- Open Data Analyst Intern jobs
- Open Principal Data Scientist jobs
- Open ETL Developer jobs
- Open Azure Data Engineer jobs
- Open Data Product Manager jobs
- Open Business Intelligence-related jobs
- Open Data quality-related jobs
- Open Privacy-related jobs
- Open Data management-related jobs
- Open GCP-related jobs
- Open Java-related jobs
- Open ML models-related jobs
- Open Finance-related jobs
- Open Data visualization-related jobs
- Open Deep Learning-related jobs
- Open APIs-related jobs
- Open PyTorch-related jobs
- Open PhD-related jobs
- Open TensorFlow-related jobs
- Open Consulting-related jobs
- Open Snowflake-related jobs
- Open NLP-related jobs
- Open Data governance-related jobs
- Open Data warehouse-related jobs
- Open Databricks-related jobs
- Open Airflow-related jobs
- Open Hadoop-related jobs
- Open LLMs-related jobs
- Open DevOps-related jobs
- Open CI/CD-related jobs