Job summary
We are recruiting a Business Intelligence Developer to join our Business Intelligence Team on a fixed-term basis (5 years) to support the Trust's Electronic Patient Record (EPR) programme, with phase 1 going live in May 2027.
As EPR is implemented, some of the Trust's existing reporting will remain unchanged, some will draw on a mix of existing sources and the new EPR data repository (hosted on Google Cloud Platform), and some will be built solely from EPR data. This role will lead on reviewing our existing reporting suite from a business and reporting-design perspective, working directly with report area subject matter experts in clinical and operational teams to confirm business rules and agree reporting requirements. You'll help decide what should be retained, updated, consolidated or decommissioned as part of the transition, and build dashboards and reporting solutions from the Trust's data warehouse and the EPR data repository that are consistent, well-defined and easy to maintain.
We're looking for someone with strong SQL and Power BI skills, good business analysis skills to engage stakeholders and translate their needs into clear reporting specifications, and ideally NHS or large complex organisation experience.
Main duties of the job
Carry out a systematic review of existing reports and dashboards, working with report area subject matter experts in clinical and operational teams to determine what should be retained, updated to incorporate EPR data, consolidated, or decommissioned as part of the transition to EPR.
Liaise directly with clinical and operational stakeholders to confirm business rules and agree reporting requirements, ensuring reporting solutions meet internal and external reporting needs.
Develop, design and deliver dashboards and reporting solutions from the Trust's data warehouse and the EPR data repository, evolving the reporting estate into one that is consistent in its measures and definitions and straightforward to maintain.
Build and maintain Power BI reports and dashboards, applying best practice in data modelling, DAX and visual design to deliver intuitive, self-service reporting.
Document business rules and report specifications agreed with SMEs, ensuring sign-off is captured and traceable, and maintain a data dictionary/metadata catalogue to reduce duplicate reporting definitions.
Support the development of the wider BI team's knowledge and technical skills through documentation and knowledge-sharing.
Present reporting solutions and analytical outputs to a range of stakeholders across clinical, operational and corporate functions, clearly articulating data, methodology and insights.
About us
At UHSussex, diversity is our strength, and we want you to feel included to help us always deliver Excellent Care Everywhere, as shown in our Outstanding for Caring CQC rating. Your uniqueness and experiences will be part of our creative and innovative community where everyone is encouraged to succeed. We have a range of staff networks to help break down barriers, and can offer a buddy to help new members settle in. We're proud to be a Disability Confident Employer (Level 3) and a Veteran Aware Trust.
Candidate Pack
Details
Date posted
26 August 2026
Pay scheme
Agenda for change
Band
Band 8a
Salary
£57,528 to £64,750 a year
per annum, pro rata
Contract
Fixed term
Duration
5 years
Working pattern
Full-time,
Flexible working,
Home or remote working
Reference number
279-8193504-AUG26
Job locations
Worthing Hospital
Lyndhurst Road
Worthing
BN11 2DH
United Kingdom
Job description
Job responsibilities
This role is eligible for visa sponsorship under the UK Visas & Immigration (UKVI) Skilled Worker route however sponsorship can only be provided where applicants meet the specific requirements set by UKVI, including the relevant skill and salary thresholds (£25000), and any role-specific criteria.
Please note that if you currently work for another NHS Trust or UHSussex and you are applying to accept this position as a secondment opportunity, before applying you must seek agreement and authorisation from your current Trust/Manager. Secondments cant be agreed without this approval. If you are unable to gain approval, you should refrain from applying unless you wish to take this role as a fixed term position.
Technical Development & Data Engineering
Design, create and maintain SQL database objects including tables, views, stored procedures and functions, ensuring optimal database design principles, data integrity and performance.
Write complex, efficient SQL queries to support reporting, analysis and data extraction requirements across the Trust; proactively review and optimise existing queries and database objects to improve performance, maintainability and reliability.
Develop and maintain ETL processes to load data from multiple sources into SQL Server databases, as well as produce structured datasets in Excel/CSV formats for internal use and external submissions (including national and regional data returns).
Build, develop and maintain Power BI reports, dashboards and semantic models, utilising best practice in data modelling, DAX, Power Query and visual design to deliver intuitive, self-service reporting solutions across the Trust.
Develop and manage reporting solutions within Microsoft Fabric, including the creation and maintenance of Fabric pipelines for data ingestion, transformation and orchestration.
Review existing SSRS reports and subscriptions for migration to PowerBI to support operational and statutory reporting needs.
Reporting, Analysis & Information Delivery
Carry out a systematic review of existing reports, dashboards and their underlying code/logic - much of which has not been reviewed for some time - to determine what should be retained as-is, updated to incorporate EPR data, consolidated with other reports, or decommissioned as part of the transition to EPR.
Develop, design and deliver dashboards and reporting solutions from the Trust's data warehouse and the EPR data repository, and lead on discrete areas of work which evolve the reporting estate into one which is optimised for BI, consistent in its measures and definitions, and straightforward to maintain and update.
Work seamlessly with the BI business partners, data management team, and liaise directly with report area subject matter experts in clinical and operational teams, to confirm business rules and ensure the reporting layer is designed to meet internal and external reporting requirements, implementing well-defined business logic and ensuring solutions are designed to support an efficient data environment, automated for efficiency, time saving for stakeholders, and enable self-service.
To use sophisticated analysis techniques and performance management to monitor and report on progress against targets and identify where improvements in the effective and efficient delivery of services can take place.
Strategic & Operational Support
To develop solutions which support the strategic and operational BI support function and cycle for the clinical and corporate divisions, contributing alongside Business Intelligence Partners and the wider BI team to a value-added, forward-looking and wide-ranging BI service.
To support the Head of Business Intelligence Development and Head of Operational Business Intelligence in delivering Trusts Business Intelligence strategic vision to streamline activities and focus on value-added goals, implementing a real-time corporate approach to intelligence, a single version of the truth, promoting a self-service and ease of access approach to data, exploring and utilising world-class technologies.
To develop and own a part of the Business Intelligence improvement plan and work with wider BI team colleagues and staff within Divisions to maintain and implement.
To work with colleagues in the wider BI team to inform developments of products to deliver the BI improvement plan, reduce manual or disjointed processes, such that service is value-added and not just provision of information.
Support the transformation into an exemplar organisation based on sound business intelligence, against a rigorous Performance Framework.
Essential Skills & Experience
Expert-level SQL skills, including the ability to design and create tables, write highly efficient and complex queries, critically review and optimise existing SQL code, and develop stored procedures and functions to support reporting and data processing needs.
Strong business analysis skills, with the ability to engage effectively with report area SMEs and other stakeholders to elicit, document and agree detailed reporting requirements and specifications.
Experience developing SSIS packages for data loading, transformation and extraction, including producing datasets for national/regional submissions and internal reporting in Excel/CSV formats.
Proven expertise in Power BI, including data modelling, DAX, Power Query, report/dashboard design and deployment, with the ability to deliver enterprise-grade self-service reporting solutions.
Experience with Microsoft Fabric, including building and managing Fabric workspaces, lakehouses, dataflows and pipelines for end-to-end data orchestration and processing.
Experience developing business applications using Microsoft PowerApps to support operational processes and data capture is desirable.
Demonstrable experience in Excel for data analysis, reporting and the preparation of submission-ready datasets.
Experience of working with multiple stakeholders at all levels, translating complex data and technical concepts into accessible, actionable intelligence.
Proven ability to mentor and support colleagues within a technical BI environment.
Documentation & Knowledge Management
Ensuring each completed piece of review, consolidation or development work is accompanied by clear technical documentation for reports, datasets, ETL/data pipelines and database objects including data lineage, source-to-target mappings, transformation logic and refresh schedules so that reporting solutions are fully documented, auditable and maintainable and handed over to the BAU BI team on completion.
Maintain a data dictionary / metadata catalogue defining report measures, calculations and business rules consistently across the reporting suite, reducing the duplicate-definition problem the EPR review is meant to fix.
Document business rules and report specifications agreed with report area SMEs, ensuring sign-off is captured and traceable. Support the development of the wider BI team's knowledge and technical skills through documentation, knowledge-sharing and on-the-job coaching as pieces of work are completed and transitioned into business-as-usual.
Maintain change logs / version control for reports and underlying code as part of the review, consolidation and decommissioning process
Contribute to or maintain a testing and validation log for the parallel-running/reconciliation work during the EPR transition (documenting what was checked, by whom, against what expected outcome)
Job responsibilities
This role is eligible for visa sponsorship under the UK Visas & Immigration (UKVI) Skilled Worker route however sponsorship can only be provided where applicants meet the specific requirements set by UKVI, including the relevant skill and salary thresholds (£25000), and any role-specific criteria.
Please note that if you currently work for another NHS Trust or UHSussex and you are applying to accept this position as a secondment opportunity, before applying you must seek agreement and authorisation from your current Trust/Manager. Secondments cant be agreed without this approval. If you are unable to gain approval, you should refrain from applying unless you wish to take this role as a fixed term position.
Technical Development & Data Engineering
Design, create and maintain SQL database objects including tables, views, stored procedures and functions, ensuring optimal database design principles, data integrity and performance.
Write complex, efficient SQL queries to support reporting, analysis and data extraction requirements across the Trust; proactively review and optimise existing queries and database objects to improve performance, maintainability and reliability.
Develop and maintain ETL processes to load data from multiple sources into SQL Server databases, as well as produce structured datasets in Excel/CSV formats for internal use and external submissions (including national and regional data returns).
Build, develop and maintain Power BI reports, dashboards and semantic models, utilising best practice in data modelling, DAX, Power Query and visual design to deliver intuitive, self-service reporting solutions across the Trust.
Develop and manage reporting solutions within Microsoft Fabric, including the creation and maintenance of Fabric pipelines for data ingestion, transformation and orchestration.
Review existing SSRS reports and subscriptions for migration to PowerBI to support operational and statutory reporting needs.
Reporting, Analysis & Information Delivery
Carry out a systematic review of existing reports, dashboards and their underlying code/logic - much of which has not been reviewed for some time - to determine what should be retained as-is, updated to incorporate EPR data, consolidated with other reports, or decommissioned as part of the transition to EPR.
Develop, design and deliver dashboards and reporting solutions from the Trust's data warehouse and the EPR data repository, and lead on discrete areas of work which evolve the reporting estate into one which is optimised for BI, consistent in its measures and definitions, and straightforward to maintain and update.
Work seamlessly with the BI business partners, data management team, and liaise directly with report area subject matter experts in clinical and operational teams, to confirm business rules and ensure the reporting layer is designed to meet internal and external reporting requirements, implementing well-defined business logic and ensuring solutions are designed to support an efficient data environment, automated for efficiency, time saving for stakeholders, and enable self-service.
To use sophisticated analysis techniques and performance management to monitor and report on progress against targets and identify where improvements in the effective and efficient delivery of services can take place.
Strategic & Operational Support
To develop solutions which support the strategic and operational BI support function and cycle for the clinical and corporate divisions, contributing alongside Business Intelligence Partners and the wider BI team to a value-added, forward-looking and wide-ranging BI service.
To support the Head of Business Intelligence Development and Head of Operational Business Intelligence in delivering Trusts Business Intelligence strategic vision to streamline activities and focus on value-added goals, implementing a real-time corporate approach to intelligence, a single version of the truth, promoting a self-service and ease of access approach to data, exploring and utilising world-class technologies.
To develop and own a part of the Business Intelligence improvement plan and work with wider BI team colleagues and staff within Divisions to maintain and implement.
What you will do
Carry out a systematic review of existing reports and dashboards, working with report area subject matter experts in clinical and operational teams to determine what should be retained, updated to incorporate EPR data, consolidated, or decommissioned as part of the transition to EPR.
Liaise directly with clinical and operational stakeholders to confirm business rules and agree reporting requirements, ensuring reporting solutions meet internal and external reporting needs.
Develop, design and deliver dashboards and reporting solutions from the Trust's data warehouse and the EPR data repository, evolving the reporting estate into one that is consistent in its measures and definitions and straightforward to maintain.
Build and maintain Power BI reports and dashboards, applying best practice in data modelling, DAX and visual design to deliver intuitive, self-service reporting.
Document business rules and report specifications agreed with SMEs, ensuring sign-off is captured and traceable, and maintain a data dictionary/metadata catalogue to reduce duplicate reporting definitions.
Support the development of the wider BI team's knowledge and technical skills through documentation and knowledge-sharing.
Present reporting solutions and analytical outputs to a range of stakeholders across clinical, operational and corporate functions, clearly articulating data, methodology and insights.
This role is eligible for visa sponsorship under the UK Visas & Immigration (UKVI) Skilled Worker route however sponsorship can only be provided where applicants meet the specific requirements set by UKVI, including the relevant skill and salary thresholds (£25000), and any role-specific criteria.
Please note that if you currently work for another NHS Trust or UHSussex and you are applying to accept this position as a secondment opportunity, before applying you must seek agreement and authorisation from your current Trust/Manager. Secondments cant be agreed without this approval. If you are unable to gain approval, you should refrain from applying unless you wish to take this role as a fixed term position.
Technical Development & Data Engineering
Design, create and maintain SQL database objects including tables, views, stored procedures and functions, ensuring optimal database design principles, data integrity and performance.
Write complex, efficient SQL queries to support reporting, analysis and data extraction requirements across the Trust; proactively review and optimise existing queries and database objects to improve performance, maintainability and reliability.
Develop and maintain ETL processes to load data from multiple sources into SQL Server databases, as well as produce structured datasets in Excel/CSV formats for internal use and external submissions (including national and regional data returns).
Build, develop and maintain Power BI reports, dashboards and semantic models, utilising best practice in data modelling, DAX, Power Query and visual design to deliver intuitive, self-service reporting solutions across the Trust.
Develop and manage reporting solutions within Microsoft Fabric, including the creation and maintenance of Fabric pipelines for data ingestion, transformation and orchestration.
Review existing SSRS reports and subscriptions for migration to PowerBI to support operational and statutory reporting needs.
Reporting, Analysis & Information Delivery
Carry out a systematic review of existing reports, dashboards and their underlying code/logic - much of which has not been reviewed for some time - to determine what should be retained as-is, updated to incorporate EPR data, consolidated with other reports, or decommissioned as part of the transition to EPR.
Develop, design and deliver dashboards and reporting solutions from the Trust's data warehouse and the EPR data repository, and lead on discrete areas of work which evolve the reporting estate into one which is optimised for BI, consistent in its measures and definitions, and straightforward to maintain and update.
Work seamlessly with the BI business partners, data management team, and liaise directly with report area subject matter experts in clinical and operational teams, to confirm business rules and ensure the reporting layer is designed to meet internal and external reporting requirements, implementing well-defined business logic and ensuring solutions are designed to support an efficient data environment, automated for efficiency, time saving for stakeholders, and enable self-service.
To use sophisticated analysis techniques and performance management to monitor and report on progress against targets and identify where improvements in the effective and efficient delivery of services can take place.
Strategic & Operational Support
To develop solutions which support the strategic and operational BI support function and cycle for the clinical and corporate divisions, contributing alongside Business Intelligence Partners and the wider BI team to a value-added, forward-looking and wide-ranging BI service.
To support the Head of Business Intelligence Development and Head of Operational Business Intelligence in delivering Trusts Business Intelligence strategic vision to streamline activities and focus on value-added goals, implementing a real-time corporate approach to intelligence, a single version of the truth, promoting a self-service and ease of access approach to data, exploring and utilising world-class technologies.
To develop and own a part of the Business Intelligence improvement plan and work with wider BI team colleagues and staff within Divisions to maintain and implement.
To work with colleagues in the wider BI team to inform developments of products to deliver the BI improvement plan, reduce manual or disjointed processes, such that service is value-added and not just provision of information.
Support the transformation into an exemplar organisation based on sound business intelligence, against a rigorous Performance Framework.
Essential Skills & Experience
Expert-level SQL skills, including the ability to design and create tables, write highly efficient and complex queries, critically review and optimise existing SQL code, and develop stored procedures and functions to support reporting and data processing needs.
Strong business analysis skills, with the ability to engage effectively with report area SMEs and other stakeholders to elicit, document and agree detailed reporting requirements and specifications.
Experience developing SSIS packages for data loading, transformation and extraction, including producing datasets for national/regional submissions and internal reporting in Excel/CSV formats.
Proven expertise in Power BI, including data modelling, DAX, Power Query, report/dashboard design and deployment, with the ability to deliver enterprise-grade self-service reporting solutions.
Experience with Microsoft Fabric, including building and managing Fabric workspaces, lakehouses, dataflows and pipelines for end-to-end data orchestration and processing.
Experience developing business applications using Microsoft PowerApps to support operational processes and data capture is desirable.
Demonstrable experience in Excel for data analysis, reporting and the preparation of submission-ready datasets.
Experience of working with multiple stakeholders at all levels, translating complex data and technical concepts into accessible, actionable intelligence.
Proven ability to mentor and support colleagues within a technical BI environment.
Documentation & Knowledge Management
Ensuring each completed piece of review, consolidation or development work is accompanied by clear technical documentation for reports, datasets, ETL/data pipelines and database objects including data lineage, source-to-target mappings, transformation logic and refresh schedules so that reporting solutions are fully documented, auditable and maintainable and handed over to the BAU BI team on completion.
Maintain a data dictionary / metadata catalogue defining report measures, calculations and business rules consistently across the reporting suite, reducing the duplicate-definition problem the EPR review is meant to fix.
Document business rules and report specifications agreed with report area SMEs, ensuring sign-off is captured and traceable. Support the development of the wider BI team's knowledge and technical skills through documentation, knowledge-sharing and on-the-job coaching as pieces of work are completed and transitioned into business-as-usual.
Maintain change logs / version control for reports and underlying code as part of the review, consolidation and decommissioning process
Contribute to or maintain a testing and validation log for the parallel-running/reconciliation work during the EPR transition (documenting what was checked, by whom, against what expected outcome)
This role is eligible for visa sponsorship under the UK Visas & Immigration (UKVI) Skilled Worker route however sponsorship can only be provided where applicants meet the specific requirements set by UKVI, including the relevant skill and salary thresholds (£25000), and any role-specific criteria.
Please note that if you currently work for another NHS Trust or UHSussex and you are applying to accept this position as a secondment opportunity, before applying you must seek agreement and authorisation from your current Trust/Manager. Secondments cant be agreed without this approval. If you are unable to gain approval, you should refrain from applying unless you wish to take this role as a fixed term position.
Technical Development & Data Engineering
Design, create and maintain SQL database objects including tables, views, stored procedures and functions, ensuring optimal database design principles, data integrity and performance.
Write complex, efficient SQL queries to support reporting, analysis and data extraction requirements across the Trust; proactively review and optimise existing queries and database objects to improve performance, maintainability and reliability.
Develop and maintain ETL processes to load data from multiple sources into SQL Server databases, as well as produce structured datasets in Excel/CSV formats for internal use and external submissions (including national and regional data returns).
Build, develop and maintain Power BI reports, dashboards and semantic models, utilising best practice in data modelling, DAX, Power Query and visual design to deliver intuitive, self-service reporting solutions across the Trust.
Develop and manage reporting solutions within Microsoft Fabric, including the creation and maintenance of Fabric pipelines for data ingestion, transformation and orchestration.
Review existing SSRS reports and subscriptions for migration to PowerBI to support operational and statutory reporting needs.
Reporting, Analysis & Information Delivery
Carry out a systematic review of existing reports, dashboards and their underlying code/logic - much of which has not been reviewed for some time - to determine what should be retained as-is, updated to incorporate EPR data, consolidated with other reports, or decommissioned as part of the transition to EPR.
Develop, design and deliver dashboards and reporting solutions from the Trust's data warehouse and the EPR data repository, and lead on discrete areas of work which evolve the reporting estate into one which is optimised for BI, consistent in its measures and definitions, and straightforward to maintain and update.
Work seamlessly with the BI business partners, data management team, and liaise directly with report area subject matter experts in clinical and operational teams, to confirm business rules and ensure the reporting layer is designed to meet internal and external reporting requirements, implementing well-defined business logic and ensuring solutions are designed to support an efficient data environment, automated for efficiency, time saving for stakeholders, and enable self-service.
To use sophisticated analysis techniques and performance management to monitor and report on progress against targets and identify where improvements in the effective and efficient delivery of services can take place.
Strategic & Operational Support
To develop solutions which support the strategic and operational BI support function and cycle for the clinical and corporate divisions, contributing alongside Business Intelligence Partners and the wider BI team to a value-added, forward-looking and wide-ranging BI service.
To support the Head of Business Intelligence Development and Head of Operational Business Intelligence in delivering Trusts Business Intelligence strategic vision to streamline activities and focus on value-added goals, implementing a real-time corporate approach to intelligence, a single version of the truth, promoting a self-service and ease of access approach to data, exploring and utilising world-class technologies.
To develop and own a part of the Business Intelligence improvement plan and work with wider BI team colleagues and staff within Divisions to maintain and implement.
What success looks like
Essential criteria
- Educated to degree level or equivalent in a relevant discipline (e. g., Computer Science, Information Systems, Data Science, Mathematics, Business Analytics).
- Expert-level SQL skills -- including the ability to design and create tables, views, stored procedures and functions
- Extensive experience of designing and deploying Business Intelligence reporting solutions using Power BI, including data modelling, DAX, Power Query/M, row-level security
- Skilled in the translation of business needs and issues into logical analytical framework and clear outputs
- Experience of developing and managing solutions within Microsoft Fabric, including workspaces, lakehouses, dataflows Gen2 and semantic models.
- Experience of presenting reporting solutions and analytical outputs to a range of stakeholders across clinical, operational and corporate functions
- Experience of carrying out systematic review of complex data and reporting setup
- Experience of writing technical guidance documents for complex data and reporting setup
- Evidence of having championed diversity in previous roles (as appropriate to role)
- Evidence of having undertaken own development to improve understanding of equalities issues
Desirable criteria
- Qualification in project management
- Knowledge of PowerShell scripting for automation of BI and data tasks
- Experience with Microsoft Fabric pipelines for end-to-end data orchestration and processing.
- Knowledge of Python for data manipulation, automation or advanced analytics
- NHS experience working in a similar Business Intelligence development role
- Strong understanding of NHS data, information standards, national reporting requirements
- Evidence of Proactively keeping abreast of developments in BI technologies, NHS data strategy (including the NHS Federated Data Platform), data governance and best practice in healthcare
Benefits
- Flexible working,
Essential skills
Essential: Data Modelling
Essential: DAX
Essential: Microsoft Fabric
Essential: Power BI
Essential: Power Query
Essential: SQL
Essential: Stored Procedures
Desirable skills
Desirable: Data Governance
Desirable: PowerShell
Desirable: Project Management
Desirable: Python
Mentioned skills
Mentioned: Business Analysis
Mentioned: Data Analysis
Mentioned: Data Engineering
Mentioned: Data Pipelines
Mentioned: Data Processing
Mentioned: Data Warehousing
Mentioned: Database Design
Mentioned: Electronic Patient Records
Mentioned: ETL
Mentioned: Google Cloud Platform
Mentioned: Microsoft Excel
Mentioned: Microsoft SQL Server
Mentioned: Organisation
Mentioned: Performance Management
Mentioned: Recruitment
Mentioned: Statutory Accounts
Mentioned: Version Control
About the company
Home & Hybrid shows the working arrangement and verification date before candidates apply to University Hospitals Sussex NHS Foundation Trust (279).
