Analytics Engineer - SQLMesh (Contactor)
New Yesterday
Find out if this opportunity is a good fit by reading all of the information that follows below.
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. xehkeey 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
- Location:
- London
- Job Type:
- FullTime
- Category:
- Engineering