Microsoft Fabric & Power BI Lead

Job summary

Use your data expertise to support better care, planning and improvement.

Birmingham Hospice is looking for a Microsoft Fabric & Power BI Lead to shape, build and support our data and reporting platform. Youll help colleagues turn clinical, operational, finance, fundraising, retail and people data into reliable information they can use with confidence.

This is a hands-on technical leadership role, taking work from initial requirements through to delivery and ongoing support. Youll develop secure data pipelines, reusable data models and accessible Power BI dashboards, replacing fragmented reporting with consistent measures and maintainable solutions.

Working with service leaders, data owners, analysts and Technology colleagues, youll turn practical questions into useful reports and insights. Youll set engineering and reporting standards, strengthen data quality and governance, and keep the platform reliable through testing, monitoring and support. Youll also coach colleagues and help teams use data more confidently.

Main duties of the job

Were looking for someone with: Substantial experience delivering and supporting production BI and cloud data platforms Strong Microsoft Fabric knowledge and Power BI expertise, including DAX, semantic modelling, security and performance Strong SQL and data-modelling skills, with working knowledge of Python and/or PySpark Experience of data integration, governance, quality controls, source control, testing and deployment The ability to explain technical issues clearly, work collaboratively and develop colleagues skills

Experience in a hospice, charity, healthcare or another regulated setting would be welcome. Youll have a relevant degree or equivalent substantial professional experience.

Our values are Kindness, Togetherness, Positivity, Openness, Respect and Innovation. Were looking for someone who brings these values to their work and handles sensitive information with care and integrity.

If you would like to find out more about the role, please email Leon Claraway, Head of Data and Technology on leon.claraway@birminghamhospice.org.uk

About us

Birmingham Hospice provides expert palliative and end of life care for people and their families living with life-limiting illnesses.

We believe that all people in Birmingham should have access to the best specialist care and support - when, where and how they need it. Our vision is a future where everyone with a life-limiting illness will live and die with dignity and in comfort. Our mission is to enable more people from all communities to access the care of their choice at the end of life.

During a recent CQC inspection our sites have been rated outstanding, with independent health care regulators highlighting that colleagues and services are caring, responsive and well-led.

Our outstanding teams are passionate about providing the very best care, and patients and their loved ones are at the heart of everything we do.

Our values of kindness, respect, innovation, togetherness, positivity and openness are at the centre of who we are, what we do and how we behave. We pride ourselves on being an inclusive, welcoming, caring and supportive team. We are offering a competitive salary, with generous holiday allowance, a contribution pension scheme, and a commitment to investing in our people through employee benefits and ongoing professional development.

Details

• Date posted: 19 October 2026
• Pay scheme: Other
• Salary: £55,000 a year (up to £55,000 per annum)
• Contract: Permanent
• Working pattern: Full-time, Flexible working
• Reference number: B0060-26-0052
• Job locations: 76 Grange Road, Erdington, Birmingham, B24 0DF, United Kingdom, Birmingham Hospice, 176 Raddlebarn Road, Selly Park, BIRMINGHAM, B29 7DA, United Kingdom

Job responsibilities

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

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.