Business Intelligence Lead

Business Intelligence Reporting Lead £44k Salary

Job Details

Directorate: Corporate Services

Department/Team: Strategy and Business Intelligence

Location: London-based office with flexibility to work remotely

Hours: Contracted hours to be agreed locally with line manager

Job Purpose

The Business Intelligence (BI) Reporting Lead will be the organisation’s leading expert in Power BI and other reporting tools, playing a key role in enhancing data maturity and enabling data-driven decision-making.

They will oversee the full lifecycle of BI reports and dashboards, from requirements gathering through to design, deployment, maintenance, and optimisation, while providing best practice guidance on reporting across business systems such as Dynamics and Assemble.

The role involves complex data troubleshooting, process improvement, and collaboration across departments to resolve data quality issues and enhance reporting capabilities. The BI Reporting Lead will also contribute to the broader data and digital strategy, particularly within Microsoft Azure data architecture, shaping the strategic use of BI tools and defining the future direction of reporting across the organisation.

Key Responsibilities and Accountabilities

1. Strategic Leadership: Lead the development and implementation of robust organisation-wide BI best practices and standards, embedding a “hub and spoke” model that ensures alignment with governance, security, and data usage policies.
2. BI Expertise: Act as the organisation’s BI reporting expert, collaborating with IT to develop, procure, and optimise BI tools, including the extraction, transformation, and loading (ETL) of complex datasets in line with technical standards.
3. Lifecycle Management: Oversee the complete lifecycle of Power BI reports and dashboards—from gathering requirements to deployment, maintenance, and archiving.
4. Reports and Dashboard Development: Lead the execution of the Power BI roadmap, delivering user-focused reporting solutions aligned with strategic goals. Ensure technical consistency, high-quality documentation, and effective stakeholder engagement.
5. BI Tool Optimisation: Optimise Power BI performance through advanced data modelling, efficient queries, and continuous monitoring. Proactively identify and resolve performance issues in collaboration with IT.
6. Data Maturity and Culture: Support organisational data maturity initiatives and foster a culture of data-driven decision-making. Provide training and technical support to BI users, building strong stakeholder relationships.
7. Innovation and Best Practice: Stay up to date with emerging BI technologies and methodologies, advocating for innovative approaches to improve access to and use of data.
8. Performance Monitoring: Analyse and evaluate performance metrics, reporting against objectives and KPIs, and ensuring timely corrective action when required.

Requirements – Essential / Desirable

• Proven experience as a BI Lead overseeing development and rollout of BI tools (Essential)
• Strong SQL proficiency with experience in data modelling, integration, and ETL processes (Essential)
• Understanding of Microsoft Azure data storage and analytics (Essential)
• Extensive Power BI experience including reports, dashboards, DAX, and Power Query (Essential)
• Knowledge of data governance and quality principles (Essential)
• Advanced analytical and problem-solving skills (Essential)
• Demonstrated ability to resolve complex technical problems (Essential)
• Experience managing third-party vendors (Essential)
• Strong interpersonal and influencing skills (Essential)
• Excellent organisational and workload management abilities (Essential)

Dimensions of the Role

Resources: Accountable for the strategic positioning and maintenance of BI tools across the organisation.

Key Relationships

• Internal: Collaborates with all business units and user groups to ensure BI tools meet organisational needs. Works closely with data and technology teams.
• External: Manages supplier relationships, collaborates with external peers and sector groups to share knowledge and track developments.

Information Security and Governance: Responsible for upholding data governance and security protocols relevant to the role.

Key Deliverables

1. High system availability and strong user satisfaction with BI tools
2. Strategic and operational Power BI reports that meet user and organisational needs
3. Engaged BI user groups fostering collaboration and trust
4. System optimisation reducing support and procurement costs
5. Development and management of a Power BI product roadmap
6. Strong working relationships across IT and Data functions

Level Descriptions

• 5 Strategic: Deep understanding of organisational systems and strategy; represents the organisation externally; makes high-impact decisions.
• 4 Expert: Recognised authority; leads and influences others; manages significant resources.
• 3 Complex: Uses experience and judgment to solve complex problems and collaborate across teams.
• 2 Enhanced: Manages internal and external processes, relationships, and problem-solving.
• 1 Foundation: Contributes to organisational goals without managerial responsibility.

Qualifications and Training

• Essential: Advanced Power BI experience or equivalent.
• Desirable: Microsoft Azure and Fabric expertise.

Additional Information

1. Confidentiality: Handle sensitive data responsibly and in compliance with GDPR and relevant legislation.
2. Equality, Diversity & Inclusion: Support the organisation’s commitment to diversity and inclusion, ensuring accessibility and fairness in all activities.
3. Health & Safety: Contribute to a safe working environment and complete any required training.
4. Safeguarding: Promote responsible working practices and contribute to safeguarding initiatives.
5. Digital & Data Proficiency: Use digital tools confidently, including Microsoft Office, Power BI, intranet systems, and relevant reporting software.

Other Requirements:

• Occasional travel for team meetings or events
• Some out-of-hours work may be required
• Ability to respond promptly to urgent technical issues