Enable job alerts via email!

Analytics Engineer

Octopus Energy

London

Hybrid

GBP 45,000 - 65,000

Full time

6 days ago

Be an early applicant

Boost your interview chances

Create a job specific, tailored resume for higher success rate.

Job summary

A leading company in the energy sector is seeking a Data Engineer to join their innovative Analytics Platform team in London. This role involves building data models and analytics tools that contribute to optimizing customer experiences across its global operations. Interested candidates should have advanced SQL skills and experience with modern BI tools, with a commitment to data quality and governance.

Qualifications

Experience in SQL and Jinja for data modeling.
Familiarity with dbt and cloud warehouse tools.

Responsibilities

Build and consult on analytics models using dbt.
Develop dashboards and testing frameworks.

Skills

SQL

Jinja

Data Governance

Data Modeling Techniques

CI/CD Pipelines

Education

Bachelor's Degree in Computer Science or related field

Tools

dbt Core

Git

Databricks

Airflow

CircleCI

1 week ago Be among the first 25 applicants

London (GB)

Octopus Energy UK – Data /

Full-time /

Hybrid

Over the past ten years, Octopus Energy Group has expanded from a UK startup to become the UK's largest energy provider and a global leader, serving over 10 million customers across eight countries.

The Analytics Platform team is brand new to the company and is tasked with consolidating analytics tooling and building a strategy for consistent data modelling across all our global businesses. We are building a platform that each country can plug their respective data into and get consistent data to be used to optimise customer journeys for each region or metrics at the global level by the group management team.

Our mission is to build a platform for analytics where:

Producers can build efficient pipelines from source data to insight with ease
Producers can scale out Modelling & BI to any number of Octopus Energy businesses around the world

Producers can provide insight via:

Notebooks for detailed storytelling
Dashboards for live updates on a domain
Consumers can find what they’re looking for with ease
Consumers have trust in the metrics and dashboards they’re presented with
Consumers can self-serve if needed
Consumers can retrieve data via automation

What you’ll do:

Build, document and consult on:
Using dbt to model analytics for business domains using a data mesh framework.
Charts and dashboards using modern BI tools
Comprehensive testing frameworks using tools like dbt_expectation and elementary to ensure data quality
Data governance and documentation strategy to improve data discoverability and drive a consistent approach across teams
Build robust CI/CD pipelines for testing and deployment of AE and BI models.
Build monitoring and alerting tools for gathering insight on AE performance
This role requires

Experience in the following Languages:

SQL (Advanced)
Jinja (Advanced)

Experience with the following tools:

dbt Core
Git
A Cloud warehouse provider e.g. Databricks, GCP, Snowflake
The following would be nice to have

Experience in the following Languages:

Python

Experience with the following tools:

Github
Lightdash
Elementary
CircleCI
Databricks
Airflow
Kubernetes
DuckDB
Spark
Data Modelling Techniques e.g. Kimball, OBT

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 hiring@octoenergy.com 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.

Seniority level

Seniority level
Entry level

Employment type

Employment type
Full-time

Job function

Job function
Information Technology
Industries
Utilities and Environmental Services

Referrals increase your chances of interviewing at Octopus Energy by 2x