Business Intelligence Analyst

Business 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