Data Warehouse Manager & BI Business Partner | Royal National Orthopaedic Hospital NHS Trust
| Posting date: | 13 May 2024 |
|---|---|
| Salary: | Not specified |
| Additional salary information: | £56,388 - £62,785 per annum Inclusive of HCAS |
| Hours: | Full time |
| Closing date: | 12 June 2024 |
| Location: | Stanmore, HA7 4LP |
| Company: | Royal National Orthopaedic Hospital NHS Trust |
| Job type: | Permanent |
| Job reference: | 6282602/392-RNOH-851 |
Summary
Data Warehouse Manager & BI Business Partner
As Data Warehouse Manager you will beresponsible and accountable for the service delivery,maintenanceand continual improvement of a fit for purpose complex Data Warehouse.
You will be responsible for the maintenance and development of the Trust's Commissioning processes.
Responsible for the maintenance and development of a number of reports and dashboards, requiring advanced QlikView skills.
Business intelligence and analytics is pivotal to the delivery of high-quality efficient healthcare provision. The Business Intelligence Team provides analysis and insights to support the Trust in using information to support effective decision making, ensuring that they make the best use of resources, understand performanceand provide the informationrequiredto enable them to focus on areas of greatest opportunity.
This role will offer opportunities to set the standards and lead on the use of data and information throughout the Trust in order tobring business intelligence and data analytics to the forefront of shaping patient care.
As Business Intelligence partner you will work directly alongside the leadership teams for their assigned area. They will play a key role in visualising and analysing data in a meaningful and insightful way to ensure data is at the heart of all decision making, enabling better outcomes that make a real difference to people.
Responsible and accountable for the service delivery, maintenance and continual improvement of a fit for purpose complex Data Warehouse.
Responsible for the weekly/bi-monthly processes to produce invoicing files for the Commissioning Team and SUS files for submission. Work closely with the Commissioning Team to incorporate any charging and billing changes into the Monitoring Process. Ensure the annual updates to HRGs and Tariffs are applied and testedin a timely manner. Responsible for data quality of SUS submissions.
Act as a specialist resource to deliver analysis using business intelligence tools (primarily QlikView and Qlik Sense) in order tointerpret data, createintelligent reports and provideappropriate adviceto clinical and operational teams.
Work directly with Division to gather requirements, prioritise work packages and then design, developand implement resultant Business Intelligence Solutions. Providing users with seamless access to information to support service delivery,improvementand management.
To embrace and promote the Trust Values and Behaviours.
RNOH Royal National Orthopaedic Hospital NHS Trust (RNOH) is the largest orthopaedic hospital in the UK and a global leader in our field. We provide a dynamic working environment where we support frontline staff to implement improvements so that we can realise our vision of being a world leading neuro-musculoskeletal hospital providing the best patient care and staff experience in the NHS, delivering world leading research, and offering a strong foundation of education, training and career progression. Our dedicated staff come from diverse backgrounds, and our patients benefit from the wide range of experience they bring to the trust. RNOH brings unrivalled expertise together in one place allowing us to deliver some of the world’s most complex and innovative care to our patients.
Job Purpose
Business intelligence and analytics is pivotal to the delivery of high-quality efficient healthcare provision. The Business Intelligence Team provides analysis and insights to support the Trust in using information to support effective decision making, ensuring that they make the best use of resources, understand performance and provide the information required to enable them to focus on areas of greatest opportunity.
The Business Intelligence partner will be allocated to one of 3 areas within the Trust and will work directly alongside the Divisional/Unit leadership teams. They will play a key role in visualising and analysing data in a meaningful and insightful way to ensure data is at the heart of all decision making, enabling better outcomes that make a real difference to people.
They will be the first point of contact for their Division/Unit for all BI requirements, receiving all requests and managing through to delivery.
The post-holder will have a high degree of autonomy within their area of responsibility working with their division to prioritise work requests within available resources.
The post-holder will have excellent customer service skills and exhibit a can-do attitude.
This role will offer opportunities to set the standards and lead on the use of data and information throughout the Trust in order to bring business intelligence and data analytics to the forefront of shaping patient care. They will be responsible for developing forecasting capability through predictive analytics.
The post-holder will be expected to provide cross-cover for other BI teams as required.
This is a new post and post-holders are expected to be flexible in their approach to the needs of the service.
Main Duties and Responsibilities
· Work directly with Division to gather requirements, prioritise work packages and then design, develop and implement resultant Business Intelligence Solutions. Providing users with seamless access to information to support service delivery, improvement and management.
· Responsible and accountable for the service delivery, maintenance and continual improvement of a fit for purpose complex Data Warehouse.
· Develop/update interfaces between systems as required, ensure interfaces to and feeds from all systems are maintained at all times.
· Manage the integrity of the systems by monitoring the performance of the network and the database software, and by monitoring data entry, devising rigorous error trapping techniques and running regular data quality reports.
· Upgrade systems when required, including testing of the databases and the interface(s).
· Ensure appropriate technical documentation is created and maintained using change control processes.
· Responsible for the weekly/bi-monthly processes to produce invoicing files for the Commissioning Team and SUS files for submission.
· Work closely with the Commissioning Team to incorporate any charging and billing changes into the Monitoring Process.
· Ensure the annual updates to HRGs and Tariffs are applied and tested in a timely manner.
· Responsible for data quality of SUS submissions.
· Continually develop the information and business intelligence provision, working closely with their Divisional leadership to capture key business requirements and foster an intelligence lead culture.
· Engaging with multiple stakeholders;responsible for the development, preparation and maintenance of high quality, timely and accurate intelligence provision and analytical services to ensure managers, clinicians and operational staff have the information required to deliver a high quality, safe, patient focused service.
· Lead/Develop toolkits, reports and dashboards that directly address Divisional and wider organisational requirements to provide evidence based information that enable hindsight, insights and foresight.
· Supporting the operational and strategic decision-making process through the provision of focused business intelligence, including, providing leadership on capacity planning and modelling to support service developments and performance objectives.
· Working pro-actively to ensure the Trust is aware of the impact on information through business developments and process changes whilst conversely ensuring that operational leaders are fully aware of changes and developments in information systems, policies, and software.
Please see the Job Description and the Persons Specification for further details about the job role.
This advert closes on Monday 27 May 2024
Proud member of the Disability Confident employer scheme
Disability Confident
About Disability Confident
A Disability Confident employer will generally offer an interview to any applicant that declares they have a disability and meets the minimum criteria for the job as defined by the employer. It is important to note that in certain recruitment situations such as high-volume, seasonal and high-peak times, the employer may wish to limit the overall numbers of interviews offered to both disabled people and non-disabled people. For more details please go to Disability Confident.