Leave us your email address and we'll send you all the new jobs according to your preferences.
Business Intelligence Development Partner
Posted 9 hours 44 minutes ago by NHS
Permanent
Full Time
University and College Jobs
Sussex, Worthing, United Kingdom, BN111
Job Description
University Hospitals Sussex NHS Foundation Trust (279)
Business Intelligence Development Partner Closing date: 28 June 2026
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.
Main responsibilities 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.
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.
Person Specification Qualifications
Business Intelligence Development Partner Closing date: 28 June 2026
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.
Main responsibilities 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.
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.
Person Specification Qualifications
- Educated to degree level or equivalent in a relevant discipline (e.g., Computer Science, Information Systems, Data Science, Mathematics, Business Analytics).
- Experience in complex data modelling
- Demonstrable experience in Excel for data analysis
- 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
- Experience of working within an Agile or iterative development environment
- Understanding of data governance, information governance and NHS data security standards.
- 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 analytics
NHS
Related Jobs
Consultant Medical Oncologist
- Cork, Cork, Ireland
Editor Thought Leadership
- London, United Kingdom
Laundry Assistant (Central Linen Store Royal) Liverpool University Hospitals NHS Foundation Trust
- Lancashire, Sefton, United Kingdom, L29 9
Patient Access Receptionist Manchester University NHS Foundation Trust
- Lancashire, Manchester, United Kingdom, M21 0
Locum Consultant Anaesthetist The Royal Orthopaedic Hospital NHS Foundation Trust
- Staffordshire, Birmingham, United Kingdom, B19 1