Microsoft Fabric & Power BI Lead

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

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

Job title

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

Job purposeLead 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.

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 roleOwn 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

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.

duties and responsibilitiesMicrosoft 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.

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

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.

Qualifications