Power BI Specialist - NHS Acute Trust - Outside IR35
Posted Today by 1774611289
Negotiable
Outside
Undetermined
United Kingdom
Summary: Power BI Specialist with expertise in the NHS Acute domain is responsible for designing, building, and optimizing dashboards and analytics solutions across various clinical, operational, and performance datasets. The role requires collaboration with clinical systems and adherence to NHS reporting standards. The specialist will engage with stakeholders to translate clinical KPIs into actionable insights. This position is classified as outside IR35, indicating a favorable tax status for contractors.
Key Responsibilities:
- Develop dashboards for A&E performance, RTT pathways, bed occupancy, theatre utilization, and elective recovery.
- Translate clinical KPIs into visualizations for clinicians, operational managers, and executive boards.
- Build robust semantic models and handle NHS-specific datasets.
- Work with EPR systems and data warehouses to ensure reporting pipelines.
- Apply NHS DSP Toolkit and ensure compliance with Information Governance.
- Optimize large datasets and tune Power BI Service for performance.
- Engage with clinical leads and operational teams to translate clinical language into data models and dashboards.
Key Skills:
- Expert level in Power BI and advanced DAX.
- Data modeling expertise (tabular/semantic models).
- Advanced SQL skills.
- Experience with Azure and Databricks.
- Understanding of data pipelines and API/integration patterns.
- Knowledge of NHS domain workflows and key metrics.
- Ability to work with non-technical stakeholders and strong storytelling with data.
- Experience in board-level reporting.
Salary (Rate): undetermined
City: undetermined
Country: United Kingdom
Working Arrangements: undetermined
IR35 Status: outside IR35
Seniority Level: undetermined
Industry: IT
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