BI Engineer

Motorpoint Ltd; East Midlands; Hybrid; GBP 40,000 - 55,000; Full time

Job summary

A leading omnichannel car retailer in the UK is seeking an experienced BI Engineer to join their data team in a hybrid role. The successful candidate will design and maintain ETL data pipelines, create PowerBI models, and support business stakeholders. Essential skills include PowerBI, SQL, and Python, with a minimum of 2 years experience required. This opportunity offers a comprehensive benefits package including paid time off and professional development training.

Benefits

Paid time off every month

31 days holiday plus extra days

Staff discount on cars

Healthcare

Employee Assistance Programme

Qualifications

• Minimum 2 years relevant experience in BI, data engineering, or analytics.
• Understanding of data architecture principles and data warehouse concepts.
• Track record of delivering end-to-end data solutions.

Responsibilities

• Design, build, and maintain ETL/ELT data pipelines using Python and SQL.
• Create and maintain PowerBI data models with focus on performance optimization.
• Gather and translate business requirements into technical solutions.

Skills

PowerBI

Snowflake

SQL

Python

ETL/ELT

Job description

Who are we?

We are Motorpoint, the UK’s leading omnichannel car retailor of nearly new cars. We focus on providing our customers with unrivaled choice, quality, service and value in whatever way our customers want. Online? We deliver. In store? We deliver. At home? We deliver (we literally do).

You will be joining Motorpoint during a very exciting time, as we are undergoing a massive digital transformation and are continuing to expand across the UK. This means you will have the opportunity to positively impact, build and influence the growth of the company.

We believe that by creating a fantastic place to work for our colleagues, we will create the best possible experience for our customers and that will fuel the growth of our amazing business and the careers and opportunities for our colleagues.

So if you want to work with an amazing group of people, who are fun, friendly and get stuff done and who bring our values to life – PROUD, HAPPY, HONEST, SUPPORTIVE – by working TOGETHER, then Motorpoint is the place to be and we are on a mission!

The Role

Title: BI Engineer

Location: Derby - Hybrid (twice a week in the office)

Position Summary

This role requires an experienced BI Engineer to support our data team in a hybrid capacity, combining business intelligence development with data engineering responsibilities. The successful candidate will be responsible for maintaining and developing our PowerBI reporting infrastructure whilst building and optimizing data pipelines within our analytics platform.

Key Accountabilities

Data Engineering

• Design, build, and maintain ETL/ELT data pipelines using Python and SQL
• Develop and optimize data workflows within Snowflake environment
• Monitor data quality, reliability, and performance across pipeline processes
• Troubleshoot data issues and implement solutions
• Establish data integration processes with source system owners

Business Intelligence

• Create and maintain PowerBI data models with focus on performance optimization
• Develop interactive dashboards and reports for business stakeholders
• Support and enhance existing PowerBI reports based on user requirements
• Connect PowerBI to various data sources ensuring secure data access
• Document all BI assets and processes

Stakeholder Management

• Gather and translate business requirements into technical solutions
• Collaborate with business users and provide training on self‑service capabilities
• Work with data engineering team on cross‑functional projects
• Support ad‑hoc analytical requests

Essential Requirements

Technical Skills

• PowerBI: Data modeling, DAX, Power Query, report development
• Snowflake: Data warehouse experience including SQL optimization
• SQL: Advanced skills in complex queries, stored procedures, performance tuning
• Python: Data manipulation, automation, pipeline development
• ETL/ELT: Experience building and maintaining data integration processes

Experience & Knowledge

• Minimum 2 years relevant experience BI, data engineering, or analytics
• Understanding of data architecture principles and data warehouse concepts
• Track record of delivering end‑to‑end data solutions
• Experience working with business stakeholders to gather requirements
• Proven ability to work independently on complex data problems

Soft Skills

• Strong problem‑solving abilities with attention to detail
• Ability to translate technical concepts for business audiences
• Collaborative working style suitable for agile environments

Desirable Requirements

• Experience with cloud platforms (Azure, AWS) and data services
• Knowledge of data visualization best practices
• Familiarity with version control systems (Git) and CI/CD

What is in it for you?

• Paid time off every month to do something that makes you happy
• 31 days holiday plus days off for your birthday, getting married or moving house
• Additional holidays for length of service
• Long service awards
• Staff discount on cars and finance options
• Discounts & cash back at hundreds of high street retailers & restaurants through our “My M.O.T” platform
• Smart Tech in partnership with Currys
• Cycle to work
• Pension
• Healthcare
• Enhanced Parental Leave
• Employee Assistance Programme (EAP)
• Vocational and personal development training courses
• Quarterly team socials
• Team feasts
• Scratch card rewards
• Sharesave scheme (SAYE)
  • Plus much more!

Closing Date

25th November 2025

Please note, this role may close before the closing date if the advert receives a high volume of suitable applications, so it is best to apply as soon as possible.

We encourage applications from people of all backgrounds and would ask you to get in touch if you are concerned about any barriers you feel you may be facing in your application process with us, so we can ensure they are removed.