Job summary
An exciting opportunity has arisen in the Business Intelligence (BI) Department at University Sussex Hospitals NHS Trust (UHSx). We are looking for a BI Development Manager to take the lead for specific areas of BI development work.
You will support the BI Department and wider organisation in the reduction of existing manual data management processes through the introduction of smarter tools and approaches. You'll also ensure these approaches and tools are used for new analytical reporting requirements as well as provide support, guidance, and training to allow other members of staff to use these as part of their day-to-day business or operations.
At the same time, you'll be acting as an ambassador for good data management and will help broker stronger relationships between the BI Department and its key stakeholders.
You'll already have experience of working with end-to-end informatics development processes, specifically relating to data tools and BI analytics. You'll be comfortable with aspects such as understanding end user requirements, the building of complex data sets, the development of analytical tools and providing training and support where you think its most necessary.
Finally, you'll be comfortable in working as part of a team and taking the lead of analytical projects where required and your proactive nature will ensure that projects run on time and key stakeholders are engaged with throughout the life cycle of the development.
Main duties of the job
To develop solutions which support the strategic and operational BI support function and cycle for the clinical and corporate divisions ensuring all Business Intelligence Managers, and wider BI team contribute to a value-added, forward-looking, and wide-ranging BI service.
To develop, design and deliver dashboards and reporting solutions from the Trust's data warehouse, and lead on discrete areas of work which evolve the data warehouse into one which is optimised for BI.
Work seamlessly with the data warehouse team to ensure the reporting layer is designed to meet internal and external reporting requirements.
Responsible for developing and maintaining a broad portfolio of routine and ad-hoc information, analysis and reports to internal and external stakeholders.
To lead on the development and maintenance of information databases and associated extract routines, ensuring data quality and data integrity are preserved. The Business Intelligence Development Manager will play a key role in developing the service to best meet the needs of the Trust; working closely with clinicians and managers to identify their information requirements and developing appropriate solutions.
The post holder has lead responsibility for a complex and diverse range of information work streams and has close working relationships with a wide range of staff.
Information and analyses provided by the post-holder will underpin decisions affecting the Trust.
About us
Join us atUHSussex, every day is different, you can be the change, better neverstops
AtUHSussexwe're proud to be at the heart of the NHS. As one of theUK's largest acute Trusts, we're a leading example of the excellence, the ambition and the values that have embodied the NHS for over 70 years.
Improving lives:We are a vibrant and inclusive organisation, with hardworking, talented and dedicated individuals, who work together towards a common goal, to always put ourPatient First.Our mission is summed up by our 'where better never stops' motto and no matter the role atUHSussex, you will play a part in driving us forwards and in improving the lives of patients across Sussex.We treat our patients and staff with the same compassion and empathy we expect for ourselves. We're here for them when they need us, and we go above and beyond to meet their needs. This can be seen in ourwellbeing programmefor staff which is extensive and designed to support you when you need itbecausewe know that to look after others we must first look after ourselves.
Build a career with us: As a university trust and a leader in healthcare research, we value learning, teaching and training so that we can be the best that we can be. From the moment you start with us and throughout your career we will help you to grow and develop. We hope that in choosing UHSussex you are choosing a long and happy career where you will be able to see the difference you make and feel valued for all that you do
Job description
Job responsibilities
Communications
- To work with all members of the BI team and other teams responsible for Performance and use of BI, e.g., Commissioning team, to ensure that all areas of Performance, trust business and use of business intelligence across the Trust are monitored effectively and consistently.
- Present the reporting solutions to a wide range of staffing as required where appropriate. Discuss any areas of concern with the relevant Divisional lead.
- Develop constructive working relationships with Divisional managements and clinical teams to ensure that a performance focused culture where safety, quality and excellent patient care are consistently delivered though the provision of high-level analytical interpretation and modelling services.
- To clearly articulate and translate the methodology and output of complex analyses to staff at all levels and in various roles within the organisation.
- To be the lead BI Development Manager for several information work streams and/or departments, attending regular meetings and working closely with divisional clinicians and managers to identify information requirements.
- To present and report performance and other highly complex information verbally and in writing, adjusting presentation styles to meet the requirements of different audiences. This will include both regular and ad-hoc reports.
- To ensure routine and regular contact with departmental managers relating to their departments performance.
- To participate in project teams and attend meetings and committees, providing expert advice on issues with an information dimension.
- To support staff in the correct use and interpretation of information and reports. This may include one to one or group training and the provision of written documentation or guidance.
- Negotiating and collaborating with colleagues in other departments e.g., I.T. and Information Governance, where appropriate.
Analytical
- To extract, manage and analyse complex data sets using SQL databases, MS Excel, Power BI, SSIS and other data analysis tools.
- To consult, assess and interpret trust, department and individuals information requirements and develop appropriate reporting solutions, undertake analyses, or provide advice as required.
- To proactively analyse trends and identify exceptions on a wide range of performance measures and to alert responsible managers when necessary.
- To forecast and model activity, demand, capacity and waiting lists and other complex information in relation to performance targets, service, and business planning.
- To develop reporting solutions using advanced functions in MS Excel e.g., SQL integration and VBA automation, Power BI or SSAS to provide better insight for information end-users.
- To lead on the development of performance indicators and other information to support service improvement at both a corporate and divisional level.
- To make use of appropriate clinical and productivity benchmarking metrics from resources such as HED and the Model Hospital to provide additional context and insight to support the delivery of planned care.
- To provide assurance on the quality of information provided through the application of routine data quality tests and checks, liaising with relevant teams where problems have been identified in the source data.
Planning
- To effectively plan and manage own workload and that of immediate reports to ensure core objectives are met while ensuring individual wellbeing is not adversely affected.
- To participate in projects to implement new or enhance existing systems and ensure continuity and integrity of critical information in the transition to these.
- To contribute to trust-wide and departmental service improvement projects, working alongside colleagues in other teams to ensure project objectives are delivered on time.
Please see Job Description and Person Specification for full details.
Job description
Job responsibilities
Communications
- To work with all members of the BI team and other teams responsible for Performance and use of BI, e.g., Commissioning team, to ensure that all areas of Performance, trust business and use of business intelligence across the Trust are monitored effectively and consistently.
- Present the reporting solutions to a wide range of staffing as required where appropriate. Discuss any areas of concern with the relevant Divisional lead.
- Develop constructive working relationships with Divisional managements and clinical teams to ensure that a performance focused culture where safety, quality and excellent patient care are consistently delivered though the provision of high-level analytical interpretation and modelling services.
- To clearly articulate and translate the methodology and output of complex analyses to staff at all levels and in various roles within the organisation.
- To be the lead BI Development Manager for several information work streams and/or departments, attending regular meetings and working closely with divisional clinicians and managers to identify information requirements.
- To present and report performance and other highly complex information verbally and in writing, adjusting presentation styles to meet the requirements of different audiences. This will include both regular and ad-hoc reports.
- To ensure routine and regular contact with departmental managers relating to their departments performance.
- To participate in project teams and attend meetings and committees, providing expert advice on issues with an information dimension.
- To support staff in the correct use and interpretation of information and reports. This may include one to one or group training and the provision of written documentation or guidance.
- Negotiating and collaborating with colleagues in other departments e.g., I.T. and Information Governance, where appropriate.
Analytical
- To extract, manage and analyse complex data sets using SQL databases, MS Excel, Power BI, SSIS and other data analysis tools.
- To consult, assess and interpret trust, department and individuals information requirements and develop appropriate reporting solutions, undertake analyses, or provide advice as required.
- To proactively analyse trends and identify exceptions on a wide range of performance measures and to alert responsible managers when necessary.
- To forecast and model activity, demand, capacity and waiting lists and other complex information in relation to performance targets, service, and business planning.
- To develop reporting solutions using advanced functions in MS Excel e.g., SQL integration and VBA automation, Power BI or SSAS to provide better insight for information end-users.
- To lead on the development of performance indicators and other information to support service improvement at both a corporate and divisional level.
- To make use of appropriate clinical and productivity benchmarking metrics from resources such as HED and the Model Hospital to provide additional context and insight to support the delivery of planned care.
- To provide assurance on the quality of information provided through the application of routine data quality tests and checks, liaising with relevant teams where problems have been identified in the source data.
Planning
- To effectively plan and manage own workload and that of immediate reports to ensure core objectives are met while ensuring individual wellbeing is not adversely affected.
- To participate in projects to implement new or enhance existing systems and ensure continuity and integrity of critical information in the transition to these.
- To contribute to trust-wide and departmental service improvement projects, working alongside colleagues in other teams to ensure project objectives are delivered on time.
Please see Job Description and Person Specification for full details.
Person Specification
Qualifications and Experience
Essential
- Qualifications and Experience
Technical Skills
Essential
Technical Experience
Essential
Proactiveness
Essential
Communication
Essential
Workload Planning
Essential
Person Specification
Qualifications and Experience
Essential
- Qualifications and Experience
Technical Skills
Essential
Technical Experience
Essential
Proactiveness
Essential
Communication
Essential
Workload Planning
Essential
Disclosure and Barring Service Check
This post is subject to the Rehabilitation of Offenders Act (Exceptions Order) 1975 and as such it will be necessary for a submission for Disclosure to be made to the Disclosure and Barring Service (formerly known as CRB) to check for any previous criminal convictions.
Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the UK Visas and Immigration website (Opens in a new tab).
From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) are also subject to this requirement. Guidance can be found here Criminal records checks for overseas applicants (Opens in a new tab).
Additional information
Disclosure and Barring Service Check
This post is subject to the Rehabilitation of Offenders Act (Exceptions Order) 1975 and as such it will be necessary for a submission for Disclosure to be made to the Disclosure and Barring Service (formerly known as CRB) to check for any previous criminal convictions.
Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the UK Visas and Immigration website (Opens in a new tab).
From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) are also subject to this requirement. Guidance can be found here Criminal records checks for overseas applicants (Opens in a new tab).
