Job Description
Business Intelligence AnalystAbout 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 FridayLocation: 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 BenefitsWe 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