Analytics Engineer

What we need

We're looking for an Analytics Engineer to help build and maintain the data models that power analytics and data science across the business. You'll develop robust, scalable dbt pipelines and help evolve our data platform — ensuring data is accessible, trusted, and well-structured.

Our core platform (Snowflake, dbt, Airflow) is established and isn't changing. What is changing is the layer on top: we're rethinking our semantic and BI layer for AI/MCP-driven self-service, so analysts, stakeholders, and AI agents can query trusted metrics directly. You'll help design the models and metric definitions that make that possible.

This is also a role built around AI-assisted development. We expect you to use AI tools (e.g. Claude Code, Cursor, Copilot) as a normal part of writing dbt models, tests, and docs — while still understanding what's happening underneath, so you can catch when the tooling gets it wrong and work effectively without it.

You'll report to the Director of Data Engineering within the Data & Insight team. We're looking for someone detail-oriented, pragmatic, and hands-on — who takes ownership, moves quickly without cutting corners, and is responsive to user needs.

What you'll work on

Data Modelling & Transformation

• Build and maintain dbt models, using AI coding assistants to accelerate development while retaining full understanding of the resulting logic

• Translate business requirements into scalable data models

• Design warehouse schemas using dimensional modelling (facts, dimensions, SCDs, etc.)

• Participate in design and code reviews — including reviewing AI-generated code with the same rigour as hand-written code

• Define and expose models and metrics through our semantic layer, with an eye to how AI agents will consume them via MCP

Testing, Documentation, and CI/CD

• Implement dbt tests for data quality and accuracy

• Document models and metric definitions clearly, for both human and AI consumption

• Use GitHub and CI/CD pipelines, incorporating AI-assisted workflows where they add value

Performance & Architecture

• Optimise dbt models and SQL queries for performance and maintainability

• Work with Snowflake on top of a data lake architecture

• Contribute to evolving our semantic/BI layer toward AI/MCP-driven self-service

What we're looking for

Required Skills & Experience

• Strong experience building and optimising complex SQL (joins, window functions, optimisation)

• Strong grasp of data modelling and warehouse design (Kimball-style)

• Production dbt experience, including testing and documentation

• Hands-on experience using AI coding tools (e.g. Copilot, Cursor, Claude Code) as a real part of your workflow, not occasional use

• Strong-enough fundamentals to work confidently without AI assistance and to critically assess AI-generated output

• Familiarity with version control (GitHub)

• Able to independently translate business logic into technical implementation

• Comfortable giving and receiving code review

Desirable - but not required

• Snowflake experience

• Semantic layer experience (e.g. Omni, Cube, dbt Semantic Layer)

• BI tools (e.g. Omni, Tableau, Metabase)

• Exposure to AI agent tooling / MCP

• CI/CD for data workflows

• Python/Airflow familiarity

• Terraform / IaC

Benefits

• Time off - 27 days holiday, plus 5 additional days off: 1 life event day, 2 volunteer days, 2 company-wide wellbeing days (M-Powered Weekend) and 8 bank holidays per year

Our Commitment to Diversity, Equity and Inclusion