At a Glance
- Tasks: Transform raw data into impactful insights and build scalable data models.
- Company: Leading online car-changing destination in Europe with a dynamic culture.
- Benefits: Hybrid working, competitive salary, share options, and private healthcare.
- Other info: Mentorship opportunities and a focus on professional development.
- Why this job: Join a fast-growing company and make a real impact on data-driven decisions.
- Qualifications: Expert SQL skills and experience with cloud data platforms required.
The predicted salary is between 60000 - 75000 € per year.
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!
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 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 BigQuery
- Mentor junior analysts and promote best practices in analytics engineering across the wider analytics team
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
- 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
SUCCESS IN THIS ROLE LOOKS LIKE
- Clean, 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 OWN
- The 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 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!
- Vitality 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
Senior BI Analytics Engineer in London employer: Carwow Group
As a Senior BI Analytics Engineer at our rapidly growing company, you'll be part of a dynamic team that is revolutionising the automotive industry through innovative technology and data-driven insights. We offer a vibrant work culture that promotes collaboration and personal growth, alongside competitive benefits such as hybrid working, matched pension contributions, and share options, ensuring that your contributions are recognised and rewarded. Join us in a location that fosters creativity and ambition, where you can make a meaningful impact while enjoying a fulfilling career.
StudySmarter Expert Advice🤫
We think this is how you could land Senior BI Analytics Engineer in London
✨Tip Number 1
Network like a pro! Reach out to folks in the industry, attend meetups, and connect on LinkedIn. You never know who might have the inside scoop on job openings or can put in a good word for you.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your best work, especially any dashboards or data models you've built. This gives potential employers a taste of what you can do and sets you apart from the crowd.
✨Tip Number 3
Prepare for interviews by brushing up on your SQL and data modelling concepts. Be ready to discuss how you've tackled challenges in previous roles and how you can bring value to their team.
✨Tip Number 4
Don't forget to apply through our website! It’s the best way to ensure your application gets seen. Plus, we love seeing candidates who are genuinely interested in joining our mission.
We think you need these skills to ace Senior BI Analytics Engineer in London
Some tips for your application 🫡
Tailor Your CV:Make sure your CV is tailored to the Senior BI Analytics Engineer role. Highlight your experience with SQL, dbt, and Looker, and don’t forget to showcase any relevant projects that demonstrate your data modelling skills.
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to explain why you’re passionate about analytics engineering and how your skills align with our mission. Be sure to mention any experience you have with cloud platforms like BigQuery.
Showcase Your Communication Skills:Since this role involves working with non-technical stakeholders, make sure to highlight your strong communication skills in your application. Share examples of how you've successfully collaborated with different teams in the past.
Apply Through Our Website:We encourage you to apply through our website for the best chance of getting noticed. It’s the easiest way for us to keep track of your application and ensure it reaches the right people!
How to prepare for a job interview at Carwow Group
✨Know Your Data Modelling Inside Out
Make sure you brush up on your data modelling concepts, especially star schema and dimensional modelling. Be ready to discuss how you've applied these in previous roles, as this will show your technical expertise and understanding of the role's requirements.
✨Showcase Your SQL Skills
Prepare to demonstrate your SQL prowess during the interview. You might be asked to solve a problem or optimise a query on the spot, so practice performance tuning and be ready to explain your thought process clearly.
✨Familiarise Yourself with Looker and dbt
Since you'll be working with Looker and dbt, make sure you can talk about your experience with these tools. Bring examples of dashboards you've built or data models you've created, and be prepared to discuss how they impacted decision-making in your previous roles.
✨Communicate Effectively with Non-Technical Stakeholders
This role requires strong communication skills, so think of examples where you've successfully translated complex data insights into actionable business strategies for non-technical stakeholders. This will highlight your ability to bridge the gap between data and business needs.
