Carwow logo

Senior BI Analytics Engineer

Carwow·Salary not specified

Primary stack

SQLdbtBigQueryLooker

Nice to have's

AirflowAI

Job description

About the Position

Senior BI Analytics Engineer


Location

London, United Kingdom

Employment Type

Full time

Location Type

Hybrid


About the Company

OUR MISSION

To 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 service.

In 2024 we went big and acquired Autovia - creators of AutoExpress and Evo magazines - doubling our audience overnight. Together we now have one of the biggest YouTube 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 350 million.

And we’re a long way from done!


Responsibilities

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 (BigQuery)
  • Create and maintain dashboards and explores in Looker, enabling self-serve analytics
  • Translate business requirements into clear data models, metrics, and visualizations
  • 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
  • Optimize query performance and manage cost efficiency in BigQuery
  • Mentor junior analysts and promote best practices in analytics engineering across the wider analytics team

Requirements

WHAT 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. BigQuery, 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 Have

NICE TO HAVE

  • Hands-on experience with Google Cloud Platform, especially BigQuery
  • 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

We Offer

WHAT’S IN IT FOR YOU

  • Hybrid 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!
  • Bupa Private Healthcare, for peace of mind, plus eyecare vouchers
  • Life Assurance for (even more) peace of mind
  • Monthly coaching sessions with Spill - our mental wellbeing partner
  • Enhanced holiday package, plus Bank Holidays
    • 28 days annual leave
    • 1 day for your wedding
    • 1 day off when you move house - because moving is hard enough without work!
    • For your third year anniversary, get 30 days of annual leave per year
    • For your tenth year anniversary, get 35 days of annual leave per year
    • Option to buy 3 extra days of holiday per year
  • Work from abroad for a month
  • Inclusive parental, partner, and shared parental leave, fertility treatment, and pregnancy loss policies
  • Bubble childcare support and discounted nanny fees for little ones
  • The latest tech (Macbook or Surface) to power your gif-sending talents
  • Up to £500/€550 home office allowance for that massage chair you’ve been talking about
  • Generous learning and development budget to help you master your craft
  • Regular social events: tech lunches, coffee with the exec sessions, lunch 8 learns, book clubs, social events/anything else you pester us for
  • Refer a friend, get paid. Repeat for infinite money

Diversity and inclusion is an integral part of our culture. We know that diverse teams are strong teams, so we welcome those with alternative identities, backgrounds, and experiences to apply for this position. We make recruiting decisions based on experience, skills, and potential, so all our applicants are treated fairly and equally.

© Carwow. This job description was sourced from the employer's public career page. TheJob is not the employer — we index the posting and route candidates to the source. All content rights and hiring decisions belong to the employer.

Carwow logo
Carwow

Automotive; Marketplace / Automotive

More at Carwow

All 37 roles

Popular searches