Business Intelligence Lead

Role overview A senior analytics professional is needed to lead the design and delivery of business intelligence solutions for internal stakeholders and external clients. The role blends hands-on technical work with stakeholder engagement and consultancy, steering reporting workstreams from initial discovery through deployment and continuous improvement. It suits someone comfortable acting as a subject matter expert across multiple concurrent client engagements in regulated industries.

Responsibilities

- Design and deliver reporting and analytics products using Power BI, SQL, and Azure data services, including dashboards, KPI frameworks, management information packs, and client-facing analytics. - Lead requirements gathering, stakeholder workshops, and discovery sessions to translate business questions into scalable reporting, data, and analytics solutions. - Build data models, semantic layers, reporting architectures, and KPI frameworks supporting operational, strategic, and regulatory use cases. - Partner closely with data architects, engineers, and technical teams to deliver robust cloud-based reporting and analytics platforms and ensure data quality, accuracy, reconciliation, and governance. - Present analytics outputs, insights, and recommendations to senior stakeholders and external clients, simplifying complex concepts for technical and non-technical audiences. - Manage multiple reporting workstreams in parallel, maintaining data dictionaries, KPI catalogues, reporting inventories, solution documentation, and reporting standards.

Requirements

- Extensive experience delivering BI and analytics solutions within a commercial environment. - Advanced Power BI development skills, including DAX, Power Query, data modelling, and dashboard design. - Strong SQL development and data analysis capability. - Familiarity with Azure data and analytics services, modern cloud-based reporting platforms, and data warehousing principles. - Proven client-facing consultancy experience, with the ability to facilitate workshops and translate business needs into technical solutions. - Strong analytical and problem-solving skills, with a sound understanding of data governance, validation, and reporting controls.

Nice to have

- Exposure to Microsoft Fabric, Python or PowerShell scripting, Azure DevOps or GitHub for source control, and dimensional modelling or ETL/ELT framework design.

Benefits and work setup

- A contributory pension with employer matching up to 10%. - Employee Assistance Programme offering counselling, legal, and wellbeing support for colleagues and their households. - Life assurance cover at four times salary, with the option to purchase additional cover. - Discounts and cashback through a high-street rewards platform. - A flexible benefits plan covering items such as gadgets, travel insurance, will writing, and holiday trading. - Typically 29 days of annual leave plus bank holidays, plus two paid volunteer days per year for a charity of the individual's choice. - A commitment to equal opportunity employment, with pre-employment screening checks required before any offer is confirmed.