Power BI Specialist - NHS Acute Trust - Outside IR35

Power BI Specialist - NHS Acute Trust - Outside IR35

Role Overview

Power BI Specialist with NHS Acute domain expertise responsible for designing, building, and optimising dashboards and analytics solutions across clinical, operational, and performance datasets.

This role sits at the intersection of:

• Data platform (often Azure/Fabric/Databricks/SQL)
• Clinical systems (EPR, PAS, ED systems)
• NHS reporting standards (SITREP, RTT, A&E, etc.)

RequirementsCore Responsibilities
1. Clinical & Operational Reporting

Develop dashboards for:

• A&E performance (4-hour target)
• RTT pathways
• Bed occupancy & patient flow
• Theatre utilisation
• Elective recovery & waiting lists

Translate clinical KPIs into meaningful visualisations for:

• Clinicians
• Operational managers
• Exec boards

2. Data Modelling & Transformation

Build robust semantic models (star schema/tabular models)

Handle NHS-specific datasets:

• CDS (Commissioning Data Sets)
• SUS (Secondary Uses Service)
• HES (Hospital Episode Statistics)

Use DAX + Power Query (M) for transformations and measures

3. Integration with NHS Data Platforms

Work with:

• EPR systems (eg Cerner Millennium, Epic, System C)
• Data warehouses (SQL Server, Azure Synapse, Databricks)
• FDP/Foundry (in some Trusts)

Ensure near Real Time or batch reporting pipelines

4. Governance, IG & Compliance

Apply:

• NHS DSP Toolkit (DSPT)
• Role-Based Access Control (RBAC)
• Data anonymisation/pseudonymisation

Ensure dashboards comply with:

• Information Governance (IG)
• Caldicott principles

5. Performance & Optimisation

Optimise:

• Large datasets (millions of patient records)
• Incremental refresh
• Query folding

Tune Power BI Service:

• Capacity management
• Dataset refresh strategies

6. Stakeholder Engagement

Work with:

• Clinical leads (Consultants, Matrons)
• Operational teams
• Trust BI/Analytics teams

Translate clinical language - data models - dashboards

Required Skills

Technical

• Power BI (Expert level)
• DAX (advanced)
• Data modelling (tabular/semantic models)
• Power BI Service & governance

SQL (advanced)

Experience with:

• Azure (Synapse/Data Factory/Fabric)
• Databricks (nice to have)

Understanding of:

• Data pipelines (ETL/ELT)
• API/integration patterns (optional)

NHS Domain Knowledge (Critical)

Acute Trust workflows:

• Patient pathways (ED - admission - discharge)
• Elective vs non-elective care

Key metrics:

• RTT, A&E 4-hour, LOS, bed occupancy

Familiarity with:

• NHS data standards & datasets
• Clinical coding (ICD-10, OPCS)

Soft Skills

• Ability to work with clinicians (non-technical stakeholders)
• Strong storytelling with data
• Experience in board-level reporting

Ideal Profile

5-10+ years in BI/analytics
2-5+ years in NHS (preferably Acute Trust)

Has delivered:

• Trust-wide dashboards
• Executive reporting packs

Exposure to FDP/Foundry/Fabric is a strong advantage