Full job descriptionBusiness Intelligence Analyst

About the role
Lightfoot turns vast volumes of in-vehicle telemetry into products that change driver behaviour and cut emissions and cost for the fleets we serve. The BI Analyst keeps our reporting and analytics flowing — building clear, engaging dashboards and answering the business’s data questions, with a particular focus on Insight Hub, our customer-facing data platform. This is a hands-on, delivery-focused role for someone strong in Power BI, SQL and Python who enjoys turning data into decisions.

Hours: 37.5 hours per week, Monday to Friday
Location: This role can be based on a hybrid working arrangement from our Exeter office, with a minimum of two days per week in the office, or fully remote from anywhere within the UK.

What you will do
*Build dashboards and reports. Design and develop interactive, customer-facing Power BI dashboards that translate stakeholder requirements into clear, compelling visuals.
*Tell the story. Present concise, accurate insights that inform decisions across the business.
*Produce and maintain BAU and recurring reports. Ensure regular reporting is delivered accurately and on time, keeping documentation and processes up to date as the business evolves.
*Uphold quality standards. Participate in dashboard and code reviews, applying defensive, repeatable practices to ensure robust, reliable outputs.
*Drive continuous improvement. Proactively identify opportunities to optimise reporting workflows, reduce manual effort, and improve operational efficiency across the data function.

Essential skills and experience
*Strong Power BI. Proven ability to build and maintain dashboards and the underlying data models.
*Strong SQL. Strong querying skills across complex datasets, including transforming and joining data from multiple sources.
*Python. Comfortable using Python for data manipulation and analysis.
*Excel. Proficient at working with Excel for reporting and ad hoc analysis.
*2+ years in a BI / data analyst role. A solid mid-level track record of delivering reporting and analysis.
*Clear communicator. Concise written and spoken communication; confident presenting to stakeholders.

Desirable
*Large / telemetry data sets. Experience working with high-volume data.
*Cloud awareness. Familiarity with cloud data platforms (for example Azure and AWS)
*Agile delivery. Comfortable working in an agile, iterative team.

Personal characteristics
*A curious problem solver who enjoys turning data into clear answers.
*Organised and reliable.
*Active problem solver.
*Focused on continuous improvement.
*Personable and confident when communicating with stakeholders.

Our Benefits
We believe great work deserves great support. Alongside a competitive salary, we offer a range of benefits designed to reward our colleagues:
*25 days’ annual leave
*Christmas closure
*A day off to celebrate your birthday
*Life assurance
*Health and dental cash plans
*Pension scheme

…and much more. Visit the "Our Benefits" section of our website to discover the full range of benefits available to our team.

REF-229 125