BI Engineer
Who are we?
We are Motorpoint, the UK’s leading omnichannel car retailer of nearly new cars. At Motorpoint, we all share the same vision:
To be the Car Buyer's Champion, trusted to deliver unrivalled Choice, Value and Quality.
We believe that by creating a fantastic place to work for our colleagues, we will deliver the best possible experience for our customers. 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: BI Engineer
Salary: £55,000 to £60,000 per annum.
Location: Hybrid – 3 days working remotely and 2 days at our Derby office (Shelton House, Unit 7, Prime Enterprise Park, Prime Park Way, Derby, DE1 3QB).
Contract Type: Permanent
Hours: 37.5 hours per week, Monday to Friday.
Reporting to: Head of Data & Business Intelligence
-----
The Data & Analytics team owns the reporting, data platform and internal tooling used across the business, from daily trading performance to the movement of vehicles through our preparation centres.
We’re looking for a BI Engineer to own and develop our reporting estate. You’ll build and maintain Power BI reporting, support Snowflake-based analytics, and deliver the data pipelines that underpin decision-making across the business.
Alongside the core BI work, you’ll bring an engineering mindset and a genuine interest in AI-driven development. We use agentic tooling to accelerate delivery, automate repeatable work and improve how we operate, and you’ll help identify and build opportunities where it can make a real difference.
You don’t need commercial experience with agentic AI. Experience gained through personal projects, side projects or self-directed learning is absolutely welcome. What’s most important is strong BI engineering fundamentals, paired with the curiosity to experiment with emerging technology and put it to practical use.
What will you be getting up to?
Develop and maintain Power BI reports, dashboards and semantic models used across the store network and support centre.
Support and enhance the existing reporting estate: implement change requests, resolve faults, investigate data quality issues and help retire assets no longer in use.
Build and optimise the ETL/ELT pipelines that feed the Snowflake analytics platform, with SQL and Python.
Partner with stakeholders across the business to gather requirements and turn them into clear, reliable reporting outputs.
Contribute to data modelling and data architecture initiatives, including the design of semantic layers and canonical definitions.
Identify and build opportunities to use AI and agentic tooling to automate recurring work, speed up delivery and improve how the team operates.
Apply rigorous quality assurance to all output, including agent-generated work, so that errors are caught before they reach a business user.
Maintain accurate documentation of reports, models and data assets, for colleagues and for the agents that rely on it.
Keep up to date with developments in BI, data engineering and AI tooling, and bring practical suggestions to the team.
What do we need from you?
We expect this role to suit someone with around 3 to 6 years’ experience as a BI Engineer, Senior BI Developer, Analytics Engineer or Data & BI Developer.
Essential:
Strong Power BI skills: report and dashboard development, semantic modelling, DAX and performance tuning.
Strong SQL, including the ability to read, debug and validate complex queries written by someone else.
Experience building and maintaining ETL/ELT pipelines into a cloud data warehouse; Snowflake preferred, but experience on a comparable platform (BigQuery, Redshift, Synapse, Databricks) is fine.
Python for data work: transformation, orchestration or automation.
Solid understanding of dimensional modelling and data architecture principles.
Demonstrable curiosity about AI, automation and emerging technology, with hands-on use of LLMs or agentic tooling through work, side projects or self-learning. You should be able to talk about where the tooling helped, where it produced incorrect work and how you caught it.
A careful, accurate approach and appropriate scepticism towards plausible-looking output.
Clear written communication: briefing an agent well is a writing task, as is explaining to a colleague why a figure has changed.
Comfortable working directly with stakeholders to shape requirements.
Desirable:
Experience building reusable prompts, custom instructions or agent workflows (for example Claude Code, Copilot, Cursor or MCP-based tooling).
Version control (Git) and CI/CD for data and BI assets.
dbt or a similar transformation framework.
Experience retiring or rationalising a legacy reporting estate, including SSRS.
Retail, automotive or other high-volume transactional data.
No specific degree or qualification is required. We care about what you can demonstrate, not the titles you have held.
What is in it for you?
At Motorpoint, our team members are at the heart of everything we do. That's why we invest in benefits that support your wellbeing, recognise your contribution, help you grow and give you more time for the things that matter most.
Time Off
One Big Dream: paid time off every month to do something that drives your dreams.
31 days’ holiday, plus an extra day off for your birthday, getting married or moving house.
Extra holiday for long service, because loyalty deserves to be recognised.
Holiday Purchase Scheme, giving you the option to buy more annual leave.
Financial Benefits
Pension Scheme to help you plan for the future.
Stream, with tools and support to help you manage your money.
My M.O.T, offering discounts and cashback at hundreds of shops, restaurants and attractions.
Smart Tech with Currys, helping you spread the cost of the latest technology, interest free.
Sharesave Scheme (SAYE), helping you save for the future and share in Motorpoint’s success.
Cars and Travel
Employee Car Ownership Scheme (ECOS), giving every team member the opportunity to drive a Motorpoint vehicle.
Team member discounts on cars and finance options.
Free MOT, with one free Motorpoint MOT for your vehicle every year.
Cycle to Work Scheme, helping you save on the cost of a bike.
Health and Wellbeing
Sovereign Healthcare cash plan, helping you claim money back on everyday healthcare costs such as dental and optical.
Life Assurance, with the option to nominate a beneficiary.
Employee Assistance Programme (EAP),giving you access to 24/7 GP support, free counselling sessions and confidential advice whenever you need a helping hand.
Enhanced Parental Leave, giving you extra support during important family moments.
Learning and Development
Learning and Development Opportunities, including role-specific training and leadership development.
Personal and Professional Development Opportunities, programmes designed to help team members build skills, confidence and experience.
Recognition and Team Life
Long Service Awards to thank team members for their commitment.
Instant Recognition Rewards when you go the extra mile.
Quarterly Team Socials to get together and have some fun.
Monthly Foodie Fridays, because we love sharing good food at Motorpoint.
Closing Date: 30th November 2026
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 welcome applications from people of all backgrounds. If you have any concerns about potential barriers in the application process, please get in touch so we can ensure they are removed.
#IND2

- Department
- Data
- Location
- Derby (Shelton House)
- Remote status
- Hybrid
Our teams
Making car buying easy takes all kinds of people. Yes, our Online and Showroom Sales teams kick off the process, but who’s keeping the engine running behind the scenes? For starters, there’s our Vehicle Preparation and Workshop teams, getting cars ready for sale. Then, there are Buyers, hunting out the best vehicles around. Software and Product teams create an amazing digital experience while Aftersales help customers post-purchase. Finally, there’s Head Office and Business Support keeping everything running smoothly.
About Motorpoint
Car buying made easy
At Motorpoint, buying a car is simple. We only do nearly new cars and nobody beats us on price. That’s a promise.
We only sell nearly new, and our cars are all under warranty – so peace of mind comes as standard. And with a range of makes and models to choose from, you’re sure to find one within your budget.
Whatever you need, we’re here to help. With finance options that put you in the driving seat and award-winning customer care before and after you buy, we’ll make sure you drive away happy.
So, what are you waiting for? Take a look at our cars or find out more about us below.