Analytics Engineer

We’re looking for an Analytics Engineer to build and maintain the data models that power analytics and data science across the business. You’ll focus on developing robust and scalable dbt pipelines and contributing to the evolution of our data platform, ensuring that data is accessible, trusted, and well‑structured.

This role is hands‑on and ideal for someone with a strong technical foundation who enjoys solving data problems, writing clean and efficient SQL, and collaborating with analysts, business stakeholders and product teams. This role sits within the Data & Insight team, reporting to the Director of Data Engineering. We’re looking for someone who’s detail‑oriented, solution‑driven, and pragmatic – someone who takes ownership of their work and is excited to build robust, maintainable data models while being responsive to our users’ needs.

What you’ll work on

• Data Modelling & Transformation
  • Build and maintain dbt models to transform raw data into clean, documented, and accessible data sets.
  • Translate business and analytics requirements into scalable data models.
  • Design and implement data warehouse schemas using dimensional modelling techniques (fact and dimension tables, slowly changing dimensions, etc.).
  • Participate in design and code reviews to improve model design and query performance.
  • Expose these models and associated metrics via our Semantic Layer.
• Testing, Documentation, and CI/CD
  • Implement and maintain dbt tests to ensure data quality and model accuracy.
  • Document data models clearly to support cross‑functional use.
  • Use GitHub and CI/CD pipelines to manage code and deploy changes safely and efficiently.
• Performance & Architecture
  • Optimise dbt models and SQL queries for performance and maintainability.
  • Work with Snowflake; developing on top of a data lake architecture.
  • Ensure dbt models are well‑integrated with data catalogs and accessible for downstream use.

What we’re looking for

• Required Skills & Experience
  • 2+ years of building and optimising complex SQL (including complex joins, window functions and optimisation methods).
  • Strong understanding of data modelling and warehouse design (e.g., Kimball‑style dimensional modelling).
  • Experience using dbt in production environments, including testing and documentation.
  • Familiar with version control (GitHub).
  • Experience tuning dbt models and SQL queries for performance.
  • Able to independently transform business logic into technical implementation.
  • Comfortable participating in and contributing to code reviews.
• Desirable - but not required
  • Experience with Snowflake.
  • Experience with Semantic Layers (e.g., Looker, Cube etc.).
  • Experience with CI/CD for data workflows.
  • Familiarity with Python/Airflow for data transformation or orchestration tasks.
  • Experience with data visualisation tools (e.g., Tableau, Looker).
  • Working knowledge of infrastructure‑as‑code tools like Terraform.

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.
• Health & Wellness – private medical insurance with Bupa, a medical cashback scheme, life insurance, gym membership & wellness resources through Wellhub and access to Spill – all in one mental health support.
• Hybrid work offering – for most roles we collaborate in the office three days per week with the exception of Coaches and Instructors who collaborate in the office once a month.
• Work‑from‑anywhere scheme – you'll have the opportunity to work from anywhere, up to 10 days per year.
• Space to connect – beyond the desk, we make time for weekly catch‑ups, seasonal celebrations, and have a kitchen that’s always stocked!

Our Commitment to Diversity, Equity and Inclusion

We’re an equal‑opportunities employer. And proud of it. Every applicant and employee is afforded the same opportunities regardless of race, colour, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender, gender identity or expression, or veteran status. This will never change.