Motorway • London, United Kingdom

Analytics Engineer

Employment type:  Full time

3–4 days/week at home

A little flex time

Dog friendly

Apply now

Job Description

Motorway is the UK’s fastest-growing used car marketplace – our award-winning, online-only platform connects private car sellers with thousands of verified dealers nationwide, ensuring everyone gets the best deal. Founded in 2017, our technology-led approach has redefined the experience of selling a car, generating thousands of monthly car sales and helping us to grow to a team of more than 400 people across our London and Brighton offices.

About the role

Success in our data team is about enabling better decisions, faster. At the core of this mission sits our data platform which enables powerful, real-time analytics that empower the wider business.

Are you looking to have a big impact in your net role? We're growing fast and we want to ensure we have a rock solid Data Warehouse to support decision-making, business intelligence and best in class data products. You'll be key on this!

As our Analytics Engineer you'll join our ambitious multidisciplinary team. Working mostly with dbt you will support the building of robust data models that support internal reporting and machine learning – all our data lives in one place and is made available via our data warehouse in Google BigQuery.

You’ll be working with a team of 5+ Analysts and Data Scientists in an agile environment, part of a wider community of practitioners in product development, strategy, finance, marketing and sales.

We work with cutting-edge data infrastructure such as Stitch, Meroxa, dbt, Google BigQuery, Google AI platform, Data Studio, and more. You’ll also have plenty of development and training opportunities in a truly forward-thinking company. The role is fast-moving and varied, so the ideal candidate will have a love for problem-solving, data and idea creation.

What you'll do

  • Support decision-making: provide clean, transformed data to end users in a way that empowers them to answer their own questions.
  • Data quality: set standards on data robustness and freshness, and investigate and effectively work with colleagues from other disciplines to monitor and improve data quality across the organisation.
  • Data modelling: define and refine best practices around modelling data.
  • Metadata management: data assets documentation, discoverability, metadata integration.
  • Coding standards: champion and implement software development best practices to ensure our code is high quality, well-tested, scalable and secure.
  • Abstractions: create and manage reusable components in the form of jinja macros libraries and computation frameworks
  • Data integrations: take responsibility for managing data integration tools (Meroxa and Stitch).
  • Data operations: SLAs, data warehouse cost management, data quality monitoring, anomaly detection, and garbage collecting unused resources
  • Stay on the cutting edge: we regularly do hack days! We believe in a culture of innovation in our day-to-day life. We experiment with new techniques, tools, and frameworks to keep Motorway at the leading edge of technology.


Don't worry if you feel you don't meet all the requirements. We still want to hear from you! Don't be shy and apply if you feel you could be a great fit for the role!

  • You have experience and a passion for Data Modelling, ETL projects and Big Data as a developer or analyst
  • SQL and data modelling are second nature to you.
  • You are comfortable with general Data Warehousing concepts.
  • You strive for improvement in your work and that of others, proactively identifying issues and opportunities.
  • You have experience building robust and reliable data sets requiring a high level of control.
  • Designing and building data models.
  • Data Visualisation experience.
  • Exposure to Python or similar languages.
  • Have previously used dbt, dataform or similar tooling.


  • A competitive salary
  • Annual learning budget - you can choose how you like to learn and find the best learning experiences to support your progression.
  • BUPA health insurance
  • Discounted dental through BUPA
  • Discounted gym membership through BUPA
  • On-Hand volunteering membership and one paid volunteering day per year
  • Hybrid working from home (approximately 1-2 days in the office a week)
  • Pension scheme
  • Motorway car leasing scheme - lease a zero-emissions electric vehicle at a significant discount
  • Enhanced parental leave
  • Top spec M1 MacBook Pro and accessories
  • Regular social events
  • Cycle to work scheme

Equal opportunities statement

We are committed to equality of opportunity for all employees. We work to provide a supportive and inclusive environment where people can maximise their full potential. We believe our workforce should reflect a variety of backgrounds, talents, perspectives and experiences. Our strong commitment to a culture of inclusion is evident through our constant focus on recruiting, developing and advancing individuals based on their skills and talents.

We welcome applications from all individuals regardless of age, disability, sex, gender reassignment, sexual orientation, pregnancy and maternity, race, religion or belief and marriage and civil partnerships.


Company benefits

Enhanced sick pay
Enhanced sick days
Health insurance
Mental health platform access
Compassionate leave
Dog friendly office
23 days annual leave + bank holidays
Buy or sell annual leave
Enhanced maternity leave
Enhanced paternity leave
Adoption leave
Shared parental leave
Cycle to work scheme
Faith rooms
Fully stocked snack cupboard
Meditation space
Annual pay rises
Share options
Teambuilding days
Volunteer days
Personal development budgets
L&D budget
Lunch and learns
Company wide holidays/offsites
Open to job sharing
Optional unpaid leave
Pregnancy loss leave
In office massages
In office yoga classes
Open to part-time employees

We asked employees of Motorway how satisfied they were with flexible working, and this is what they told us

Employees are very happy with their working location freedom
Employees are very happy with the flexibility in the hours they work
Employees are moderately happy with the benefits their company offers
Work-life balance
Employees feel that they can switch off quite easily from work
Role modelling
Employees feel that most people work flexibly
Employees feel they have complete autonomy over getting their work done
Working at Motorway

Company employees


Office locations

London & Brighton

Hiring Countries

United Kingdom