Analytics Engineer – SQLMesh (Contactor)

arrow

London / £400 - £405 day

INFO

Salary
SALARY:

£400 - £405

Location

LOCATION

London

Job Type
JOB TYPE

Contract

Analytics Engineer - 6‑Month Contract

£400 per day (Inside IR35)
REMOTE anywhere in the UK
Start: 1st May


The Role

A growing data team within the digital/consumer sector is looking for a SQL‑first Analytics Engineer to help build out a robust, scalable analytics layer. You'll be joining a small, collaborative team focused on strengthening data models, improving governance, and laying the foundations for AI‑driven analytics.

This role sits at the intersection of data modelling, analytics engineering, and modern AI‑enablement. You'll transform raw data into well‑structured, trusted datasets that support decision‑making across the business - while also helping shape a semantic layer designed for future AI and LLM‑powered use cases.

You'll be joining at a pivotal moment: the platform is in place, proof‑of‑concepts are underway, and the team needs someone who can own modelling, testing and semantic design from day one.


What You'll Be Doing

  • Designing and building clean, scalable data models for analytics, reporting, and self‑serve
  • Writing highly efficient SQL to transform raw data into business‑ready datasets
  • Using SQLMesh (or similar frameworks such as dbt) to orchestrate transformations
  • Working with stakeholders to understand key business questions and model data accordingly
  • Improving data quality, testing, documentation and governance
  • Contributing to the development of a strong semantic layer to support AI/LLM adoption
  • Exploring opportunities to integrate AI into analytics workflows and automation
  • Ensuring data structures, metadata and context enable accurate natural‑language querying
  • Understanding downstream impact - supporting analysts, engineers and business users

What We're Looking For

  • Strong SQL‑first mindset - SQL as your primary problem‑solving tool
  • Proven experience with transformation frameworks (SQLMesh, dbt, or similar)
  • Solid understanding of data modelling principles and trade‑offs
  • Experience building models in cloud data warehouses (Snowflake, BigQuery, Redshift, etc.)
  • Ability to design intuitive, business‑friendly datasets
  • Understanding of data architecture and how layers fit together
  • Curious, pragmatic, collaborative - comfortable working in a small team
  • Strong communication skills and willingness to ask for support when needed

Bonus Points

  • Experience designing data models to support AI/ML or LLM‑based analytics
  • Interest in using AI tools to enhance developer productivity
  • Exposure to semantic layers or metrics layers
  • Experience with customer data
  • Ability to make thoughtful, real‑world trade‑offs in data design

Why This Role Has Come About

The team is scaling up its engineering capability and investing heavily in AI‑driven analytics. They've brought in another contractor and are now looking for someone who can:

  • Strengthen and extend existing data models
  • Build a robust semantic layer
  • Support AI proof‑of‑concepts
  • Improve governance and testing
  • Ensure analytics models are reliable, well‑documented and scalable

This role will be critical in shaping how the business uses data - both operationally and through new AI‑enabled workflows.


Interview Process

  • 1‑hour interview with the Data Lead
  • Skills assessment focused on SQL, modelling, and analytics engineering
  • Immediate availability - interviews scheduled this week

Contract Details

  • £400 per day
  • Inside IR35
  • 6‑month contract
  • Remote
  • Start: End of April / 1 May

CONTACT

Olivia Kavaya-Savage

Business Manager - Contract

SIMILAR
JOB RESULTS

4k-Harnham_DA copy
CAN’T FIND THE RIGHT OPPORTUNITY?

STILL
LOOKING?

If you can’t see what you’re looking for right now, send us your CV anyway – we’re always getting fresh new roles through the door.