Take ownership of and expand our transformation layer using DBT, ensuring new models align with the established architectural patterns.
Design and extend dimensional models using frameworks like Kimball or BEAM, ensuring the schema accurately reflects the nuance of our business operations.
Work with BigQuery.
Establish data quality monitoring and testing frameworks.
Act as a bridge between business and data: Deeply analyse business workflows to gather requirements and translate them into reliable facts and dimensions.
Document data definitions and business logic, ensuring the "why" behind the modelling decisions is clear.
Maintain the long-term health and optimisation of the transformation layer.

4+ years experience in analytics engineering or a similar role
Strong Data Modelling expertise: You have experience designing schemas using methodologies like Star Schema, Kimball, or BEAM (Business Event Analysis & Modelling) and can confidently extend existing models.
Commercial Savvy: You can look at a business process (e.g., nursery occupancy or team scheduling) and intuitively visualise the data structures needed to represent it.
dbt experience essential.
Git version control proficiency.
BigQuery or similar data warehouse experience (Snowflake, Databricks, PostgreSQL, Redshift).
Excellent communication skills: Ability to discuss logical models with non-technical stakeholders.
Passion for data quality and engineering best practices.

Competitive salary – £70,000
£90,000, based on experience and dedication
Flexible hybrid working model for work-life balance
Up to 35 days holiday – including a personal ‘Me’ day and Christmas closure
£100 annual learning fund, plus access to in-house development opportunities
Enhanced family leave for parents, carers, and more
40% childcare discount, plus 6 emergency days annually
5-year loyalty bonus – around-the-world trip + 2 bonus weeks off
10-year loyalty bonus – ‘Out of this world’ experience + 2 extra weeks off
Referral bonus – earn up to £1,000 per successful hire
Amazing discounts – save on groceries, shopping, fitness and more
Travel support – season ticket loans and cycle-to-work scheme
Socials & wellbeing – annual parties, team events, gym discounts, and online fitness

Analytics Engineer

Key skills