Business Intelligence Lead

BI Lead – Consumer Goods

Location: Lancashire (2 days per week in office, commutable from Burnley/Preston area)

Salary: Up to £70,000

The Company

We’re partnered with a leading UK consumer goods brand, known nationwide for their products in the home & lifestyle space. With ongoing growth and digital transformation, they are investing heavily in data capabilities to improve business decision-making, customer insight, and operational efficiency. The organisation has already built out a small but capable data team, and they’re now looking to appoint a BI Lead to accelerate their reporting, analytics, and automation strategy.

This is a high-impact role where you’ll shape how data is delivered across the group, working with stakeholders across Finance, Operations, Marketing, and Commercial to enable smarter, faster decisions.

The Role

This newly created BI Lead role sits within a growing data function, reporting into the Head of Data. The successful candidate will take ownership of group-wide reporting and build out a self-service analytics platform to support stakeholders at all levels. You’ll combine hands-on development with leadership, guiding the team on best practices while driving adoption of modern BI tools.

You’ll play a key role in shaping the data strategy, leading projects to unify reporting across multiple business units, improve pipelines, and embed automation to reduce manual reporting.

Key Responsibilities

• Lead BI development and delivery across the organisation, driving consistency and scalability.
• Design and implement a unified reporting platform, empowering stakeholders to self-serve insights.
• Build and optimise pipelines within the Azure ecosystem (Databricks, Data Factory, Synapse).
• Develop, maintain, and enhance dashboards and reports using Power BI (part of Microsoft stack).
• Collaborate with business stakeholders to gather requirements, translate them into solutions, and ensure insights drive impact.
• Mentor and support junior team members, fostering best practice in data modelling, governance, and reporting.
• Partner with engineering colleagues on in-house platform migration projects, ensuring data is structured and accessible for analysis.
• Drive automation of reporting processes, reducing manual effort and increasing accuracy.
• Work closely with the Head of Data on data strategy, roadmap, and stakeholder engagement.

Skills & Experience

• 5+ years’ experience in Business Intelligence, with proven delivery of group-wide reporting projects.
• Strong SQL skills – confident in writing, optimising, and troubleshooting queries.
• Experience with the Microsoft stack, particularly Power BI (development and publishing).
• Hands-on experience in the Azure ecosystem (Databricks, Data Factory, Synapse).
• Understanding of data pipelines; ability to design and manage end-to-end data flows (not necessarily hardcore engineering).
• Exposure to Python for data manipulation/automation is desirable but not essential.
• Strong communication and stakeholder engagement skills, with experience translating technical outputs into business value.
• Previous leadership or mentoring experience is desirable, as this role may grow into a formal management position.
• Commercially savvy, able to prioritise projects that deliver tangible value to the business.

Benefits

• Salary up to £70,000 depending on experience.
• Hybrid working: 2 days per week in the Lancashire office (commutable from Burnley, Preston, Blackburn, and surrounding areas).
• Opportunity to lead BI strategy in a high-profile role with direct business impact.
• Work on varied projects, from platform migration to group reporting and automation.
• Collaborative culture with a growing data team and supportive leadership.

How to Apply

If you’re a BI professional looking for a step up into a leadership role—or already operating as a BI Lead and seeking a high-impact environment—please send your CV to Mohammed Buhariwala at Harnham via the Apply link on this page.

Keywords

BI Lead, Business Intelligence Lead, BI Developer, BI Specialist, Data Engineer, Power BI, Azure, Databricks, SQL, Pipelines, Data Visualisation, Self-Service Analytics, Reporting Platform, Consumer Goods, Lancashire, Preston, Burnley, North West, UK Jobs