Analytics Engineer

About Motorway

Motorway is the UK’s fastest-growing used car marketplace – our award winning, online-only platform connects private car sellers with over 7,500 verified dealers nationwide, who compete to offer the best price. Founded in 2017, our technology makes the process refreshingly easy, earning us an 'Excellent' Trustpilot rating with over 70,000 reviews. We're not just building a platform; we're changing how people sell cars.

Backed by leading investors like Index Ventures and ICONIQ Growth, and following a successful $190 million funding round, we're on a mission to transform the used car market.

About the team

👋 Hi, I'm Will, Director of Data at Motorway. I'm looking for a Data Analytics Engineer to join our ambitious, multi-disciplinary team. You'll be working mostly with dbt to build 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.

We're a team of 5+ Analysts and Data Scientists working in an agile environment. We're 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 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.

About the role

As a Data Analytics Engineer, you will:

• 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.

About you

• 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.

You could be a great fit if

• You're passionate about data and its potential to drive business decisions.

• You're a creative thinker who can come up with new ways to use data to solve problems.

• You're a team player who is willing to share your knowledge and expertise with others.

• You're excited about working in a fast-paced, ever-changing environment.

Our interview process

• Qualifying Screen - 30 minutes

• Hiring Manager Interview - 60 minutes

• Skills Assessment - 60 minutes

• Final Interview (onsite depending on team) - 60 minutes

You can expect to hear back from us within a week of each interview stage. You'll have the opportunity to speak with a talent partner throughout the interview process should you have any questions or need any type of accommodations.