Carwow
Senior BI Analytics Engineer
London, Remote. Posted 9 days ago
The role
You will bridge the gap between data engineering and business insight by transforming raw data into trusted, well modelled datasets. You will design and maintain scalable data models using dbt on Google Cloud Platform and deliver reporting through Looker.
What you will do
- Design, build, and maintain scalable data models using dbt on Google Cloud Platform (BigQuery)
- Create and maintain dashboards and explores in Looker
- Translate business requirements into clear data models, metrics, and visualisations
- Define and maintain core business metrics and data definitions
- Implement data quality checks, testing, and documentation within dbt
- Partner with stakeholders across commercial, product, marketing, finance, and operations
- Optimise query performance and manage cost efficiency in BigQuery
- Mentor junior analysts and promote best practices in analytics engineering
Required qualifications
- Previous experience in analytics engineering, BI or data analytics roles
- Strong SQL skills
- Experience working with modern cloud data platforms and distributed data warehouses
- Proven experience with dbt (modelling, testing, documentation)
- Experience building dashboards in Looker
- Solid understanding of data modelling concepts (star schema, dimensional modelling)
- Experience working with large-scale datasets
- Strong communication skills
Nice to have
- Performance tuning experience preferred
- LookML is a strong plus
- 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
Benefits
- Hybrid working
- Competitive salary
- Matched pension contributions
- Share options
- Bupa Private Healthcare
- eyecare vouchers
- Life Assurance
- Monthly coaching sessions with Spill
- Enhanced holiday package, plus Bank Holidays
- 28 days annual leave
- 1 day for your wedding
- 1 day off when you move house
About the company
carwow is an online car-changing destination that combines technology, media and automotive expertise. It includes Autovia, creators of AutoExpress and Evo magazines.