Business Intelligence Lead

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

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.

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

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.

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.

• 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.
• Lifecycle Management: Oversee the complete lifecycle of Power BI reports and dashboards—from gathering requirements to deployment, maintenance, and archiving.
• 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.
• Internal: Collaborates with all business units and user groups to ensure BI tools meet organisational needs. Works closely with data and technology teams.
• Confidentiality: Handle sensitive data responsibly and in compliance with GDPR and relevant legislation.
• Occasional travel for team meetings or events
• Development and management of a Power BI product roadmap
• Health & Safety: Contribute to a safe working environment and complete any required training.
• Equality, Diversity & Inclusion: Support the organisation’s commitment to diversity and inclusion, ensuring accessibility and fairness in all activities.
• Performance Monitoring: Analyse and evaluate performance metrics, reporting against objectives and KPIs, and ensuring timely corrective action when required.
• 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.
• 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.
• 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.
• 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.
• Safeguarding: Promote responsible working practices and contribute to safeguarding initiatives.
• External: Manages supplier relationships, collaborates with external peers and sector groups to share knowledge and track developments.

• Strong working relationships across IT and Data functions
• Digital & Data Proficiency: Use digital tools confidently, including Microsoft Office, Power BI, intranet systems, and relevant reporting software.
• Ability to respond promptly to urgent technical issues
• Strong interpersonal and influencing skills (Essential)
• Experience managing third-party vendors (Essential)
• 2 Enhanced: Manages internal and external processes, relationships, and problem-solving.
• Strong SQL proficiency with experience in data modelling, integration, and ETL processes (Essential)
• Excellent organisational and workload management abilities (Essential)
• Desirable: Microsoft Azure and Fabric expertise.
• Proven experience as a BI Lead overseeing development and rollout of BI tools (Essential)
• Essential: Advanced Power BI experience or equivalent.
• Understanding of Microsoft Azure data storage and analytics (Essential)
• 5 Strategic: Deep understanding of organisational systems and strategy; represents the organisation externally; makes high-impact decisions.
• 3 Complex: Uses experience and judgment to solve complex problems and collaborate across teams.
• Knowledge of data governance and quality principles (Essential)
• Extensive Power BI experience including reports, dashboards, DAX, and Power Query (Essential)
• 4 Expert: Recognised authority; leads and influences others; manages significant resources.
• Advanced analytical and problem-solving skills (Essential)
• Demonstrated ability to resolve complex technical problems (Essential)
• High system availability and strong user satisfaction with BI tools

Business Intelligence Reporting Lead £44k Salary

Location: London-based office with flexibility to work remotely