At a Glance
- Tasks: Develop and maintain Power BI reports while optimising data pipelines for impactful decision-making.
- Company: Join Motorpoint, the UK's leading omnichannel car retailer with a fun and supportive culture.
- Benefits: Enjoy 31 days holiday, flexible working, and a range of financial perks including a pension scheme.
- Other info: Great opportunities for learning and development, plus regular team socials and recognition rewards.
- Why this job: Be part of a mission-driven team that values innovation and personal growth in a dynamic environment.
- Qualifications: Strong Power BI and SQL skills, plus a curiosity for AI and emerging technologies.
The predicted salary is between 55000 - 60000 £ per year.
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!
- BI Engineer
- Salary
- 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).
Applicants must have the right to work in the UK as we are unable to offer visa sponsorship.
- 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 (Big Query, 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 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.
BI Engineer employer: Motorpoint
Motorpoint in Swansea is an excellent employer, offering a dynamic work environment where teamwork and individual initiative are highly valued. Employees benefit from a supportive culture that prioritises professional growth, alongside competitive remuneration and flexible working arrangements, making it an ideal place for those seeking a rewarding career in the automotive industry.
StudySmarter Expert Advice🤫
We think this is how you could land BI Engineer
✨Get Involved in Data Science Meetups
Tap into local data science meetups or workshops to connect with fellow enthusiasts and professionals. These events are goldmines for networking, and sometimes even lead directly to job openings at companies like Motorpoint!
✨Show Off Your Projects
Start building a public portfolio showcasing your data science projects on platforms like GitHub or personal websites. Highlight unique analyses or models you've developed. This not only demonstrates your skills but also gets your name out there for roles like BI Engineer at Motorpoint.
✨Leverage Professional Networks
Join professional bodies related to data science, like the Data Science Society or similar organisations. Getting involved can lead to mentorship opportunities and insider knowledge about full-time positions at companies like Motorpoint.
✨Apply Directly through Our Website
When you find a suitable opening like BI Engineer at Motorpoint, make sure to apply directly through our website. It gives you an edge and shows you're keen to join our team. Plus, who doesn’t love a direct application? It’s easier than navigating through job boards!
We think you need these skills to ace BI Engineer
Some tips for your application 🫡
Show Off Your Projects:In the world of data science, your projects can speak volumes about your skills. Make sure to showcase a few key projects in your CV or portfolio, especially those that highlight your ability to work with data sets, build models, or use relevant tools like Python, R, or SQL. Don’t forget to include links to any GitHub repositories if applicable!
Quantify Your Achievements:Employers love numbers! When drafting your CV, highlight your achievements with quantifiable results. For instance, mention how your data analysis led to a certain percentage increase in efficiency or revenue at a previous job or project. These details can really make your application pop!
Craft a Tailored Cover Letter:For a full-time role at Motorpoint, your cover letter should reflect your passion for data science and your excitement about the specific projects or values of the company. Dive into why you’re a good fit, how your skills align with their needs, and any unique perspectives you can bring to the team.
Stand Out with Relevant Courses and Certifications:Although experience talks, relevant courses or certifications can be your ticket to impressing hiring managers at Motorpoint. Mention any standout courses you've completed that equipped you with essential skills, such as machine learning certifications or data visualisation courses. This shows your commitment to continuously developing your skills in the field!
How to prepare for a job interview at Motorpoint
✨Brush Up on Your Statistics
For a data science role, we need to seriously sharpen our statistics skills. Get ready to tackle technical questions on probability distributions, hypothesis testing, and regression analysis. These are often the bread and butter of data science interviews, so don't just skim over them!
✨Showcase Your Projects
Prepare a killer portfolio showcasing your data science projects. We should include details about the datasets used, the tools and techniques applied, and the impact of your findings. If we can walk them through a particularly challenging project or a cool visualisation that had real-world implications, it’ll really make us stand out!
✨Get Comfortable with Python and R
Most data science positions require us to be proficient in programming languages like Python and R. We should practice common libraries like pandas, NumPy, and scikit-learn, and be ready for live coding exercises or algorithm questions. Showing off our coding chops can really impress the interviewers at Motorpoint!
✨Prepare for Case Studies
Expect to encounter real-world case studies during the interview. We might be asked how we’d approach a data problem or analyse a dataset to extract insights. It's essential to think out loud and demonstrate our problem-solving process so that the interviewer can see our logical thinking in action.