Applications for this job are now closed
The Royal Orthopaedic Hospital NHS Foundation Trust is a specialist hospital located in Birmingham UK. One of the largest orthopaedic units in Europe, the ROH offer a comprehensive range of surgical and non-surgical treatment.
The Royal Orthopaedic Hospital has recently been named as an Elective Surgical Hub
The accreditation is a marker of exceptional quality and has been awarded by Getting It Right First Time (GIRFT), a national programme designed to improve medical care within the NHS.
Our Trust has been named the most inclusive NHS employer for the second year in a row, taking 7th place in the Top 50 list at the Inclusive Awards on December 1, 2022.
The Inclusive Companies top 50 league table shines a light on the most inclusive employers in the UK across all strands of diversity – age, disability, gender, LGBT, race, faith, and religion.
Our Trust is a key system provider to the Birmingham and Solihull Integrated Care Board.
Our Vison, Values, and Mission are as follows
Vision
- Less pain
- More independence
- Life-changing care
Values
- Compassion, Openness,
- Pride, Innovation,
- Excellence and Respect
Mission
We will reduce pain and restore independence to help people live healthy, active, fulfilling lives.
For more details regarding the great work, we do please see the link to our website below:
https://roh.nhs.uk/
The role
Based within the Business Intelligence team which sits within the DDaT (Digital, Data and Technology) function of the trust the main purpose of this post is to have responsibility for developing new datasets to enhance the existing data warehouse, which will involve developing SSIS packages, writing TSQL code, developing stored procedures/functions.
The role will require the design, development, and implementation of new information feeds, ETL processes and data marts required by the Business Intelligence team to support the Trust’s activities.
The purpose of this role is to provide support and work across the DDaT function on the implementation of a new Electronic Patient Record liaising with a wide degree of stakeholders and building relationships within teams across the organisation.
The post holder will be a key resource in the delivery of cost-effective, risk-controlled, robust, reliable, responsive, and secure data system implementations/upgrades.
This post will support areas of the Service Improvement lifecycle including:
- Redesign
- Testing
- Documentation
- Technical implementation
- Deployment
The role will offer the candidate the opportunity to familiarise themselves with a range of health systems, datasets, and business processes to support both clinical and non-clinical staff and inform operational processes.
Alongside an Electronic Patient Record the trust is also embarking on developing its reporting estate utilising the PowerBi suite.
The role will involve a variety of tasks which could include:
- Assimilate the specifics of a process, working with Subject Matter Experts or process owners to extract a granular list of steps that describe how the process is followed today.
- The development of complex ETL processes and maintenance of existing ETL processes. Ensuring any system errors are investigated and resolved.
- Investigate and identify complex data anomalies.
- Resolving process generated data anomalies through updating system processes and communicating process/people generated data anomalies to the relevant teams.
- Ensuring all process change is identified/mapped, considered, and revised as part of Trust digital upgrades and new developments. One of the key dependencies of the EPR project will be the migration of the entire trust file data storage into a new environment which will require significant mapping and scoping to ensure its success.
- Drafting communications and liaising with relevant service leads
- Ensuring process design documentation is kept up to date.
- Ensuring a high quality of data for use in departmental reporting.
The trust currently adopts the NHS QSIR (Quality, Service, Improvement, Redesign) methodology for Service Improvement delivery so all staff within DDaT function will have opportunity to gain the QSIR Practitioner qualification.
The location
Based in the South of Birmingham the Royal Orthopaedic Hospital is situated in idyllic circumstances surrounded by Woodland with great links to public transport and into Birmingham City Centre.
The role will be based at the Royal Orthopaedic Hospital and will be situated in the main Trust HQ building and based within the Digital Transformation team.
The department currently operates a hybrid model of working consisting of a combination of on site and remote work which can be tailored to suit applicant.
The candidate
We are seeking a highly motivated candidate with a relevant degree (such as those in health, project management, business change or transformation, IT, digital technology, data or informatics) and who has a keen interest in how Health Informatics can make things better for the NHS patients and staff that we serve.
The successful candidate will role model our organisations values and behaviours by displaying the trusts values - Compassion, Openness, Pride, Innovation, Excellence and Respect.
They will have exceptional attention to detail, promoting high standards in all that they do and be adaptable and flexible in meeting the fast-paced challenges that the Business Intelligence Portfolio entails.
Previous experience in a similar role within health or the wider public sector environment would be an advantage but not essential.
Skills and experience
- Demonstrable experience of working within a business intelligence role.
- Experience of working in a process development cycle, including design, development, and testing.
- Knowledge of ASP.NET MVC, WinForms, C#, JavaScript (jQuery/AngularJS).
- Knowledge and experience of the Microsoft BI Stack:
- SQL Server 2014 and above (R2),
- SQL Server Integration Services (SSIS),
- SQL Server Analysis Services (SSAS),
- SQL Server Reporting Services (SSRS).
- Proven IT and mathematical skills. You have proven IT and mathematical skills, demonstrated through relevant qualifications or work experience.
- An Understanding of data warehousing techniques e.g., Kimball methodology.
- Understanding and experience of adhering to Information Governance principles when dealing with Patient Identifiable Data.
- Quality assurance, validation, and data linkage abilities. You know how to conduct data quality assurance, validation, and linkage between datasets.
- Communication skills. Ability to make complex and technical information and language simple and accessible for non-technical audiences.
The NHS Graduates into Health Digital, Data, Technology Scheme (DDaT) is a highly focused development pathway for graduates to become the next NHS digital, data and technology middle managers and beyond. Alongside their new role, graduates will complete an apprenticeship relevant to the role they are undertaking and integral Continual Professional Development (CPD) training. During the scheme, graduates will attend progress reviews as well as having the opportunity to work with a mentor.
If you are interested in the opportunity then click the apply button, follow the prompts and upload you CV and a Cover Letter of no more than 1000 words, detailing what skills and experience you can bring to the role.
