Microsoft Fabric & Power BI Lead

NHS Jobs; Birmingham; On-site; GBP 70,000 - 100,000; Full time

Job summary

NHS Jobs seeks a senior Microsoft Fabric & Power BI Lead to design, deliver and operate a unified analytics platform across clinical, operational, financial and fundraising data. You will own the platform architecture, governance and delivery roadmap.

You will work with data owners, analysts and external partners to replace fragmented reports with reusable data products, ensure information governance and cyber security, and mentor teams in BI best practices.

Qualifications

• DBS check required.
• Experience leading Fabric/Power BI platforms.

Responsibilities

• Design secure, scalable Fabric architecture using OneLake, lakehouse, warehouse, pipeline and notebook patterns.
• Build reliable ingestion, transformation and orchestration across applications, APIs, databases, files and external sources.
• Set SQL, Python or PySpark and ETL/ELT standards, using reusable integration patterns.
• Map authoritative sources and information flows.
• Improve capture at source with validation, reconciliation and data-quality issue resolution.
• Maintain documentation, metadata, lineage, definitions and dependencies.
• Build logging, alerting, recovery and maintainability with ownership, security, licensing and support considerations.
• Develop governed workspaces, apps, semantic models and dashboards across directorates.
• Set dimensional modelling, DAX, calculation and accessibility standards.
• Optimise model, query, refresh and report performance.
• Translate service questions into prioritised requirements.
• Lead discovery, build, testing, release, adoption and benefits review.
• Explain technical constraints and data limitations.
• Use feedback to improve products and retire obsolete outputs.
• Enable self-service analytics and build data literacy.
• Use source control, peer review, deployment pipelines and separate environments.
• Test data, models, security, performance, accessibility and user acceptance.
• Maintain release records, dependencies, rollback plans and change communications.
• Automate platform deployment, validation, monitoring and administration.
• Prioritise technical debt, defects and improvements.
• Embed data protection, confidentiality, governance and cyber security, working with governance teams.
• Implement least-privilege access, security and publication controls.
• Assess privacy and security risks for new data and AI features.
• Support audits and incident investigations, improving controls.
• Monitor Fabric capacity, Power BI performance, refreshes and cost.
• Plan licensing and capacity against demand.
• Resolve incidents and perform root-cause analysis.
• Maintain support routes and escalation procedures.
• Manage vulnerabilities and dependencies with ICT and security teams.
• Protect confidential information and separate experimentation from production.
• Ensure solutions are validated and explainable and monitor bias and accuracy.
• Mentor data teams and manage suppliers and partners.

Skills

Microsoft Fabric

Power BI

Data governance

SQL

Python

ETL/ELT

Stakeholder mgmt

Security

Job description

Job title Microsoft Fabric & Power BI Lead Department Digital, Data & Technology Hospice band TBC (subject to job evaluation) Reports to Head of Technology & Data Responsible for Microsoft Fabric, Power BI and Business Intelligence delivery DBS required Enhanced Job purpose Lead the design, delivery and operation of Birmingham Hospices Microsoft Fabric and Power BI platform. Turn clinical, operational, financial, fundraising, retail and people data into trusted, secure information that supports care, planning and improvement. Reporting to the Head of Technology & Data, combine hands-on technical leadership with stakeholder engagement, governance and service management. Replace fragmented datasets and recurring manual reports with reusable data products and consistent organisational measures. Scope of the role Own the platform architecture, engineering and reporting standards, development practices and operational support. Work with service leaders, data owners, analysts, ICT and external partners to deliver proportionate, maintainable solutions that meet information-governance, clinical-safety and cyber-security requirements. Platform strategy and technical leadership Maintain a Fabric and Power BI roadmap aligned with organisational priorities, clear ownership, governance and support arrangements. Advise on platform options, delivery plans and investment needs, contributing to business cases, procurement and budget planning. Assess Microsoft developments for value and supportability, and share learning through partners and professional networks.

Main duties and responsibilities

