BI Data Analyst

Motorway; London (KY); Hybrid; USD 88,000 - 115,000; Full time

Benefits offered by this job

Equity scheme

25 days holiday

Flexible working

Private medical insurance

Pension scheme

Enhanced family leave

EAP

EV leasing scheme

Cycle to work

Nursery salary sacrifice

Volunteer day

Job summary

Motorway is seeking a BI Data Analyst to own analytical projects end-to-end, collaborating with Marketing, Finance, Product, Commercial and Operations. You will build dashboards, surface trends, and use data storytelling to drive measurable outcomes while leveraging AI tools to accelerate delivery.

You will write production SQL and Python, ensure data accuracy, and work with Analytics Engineers to ingest new data sources, enabling self-serve insights across teams.

Qualifications

• Take business problems and independently structure them into well-defined analytical tasks.
• Own KPI monitoring and reporting for embedded stakeholder teams.
• Root cause and explain data discrepancies, finding solutions to stakeholder problems.
• Build Looker dashboards and Hex notebooks to support deep-dive analysis and stakeholder self-serve.
• Write production-quality SQL and Python, following team coding standards and passing peer review.
• Communicate insights and recommendations clearly — constructing narratives that drive action.
• Use AI tools to improve workflow (e.g. query generation, analysis drafts, documentation).
• Work with Analytics Engineers to ingest new data sources into the stack as needed.

Responsibilities

• Take business problems and independently structure them into well-defined analytical tasks.
• Own KPI monitoring and reporting for embedded stakeholder teams, ensuring data accuracy to build quality and confidence in outputs.
• Root cause and explain data discrepancies, finding solutions to stakeholder problems.
• Build Looker dashboards and Hex notebooks to support deep-dive analysis and stakeholder self-serve.
• Write production-quality SQL and Python, following team coding standards and passing peer review. Additionally assist others to review AI generated outputs.
• Communicate insights and recommendations clearly — constructing narratives that drive action.
• Use AI tools to improve workflow (e.g. query generation, analysis drafts, documentation) while maintaining quality and accuracy.
• Work with Analytics Engineers to ingest new data sources into the stack as needed.

Skills

SQL

Python

Data storytelling

Stakeholder management

Problem structuring

Analytical thinking

AI tooling

Tools

Looker

Hex notebooks

Job description

About Motorway

Motorway is the UK's largest online car-selling platform. We connect private sellers directly with over 8,000 dealers nationwide. Our online platform helps sellers achieve great prices for their cars while giving dealers fast, reliable access to the stock they want for their dealerships. Founded in 2017, our award-winning, technology-led approach has redefined the experience of selling a car. Motorway is backed by some of the world’s leading technology investors, having raised £143 million in Series C funding.

This is a unique opportunity to join a fast-growing scale-up at a crucial phase of growth and help change an industry for the better.

About the role

We are looking for a BI Data Analyst to join our Analytics team. You will take ownership of analytical projects end-to-end — from scoping business problems through to insight delivery — working closely with stakeholders across Marketing, Finance, Product, Commercial and Operations. You will build and maintain critical dashboards and reporting, surface trends and anomalies in business performance, and use data storytelling to drive measurable business outcomes. You will be expected to leverage AI tools strategically throughout your workflow — from LLM-assisted query generation and analysis summarisation to code review — accelerating delivery while maintaining rigorous standards. You will also provide critical support as the human-in-the-loop to ensure accuracy and repeatability of data analysis in other functions, empowering all our teams to make full use of AI-driven data self-serve

What will you do

• Take business problems and independently structure them into well-defined analytical tasks

• Own KPI monitoring and reporting for embedded stakeholder teams, ensuring data accuracy to build quality and confidence in your outputs

• Root cause and explain in detail data discrepancies, finding solutions to stakeholder problems

• Build Looker dashboards and Hex notebooks to support deep-dive analysis and stakeholder self-serve

• Write production-quality SQL and Python, following team coding standards and passing peer review. Additionally assist others to review AI generated outputs.

• Communicate insights and recommendations clearly — constructing narratives that drive action

• Use AI tools to improve workflow (e.g. query generation, analysis drafts, documentation) while maintaining quality and accuracy

• Work with Analytics Engineers to ingest new data sources into the stack as needed

BENEFITS

We've got your back, in life's biggest moments and the everyday ones too.

• Competitive salary

• Equity scheme - we all share in Motorway's success

• 25 days holiday

• Flexible working (2 days a week in our London office, with socials and snacks galore)

• Private medical insurance via BUPA

• Life assurance

• Pension scheme (we contribute 5%)

• Enhanced family leave (e.g. 26 weeks full pay for maternity or adoption)

• 24/7 Employee Assistance Programme

• EV leasing scheme

• Cycle to work scheme

• Nursery salary sacrifice scheme

• 1 paid volunteering day a year

Applications close Monday 24th August.