Senior Analytics Engineer

Octopus Energy Group; London; On-site; GBP 100,000 - 125,000; Full time

Job summary

A leading energy provider in London is seeking an experienced individual to build their analytics platform. The role involves modeling analytics for business domains, ensuring data quality, and developing dashboards. Ideal candidates should have advanced skills in SQL and Jinja, along with experience in tools like dbt Core and various cloud providers. The company promotes a unique culture and values diverse perspectives.

Benefits

Flexible salary discussions

Unique company culture

Awards for best company to work for

Qualifications

• Experience in SQL and Jinja at an advanced level is required.
• Familiarity with dbt Core and cloud warehouse providers is needed.
• Nice to have experience in Python and other modern tools.

Responsibilities

• Build and document analytics models for business domains.
• Develop charts and dashboards using modern BI tools.
• Establish data governance practices to improve data discoverability.

Skills

SQL (Advanced)

Jinja (Advanced)

Python

Tools

dbt Core

Git

Databricks

GCP

Snowflake

GitHub

Lightdash

Elementary

CircleCI

Airflow

Kubernetes

DuckDB

Spark

Job description

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

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 [e-mail] 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.