As an Analytics Engineer, you will build and optimize data pipelines, model cost databases, analyze data for performance, and collaborate with teams on data-driven insights.
At Octopus Energy Services, we're at the forefront of the energy revolution, committed to accelerating the global transition to a sustainable future. The widespread adoption of low carbon technologies is critical to achieving net-zero emissions and combating climate change. Our mission is to make these innovative solutions not only environmentally friendly but also as cost-effective and accessible as possible, ensuring a greener, more affordable energy landscape for everyone.
As a Supply Chain and Cost Data Engineer, you will play a critical role in driving our business forward. You will work closely with our supply chain, finance, commercial and operations teams to provide cleaned, up-to-date information and data-driven insights that inform business decisions and improve our competitiveness and scalability. In the role, you’ll work on some of the biggest challenges facing the organisation and leverage the latest technologies to answer these problems.
What You'll Do:
- Create, maintain and optimise data pipelines for various different streams of cost information
- Model a cost database using dbt and create semantic layers to inform AI enabled dashboards, reports, and visualisations
- Analyse and interpret data to track and improve commercial and operational performance
- Collaborate with supply chain and operations teams to identify opportunities for growth, optimisation and better service delivery.
- Use statistical analysis and modelling techniques to forecast and project business performance.
- Provide ad-hoc analysis and support as required.
What You'll Have:
- Essential skills
- A passion for sustainability and the drive to make a positive impact on the world.
- at least +2 years of experience building data pipelines, using Python and dbt
- Experience collaborating on codebases using Git and Github
- Strong analytical skills, commercial interest, and the ability to distinguish between what matters and what doesn't.
- Experience working in a fast-paced, dynamic environment.
- Comfortable manipulating and analysing data in a scripting language
- Proficient in writing robust, performant SQL queries
- Optional but desirable:
- Experience within supply chain or financial teams
The Data Tech Stack:
- Python as our main programming language
- DBT for data modelling
- Databricks as our datalake platform
- Kubernetes for data services and task orchestration
- Terraform for infrastructure
- Streamlit and Lightdash for data applications
- Airflow for job scheduling and tracking
- Circle CI for continuous deployment
- Parquet and Delta file formats on S3 for data lake storage
- Spark for data processing
- SparkSQL for analytics
💚 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
- 🎁 Visit our UK perks hub - Octopus Employee Benefits
Our process usually takes up to 4 weeks, but we’ll always do our best to flex around what works for you. Along the way, you’ll chat with our recruitment team and your Recruiter will help you throughout different stages. Got any burning questions before then? Drop us a message at [email protected] and we’d love to help!
If this sounds like you then we'd love to hear from you. 🚀
Are you ready for a career with us? We want to ensure you have all the tools and environment you need to unleash your potential. Need any specific accommodations? Whether you require specific accommodations or have a unique preference, let us know, and we'll do what we can to customise your interview process for comfort and maximum magic!
Studies have shown that some groups of people, like women, are less likely to apply to a role unless they meet 100% of the job requirements. Whoever you are, if you like one of our jobs, we encourage you to apply as you might just be the candidate we hire. Across Octopus, we're looking for genuinely decent people who are honest and empathetic. Our people are our strongest asset and the unique skills and perspectives people bring to the team are the driving force of our success. As an equal opportunity employer, we do not discriminate on the basis of any protected attribute. Our commitment is to provide equal opportunities, an inclusive work environment, and fairness for everyone.
Top Skills
Airflow
Circle Ci
Databricks
Dbt
Delta
Git
Git
Kubernetes
Lightdash
Parquet
Python
Spark
SQL
Streamlit
Terraform
Octopus Energy London, England Office
1 Upper James Street, London, United Kingdom, W1F 9DE
Similar Jobs
Artificial Intelligence • Machine Learning • Software
The Senior Implementations Data Engineer will design, develop, and maintain data pipelines, ensure data security, and support customer integrations, working with cross-functional teams and stakeholders.
Top Skills:
AWSAzureDatabricksDockerGitKubernetesOpensearchPostgresPythonRest ApisSparkSQL
Financial Services
Lead development of strategic data pipelines and software solutions for Credit Trading. Collaborate with stakeholders to enhance operational stability, promote innovation, and ensure technology meets business needs.
Top Skills:
AWSAzureGCPKdb+OraclePostgresPythonVertica
Fintech • Information Technology • Financial Services
As a Vice President, you will lead Preqin's Data Engineering/BI team, develop data infrastructure, ensure stakeholder alignment, and promote data best practices. You will also drive the adoption of advanced analytics and AI/ML solutions.
Top Skills:
AWSAzureDbtKubernetesPythonSnowflakeSQLTerraform
What you need to know about the London Tech Scene
London isn't just a hub for established businesses; it's also a nursery for innovation. Boasting one of the most recognized fintech ecosystems in Europe, attracting billions in investments each year, London's success has made it a go-to destination for startups looking to make their mark. Top U.K. companies like Hoptin, Moneybox and Marshmallow have already made the city their base — yet fintech is just the beginning. From healthtech to renewable energy to cybersecurity and beyond, the city's startups are breaking new ground across a range of industries.
