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.
