Analytics Engineer

• 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.
• Startup/scale-up mindset — adaptable, hands-on, and comfortable wearing many hats. You'll thrive in a small team building a new function, where priorities shift and you figure things out rather than follow a playbook.
• 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.
  
  

• Building ML models or running data science projects (just yet) — our focus is on a rock-solid analytics foundation first
• Working in isolation — you'll be embedded in a small, tight team, working closely with the Business Analyst, Automation Engineer, Data Analyst, and Director of Data & AI, as well as department teams across the business
• Building workflow automations (that's the Automation Engineer)

• 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
  
  

What's next?