Staff Analytics Engineer (dbt) — Data Mesh & BI Architect

Octopus Energy Ltd; City of Westminster; On-site; GBP 60,000 - 80,000; Full time

Job summary

A leading energy provider in the UK seeks an analytics professional to build and document data models using dbt within a data mesh framework. The role encompasses the creation of dashboards, robust CI/CD pipelines, and the implementation of monitoring tools to drive data insight. Candidates should possess deep expertise in dbt, advanced SQL skills, and familiarity with cloud warehousing. This position is pivotal in consolidating analytics tooling across global teams.

Qualifications

• Deep expertise with dbt Core and Git.
• Advanced experience with SQL and Jinja.
• Solid understanding of data modelling techniques.

Responsibilities

• Build and document analytics models using dbt and data mesh framework.
• Create charts and dashboards with modern BI tools.
• Develop CI/CD pipelines for testing and deployment.
• Implement monitoring and alerting tools for data insights.

Skills

dbt Core

SQL

Jinja

Data Modelling Techniques

Cloud Warehousing (Databricks, GCP, Snowflake)

Tools

GitHub

Lightdash

Elementary

CircleCI

Databricks

Airflow

Kubernetes

DuckDB

Spark

Job description

A leading energy provider in the UK seeks an analytics professional to build and document data models using dbt within a data mesh framework. The role encompasses the creation of dashboards, robust CI/CD pipelines, and the implementation of monitoring tools to drive data insight. Candidates should possess deep expertise in dbt, advanced SQL skills, and familiarity with cloud warehousing. This position is pivotal in consolidating analytics tooling across global teams.