University Hospitals Sussex NHS Foundation Trust
Business Intelligence Developer
Get notified of more jobs like this · No spam, ever
How your CV stacks up
Upload your CV to see how well it fits this job role
?%
Business Intelligence Developer
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 the technical review of our existing reporting suite — including SQL databases, ETL processes, Power BI reports and Microsoft Fabric pipelines — ensuring queries and data infrastructure are optimised for performance, data quality and maintainability as we transition. You'll work closely with the key stakeholders and data management team to review, consolidate, update or decommission reports and underlying code, removing duplication and ensuring consistency across the reporting estate.
We're looking for someone with expert-level SQL skills, strong experience across the Microsoft BI stack (Power BI, SSRS, SSIS, Microsoft Fabric), and a good understanding of ETL and data warehouse design, ideally within an NHS or large complex organisation.
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
Main Duties Of The Job
- Design, create and maintain SQL database objects (tables, views, stored procedures, functions), ensuring optimal database design, data integrity and performance.
- Write and optimise complex SQL queries to support reporting, analysis and data extraction across the Trust.
- Develop and maintain ETL processes to load data from multiple sources, including preparing datasets for national and regional submissions.
- Build and maintain Power BI reports, dashboards and semantic models, and develop reporting solutions within Microsoft Fabric, including Fabric pipelines for data ingestion, transformation and orchestration.
- Carry out a systematic technical review of existing reports and underlying code/logic to determine what should be retained, updated to incorporate EPR data, consolidated, or decommissioned as part of the transition to EPR.
- Review existing SSRS reports and subscriptions for migration to Power BI.
- Ensure each piece of work is accompanied by clear technical documentation (data lineage, source-to-target mappings, transformation logic, refresh schedules) and handed over to the BAU BI team on completion.
- Work collaboratively with the data management team and wider BI colleagues to ensure the reporting estate is consistent, efficient and easy to maintain and update.
Get help with your application
Your very own career expert that helps elevate your application to the next level.
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
For further details / informal visits contact:
- Name: Sanjay Sachdev
- Job title: Head of Business Intelligence Development
- Email address: sanjay.sachdev3@nhs.net
- Telephone number: 01903 205 111
If you would like to discuss the role or learn more about the team and the department, send me an email to arrange for a brief call.
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London
Skills