An exciting opportunity to join our Business Intelligence Development Team as a key technical specialist, driving the future of data-driven decision making across the Trust.
As Business Intelligence Development Partner, you will drive the development of sophisticated reporting infrastructure and data solutions supporting our Patient First objectives. Working with clinical and corporate divisions, you will leverage technologies including Power BI, Microsoft Fabric, SQL Server, SSIS, SSRS and PowerApps to deliver enterprise-grade reporting and analytics.
Central to this role is your responsibility to critically evaluate, improve and maintain the Trust's data repositories, information flows and data architecture, ensuring reporting is built on a robust foundation. You will design and optimise SQL databases, develop ETL processes, create intuitive dashboards and build PowerApps/Power Automate solutions that reduce manual effort and enable self-service intelligence.
As an expert SQL developer and Power BI specialist, you will write efficient queries, build semantic models, develop ETL processes and work with Microsoft Fabric to create modern data pipelines. You will provide technical expertise within the BI development team, directly support the Head of BI Development and engage with key stakeholders.
This is an advanced, hands‑on technical role perfect for an experienced NHS BI professional who wants to impact the future of healthcare intelligence.
Technical Development & Data Engineering
Design, create and maintain SQL database objects including tables, views, stored procedures and functions, ensuring data integrity and performance. Write complex SQL queries to support reporting and analysis, proactively optimising existing objects for reliability and maintainability.
Develop and maintain ETL processes to load data from multiple sources into SQL database. Build and maintain Power BI reports, dashboards and semantic models using DAX, Power Query and best practice design. Develop Microsoft Fabric pipelines for data ingestion and orchestration, PowerApps solutions to digitise workflows.
Reporting, Analysis & Information Delivery
Lead dashboard and reporting development from the Trust's data warehouse, implementing business logic and enabling self-service access.
Strategic & Operational Support
Develop solutions supporting the strategic BI function across divisions. Support the Head of BI Development in delivering the BI vision — real‑time intelligence, a single version of the truth and self‑service data access. Own part of the BI improvement plan, reducing manual processes and ensuring value‑added service delivery.
Leadership & Stakeholder Engagement
Represent BI at internal and external meetings. Attend Performance Reviews and Divisional committees to drive quality improvements. Build strong stakeholder relationships and deputise for the Head of BI Development as required.
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.
#J-18808-Ljbffr