BI Engineer

Motorpoint Ltd
Derby, United Kingdom
1 day ago
Apply on careers.motorpoint.co.uk
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
3 years minimum
Compensation
£55,000 - £60,000
Working hours
Regular working hours

Tech stack

Sql Data Warehouse Artificial Intelligence Data Analysis BigQuery Continuous Integration Data Architecture Information Engineering Extract Transform Load (ETL) Cursor Software Debugging Performance Tuning Power BI
+11 more
Microsoft Copilot Standard Sql SQL Server Reporting Services Transaction Data Large Language Models Claude Code Snowflake Git Software Version Control Data Pipelines Databricks

Job description

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.

Requirements

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., * 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.

Benefits & conditions

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.

About the company

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!, 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.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on careers.motorpoint.co.uk
Prepare application

Good distractions

Loading talks and stories from around this role…