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.
Candidate Pack
Technical Development & Data Engineering
Design, create and maintain SQL database objects including tables, views, stored procedures and functions, ensuring optimal design principles, data integrity and performance. Write complex, efficient SQL queries to support reporting, analysis and data extraction, proactively reviewing and optimising existing objects to improve performance, maintainability and reliability.
Develop and maintain ETL processes to load data from multiple sources into SQL Server databases, producing structured datasets in Excel and 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 using best practice in data modelling, DAX, Power Query and visual design to deliver intuitive, self-service reporting solutions. Develop and manage Microsoft Fabric pipelines for data ingestion, transformation and orchestration.
Design and maintain SSRS reports and subscriptions for operational and statutory reporting needs. Develop PowerApps business applications to digitise processes and enhance workflow efficiency across clinical and corporate teams.
Desirable: Utilise Python and other tools for data manipulation, automation and advanced analytics, contributing to the evolution of the Trust's analytical capabilities. Utilise PowerShell scripting to automate administrative tasks and data processes. Support NHS Federated Data Platform pipeline integration where applicable.
Reporting, Analysis & Information Delivery
Lead on the development and delivery of dashboards and reporting solutions from the Trust's data warehouse, taking ownership of work that evolves the warehouse into one optimised for business intelligence. Work with the data management team to ensure the reporting layer meets internal and external requirements, implementing well-defined business logic and enabling automated, self-service access to intelligence.
Apply sophisticated analysis techniques and performance management to monitor progress against targets, identifying service improvement opportunities. Use statistical methods, trend analysis and benchmarking against national comparators to provide meaningful, contextualised intelligence supporting evidence-based decision making.
Develop and deliver performance monitoring dashboards against national and local standards using Power BI, SSRS, Microsoft Fabric and other reporting tools, ensuring outputs are accurate, accessible and actionable.
Strategic & Operational Support
Develop solutions supporting the strategic and operational BI function across clinical and corporate divisions, ensuring all Business Intelligence Partners contribute to a value-added, forward-looking service designed with longevity, scalability and usability in mind.
Support the Head of Business Intelligence Development in delivering the BI strategic vision — streamlining activities, implementing a real-time corporate approach to intelligence, establishing a single version of the truth and promoting self-service access to data through world-class technologies.
Take ownership of a defined area of the BI improvement plan, working with colleagues across the team and department to maintain and implement agreed developments. Collaborate to reduce manual or disjointed processes, ensuring the service remains value-added. Support the Trust's transformation into an exemplar organisation underpinned by sound business intelligence and a rigorous Performance Framework.
Maintain and develop dynamic activity, demand and capacity models to support short- and long-term identification of service needs, working with divisional management teams and corporate business partners to triangulate with finance and workforce implications.
Support the Project Management Office by performance tracking for specific programmes, developing automated reporting solutions to reduce manual overhead.
Leadership & Stakeholder Engagement
Represent the Business Intelligence department at internal and external meetings, supporting the Trust's corporate and clinical strategy. Attend Monthly Performance Reviews, Divisional Quality Committees and Service Delivery Reviews to drive quality improvements in patient care and operational delivery, proactively highlighting data quality issues and emerging trends.
Establish strong working relationships with clinical staff, leaders, divisional management teams and external stakeholders, promoting joint working with health economy partners. Act as a trusted advisor on data, reporting and business intelligence matters. Deputise for the Head of Business Intelligence Development as required.
Communication
Work with senior staff across clinical and corporate divisions to ensure portfolio areas are communicated effectively, advising on risk, dependencies and areas requiring consideration. Ensure divisions have the intelligence, advice and guidance needed to monitor and act upon performance proactively.
Present reporting solutions and analytical outputs to a wide range of stakeholders, clearly articulating data, methodology and actionable insights. Translate complex technical concepts into accessible language, ensuring understanding and confidence in the intelligence provided at all levels of the organisation.
Service Delivery and Improvement
Provide an expert BI development and reporting service to support a performance-focused culture in line with the Trust's Patient First approach, ensuring safety, quality and excellent patient care are consistently supported through robust reporting solutions and high-quality analytical interpretation.
Lead on the timely and accurate delivery of BI developments supporting the Trust's True North objectives, monitoring progress against targets and ensuring developments are delivered to agreed timescales and quality standards, escalating risks promptly.
Exercise sound judgement in analysing complex issues, providing realistic improvement options linked to actual operational challenges — for example, analysing speciality-level performance against 18-week pathways and building reporting tools to enable ongoing monitoring.
Provide specialist training and knowledge transfer on SQL, Power BI, SSRS, SSIS, Microsoft Fabric and PowerApps, ensuring knowledge is shared effectively and colleagues are supported in developing their technical capabilities.
People Management and Development
Support the development of BI Development Managers and junior staff, providing technical guidance, mentorship and constructive feedback. Support other BI teams in learning best practices in data management and reporting, fostering a collaborative and knowledge-sharing culture across the wider BI function.
This job description is an outline of the role and responsibilities. From time to time, due to the needs of the service, the post-holder may be asked to flexibly undertake other duties consistent with their role and banding, including project work, internal job rotation and absence cover. The job description and person specification may be reviewed on an ongoing basis in accordance with the changing needs of the department and the organisation.
