Senior BI Analytics Engineer

OUR MISSIONTo become the car-changing destination of choice. By combining technology, media and deep automotive expertise, we've turned how people buy, sell, advertise and lease cars on its head.

What started as a simple reviews site is now one of the largest online car-changing destinations in Europe. Last year alone we grew over 50% with nearly 3bn worth of cars bought on site, while 1.8bn of cars were listed for sale through our Sell My Car  2024 we went big and acquired Autovia - creators of Auto Express and Evo magazines - doubling our audience overnight.

Together we now have one of the biggest You Tube channels in the world with almost 10m subscribers and over 1.1 billion annual views, while we sell 1.2 million print copies of our magazines and have an annual web content reach over 350million.

And we’re a long way from done!

THE ROLE We’re looking for a Senior Analytics Engineer / BI Analyst to bridge the gap between data engineering and business insight. You’ll take ownership of transforming raw data into trusted, well modelled datasets and deliver impactful reporting that drives decision making across the business. This role combines strong technical data modelling skills with stakeholder-facing analytics and BI development.

WHAT YOU'LL BE DOING Design, build, and maintain scalable data models using dbt on Google Cloud Platform (Big Query)
Create and maintain dashboards and explores in Looker, enabling self-serve analytics

Translate business requirements into clear data models, metrics, and visualisations

Define and maintain core business metrics and data definitions in partnership with stakeholders and the wider analytics team Implement data quality checks, testing, and documentation within dbt Partner with stakeholders across all parts of the business including commercial, product, marketing, finance, and operations

Optimise query performance and manage cost efficiency in Big Query Mentor  junior analysts and promote best practices in analytics engineering across the wider analytics teamWHAT YOU'LL NEED Previous experience in analytics engineering, BI or data analytics roles

Strong SQL skills (expert level, performance tuning experience preferred)
Experience working with modern cloud data platforms and distributed data warehouses (e.g. Big Query, Snowflake)
Proven experience with dbt (modelling, testing, documentation)
Experience building dashboards in Looker (LookML is a strong plus)
Solid understanding of data modelling concepts (star schema, dimensional modelling)
Experience working with large-scale datasets

Strong communication skills with the ability to work with non-technical stakeholders NICE TO HAVEHands-on experience with Google Cloud Platform, especially Big Query Experience  with orchestration tools (e.g. Airflow)
Knowledge of data governance and data quality frameworks

Exposure to reverse ETL tools (e.g. Hightouch)
Familiarity with AI coding assistants and a habit of integrating them into day-to-day analytics workflows SUCCESS IN THIS ROLE LOOKS LIKEClean, well-documented, and trusted data models used across the company

High adoption of Looker dashboards and self-serve analytics

Reduced time-to-insight for stakeholders with the use of AI tooling to accelerate delivery

Clear, consistent definitions of key business metrics

Improved data reliability and fewer reporting discrepancies WHAT YOU'LL OWNThe transformation layer (dbt) and semantic layer (Looker)
Core business metrics and reporting definitions

Data quality and testing frameworks BI best practices and documentation standards WHAT’S IN IT FOR YOUHybrid working Competitive salary to fund that dream holiday to Bali Matched pension contributions for a peaceful retirement

Share options - when we thrive, so do you!

Vitality Private…