Microsoft Fabric engineering and data quality Design secure, scalable Fabric architecture using appropriate OneLake, lakehouse, warehouse, pipeline and notebook patterns, avoiding unnecessary complexity. Build reliable ingestion, transformation and orchestration across applications, APIs, databases, files and external sources. Set SQL, Python or PySpark and ETL/ELT standards, using reusable integration patterns. Map authoritative sources and information flows. Work with data owners to improve capture at source and implement validation, reconciliation, exception handling and accountable resolution of data-quality issues. Maintain documentation, metadata, lineage, definitions and dependencies. Build in logging, alerting, recovery and maintainability, assessing ownership, security, licensing and support before integrating new systems. Power BI modelling and product delivery Develop governed workspaces, apps, reusable semantic models and dashboards, agreeing consistent measures and definitions across directorates. Set dimensional-modelling, DAX, calculation, visual-design and accessibility standards. Optimise model, query, refresh and report performance. Translate service questions and statutory needs into prioritised requirements. Lead discovery, build, testing, release, adoption and benefits review, with clear product purpose, ownership and success measures. Explain technical constraints and data limitations. Use feedback and usage evidence to improve products, consolidate duplicated reports and retire obsolete or low-value outputs. Enable controlled self-service analytics and build data literacy through guidance, training, communities of practice and user support. Development testing and release management Use source control, peer review, reusable components and deployment pipelines, with separate development, test and production environments. Test data, models, security, performance, accessibility and user acceptance. Maintain release records, dependencies, rollback plans and change communications. Automate platform deployment, validation, monitoring and administration where useful. Prioritise technical debt, defects and improvements alongside new delivery. Service assurance and collaborationGovernance security and information assurance Embed data protection, confidentiality, records management, cyber security and clinical safety, working with Information Governance, clinical governance and system owners on lawful, ethical data use. Implement least-privilege access, row-level or object-level security, workspace governance, sensitivity controls and secure sharing, with auditable ownership, approval and publication arrangements. Assess privacy, security, clinical and operational risks for new data, features, integrations and AI. Support audits, assurance reviews and incident investigations, improving controls from findings. Performance capacity and service management Monitor Fabric capacity, Power BI performance, refreshes, gateway health, storage, consumption and cost. Plan licensing and capacity against demand, roadmaps and financial constraints. Resolve service incidents, failed refreshes and technical data defects, communicating impact and applying root-cause analysis. Maintain support routes, escalation, recovery procedures and service measures. Manage vulnerabilities, updates, gateways, connections and dependencies with ICT, cyber-security and application teams to improve resilience and reliability. Advanced analytics AI and automation Protect confidential information and separate experimentation from production. Ensure solutions are validated, documented and explainable, with clear ownership and support before adoption, and monitor bias, privacy, accuracy and continued fitness for purpose. Capability and supplier collaboration Mentor data, and colleagues, helping them apply agreed standards, share knowledge and reduce dependency on individuals. Work across directorates and manage specialist suppliers and Microsoft partners, maintaining technical quality, value for money, knowledge transfer and sustainable internal ownership.

General duties Confidentiality

All employees are required to uphold the confidentiality of all information records in whatever format, encountered in the course of employment and after it. All employees are bound by the requirements of the General Data Protection Regulations when, in the course of their employment, they deal with information records relating to individuals.

Equality and Diversity

The hospice is committed to promoting an environment that values diversity. All staff are responsible for ensuring that they treat individuals equally and fairly and do not discriminate on the grounds of age, disability, gender reassignment, marriage or civil partnership, pregnancy or maternity, race, religion or belief, sex and sexual orientation. The hospice expects all staff to behave in a way that recognises and respects diversity in line with the appropriate standards.

Health and safety

All employees have a responsibility under the terms of the Health and Safety at Work Act 1974 to protect and promote their own health and that of others in the workplace. All employees must comply with all hospice health and safety procedures, including infection control. The prevention and control of infection is the responsibility of everyone who is employed by the hospice. Employees must be aware of infection control policies, procedures and the importance of protecting themselves and their clients in maintaining a clean and healthy environment.

Information governance

All employees are responsible for ensuring they undertake any training relating to information governance, read the hospices policies, procedures and guidance documents relating to information governance, and understanding how this affects them in their role.

Professional development

All employees must participate in an annual appraisal and develop a personal development plan with their line manager. All employees are responsible for maintaining their statutory and mandatory training.

Safeguarding children, young people and vulnerable adults

The hospice is committed to safeguarding and promoting the welfare of children, young people and vulnerable adults. All employees and volunteers are expected to behave in such a way that supports this commitment.