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.
- 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.
- 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.
- 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.
- 25 days’ annual leave
- Christmas closure
- A day off to celebrate your birthday
- Life assurance
- Health and dental cash plans
- Pension scheme