Data Warehouse Manager & BI Business Partner

Royal National Orthopaedic Hospital NHS Trust

Data Warehouse Manager & BI Business Partner

£62785

Royal National Orthopaedic Hospital NHS Trust, Stanmore, Greater London

  • Full time
  • Permanent
  • Onsite working

Posted 1 week ago, 15 May | Get your application in now before you miss out!

Closing date: Closing date not specified

job Ref: d2a23b6b44844b3d8ad48ca0cc7443ae

Full Job Description

As Data Warehouse Manager you will be responsible and accountable for the service delivery, maintenance and 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 performance and provide the information required to 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 to bring 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 tested in 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 to interpret data, create intelligent reports and provide appropriate advice to clinical and operational teams.
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.
To embrace and promote the Trust Values and Behaviours.

Working for our organisation
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., 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., The Trust uses electronic new starter forms on Trac to collect personal details. Information collected is securely stored and used to set up the employee record on the ESR HR system.
If you are offered a role with one of the NLPSS partner trusts, as part of pre-employment checks your identity and right to work documentation will be verified remotely (in most circumstances), using a certified identity verification service provider TrustID. You will be asked to capture an image of the relevant documents as well as a "selfie" using your smartphone/tablet (if available) for facial matching. TrustID will also perform a digital address check using Trunarrative and Equifax, which is a soft check and does not leave a footprint on your credit rating. For more information, visit www.trustid.co.uk
RNOH uses identification scanning technology to confirm the authenticity of documents; all prospective employees of RNOH will have their original documents verified using this technology.

NHS AfC: Band 8a
Please note in order to progress your application, your data will be processed by our 3^rd party recruitment providers - North London Partners Shared Service, who conduct recruitment activities on behalf of Royal National Orthopaedic Hospital NHS Trust.
The Royal National Orthopaedic Hospital NHS Trust 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. The 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
+ Rated Good by the CQC
+ Two sites, one in central London and one in Stanmore - which has recently opened The Stanmore Building, a new, state-of-the-art inpatient facility
+ Our Research and Innovation Centre works closely with our main academic partner, University College London
+ Recognised as a centre of excellence, leading on national initiatives, such as the Getting It Right First Time (GIRFT) Programme
+ Further major redevelopment underway across the Stanmore site - improving and modernising our facilities to maintain our position as the UK's leading centre for orthopaedic medicine
+ In the NHS staff survey, over 90% of our staff were satisfied with the quality of care they are able to give to patients - the best result of any NHS Trust in the country
+ Our staff also indicated that they had the best experience of appraisals as compared to all other NHS Trusts.
This is a great time to join us and play a critical role in the next stage of RNOH's journey to achieving an outstanding CQC rating.
Our aim is to remain a world-leading orthopaedic hospital with the best patient care and staff experience in the NHS. To do this, we have four core values that underpin everything that we do. We use our values to help ensure that we are always focused on the things that our staff and patients believe are most important:
+ Patients first, always
+ Excellence, in all we do
+ Trust, honesty and respect, for each other
+ Equality, for all
Our annual staff survey results have been improving year on year, with our staff telling us that their experience of working at the Trust is getting better and better. They also indicate that our staff feel very loyal to the RNOH and committed to its role in providing the very best care to our complex patient group. We hope that we can welcome you to our growing team soon., The RNOH operates a Smoke-Free Policy. Smoking is not permitted on any of the Trust's premises (including the grounds that those premises are sited on) or in any Trust owned vehicle.