Job summary
The post holder will be a key member of the Business Intelligence Team whose overarching goal is to enable, promote and support the effective use of data and information within the Trust.
The post holder will provide high level technical expertise to lead the development, design and maintenance of the trust's data warehouse and Business Intelligence applications.
Main duties of the job
Responsible for developing new datasets to enhance the existing data warehouse, which will involve developing SSIS packages, writing TSQL code, developing stored procedures/functions.
Responsible for the development of complex ETL processes and maintenance of existing ETL processes. Ensuring any system errors are investigated and resolved.
Proactively seek to 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.
Routinely horizon-scan for new and upcoming Business Intelligence and predictive analysis methodologies that may be of use to the Trust, and create documented proposals for the application of new technologies.
The post-holder will have excellent project management and planning skills and will make use of techniques such as detailed planning and issue logs to ensure that programmes of work are completed on time ensuring optimum quality.
The post holder will have organisational skills to both manage their own workload and seek to influence priorities for others within given timescales and meet key Trust targets
Please see the job description for further details
About us
The Royal Orthopaedic Hospital NHS Foundation Trust is one of the largest specialist orthopaedic units in Europe. We offer planned orthopaedic surgery to people locally, nationally and internationally.
Our Trust is a very special hospital; big enough to deliver world class services and small enough to offer exceptional patient and staff experience. We offer a working experience unique in the West Midlands and we're always on the lookout for passionate people to join our award-winning team.
The ROH is an equal opportunities employer. We employ people of difference and are committed to growing an inclusive culture, where difference is celebrated, and people feel able to bring their whole and authentic self to work.
We are a Disability Confident Leader and offer a range of inclusive, family friendly and flexible working arrangements and policies, to support our people in the workplace. Flexible working requests will be considered.
The Trust is committed to the Disability Confident Interview Scheme and will offer an interview to disabled applicants who meet the minimum criteria for a vacancy and consider them on their abilities.
If you have a disability and need any support with your application or require any reasonable adjustments to be implemented please do get in touch with the Recruiting Manager for this position so that the team can support you.
Job description
Job responsibilities
To play a key role in terms of training and support within the organisation to ensure that all areas relating to activity information and variations are understood, and that the use of information is embedded into the culture of the organisation
Perform strict quality checks and validation of the systems that form part of the data warehouse, working closely with users to ensure any data quality issues are highlighted and addressed.
Ensure all data held within the data warehouse has been quality assured and validated.
Design, code, test and implement efficient and robust database schemas plus SQL Queries, Views, Stored Procedures, and Triggers as part of Business Intelligence development
Updating, repairing, modifying and developing existing and new applications
Lead in design, development and implementation of new information feeds, ETL processes and data marts required by the Information Department to support the Trusts activities.
Support the Trusts Information Manager and Data Warehouse Manager in the development and delivery of a new range of operational reports and performance dashboards, providing performance management and decision-making information to staff across the Trust
Advise and participate in the implementation of projects relating to new or replacement clinical/operational systems. Ensuring informatics provision of integrated solutions and user objectives are achieved.
Support the activities of project boards and project teams and making presentations to all levels of staff.
Assist in the procurement, implementation and support of new systems which may be required to deliver information to managers and clinicians.
Ensure any project management documentation or reports are delivered in line with agreed standards and timescales.
Be able to balance and prioritise conflicting deadlines from current development projects and deal with ad hoc requests.
Be able to deal immediately with complex systems issues whilst meeting deadlines of routine work
Be able to take corrective action regarding systems maintenance as required on a daily basis
Fully document all reports and systems developed
Provide support or project management for implementation of NHS Information Standards Notices (ISNs), as required.
Lead on specific Information Governance Standards compliance as directed.
Promote a wider understanding of data quality and its implications throughout the Trust.
Be aware of and promote national and local policies, issues, and initiatives relating to data collected and stored by the Trust.
Ensure that the data is maintained in line with national definitions as laid down in the NHS Data Manual and Data Dictionary, with necessary updates for Information Standards Notices (ISNs). Ensure the data warehouse reference tables match the NHS data dictionary.
Support and train analysts on the data warehouse system architecture and data structure.
Provide training on NHS Standards and Data Dictionary.
MANAGING RELATIONSHIPS:
The key internal relationships will be
- Head of Business Intelligence and Data Quality
- Chief Information Officer
- Senior Management Team
- Chief Clinical Information Officer
- Divisional Managers and Service Managers
- IM&T Programme Board members
- Other senior clinicians
- Other Trust clinical and administrative staff.
External:
- Partner organisations and neighbouring NHS Trusts
- Other NHS organisations
- NHS England
- The Health and Social Care Information Centre and other relevant external bodies
- Other external forums and professional associations related to Health Informatics.
This is not an exhaustive list of duties and a regular review will take place with the post holder as part of their ongoing development and performance management.
Job description
Job responsibilities
To play a key role in terms of training and support within the organisation to ensure that all areas relating to activity information and variations are understood, and that the use of information is embedded into the culture of the organisation
Perform strict quality checks and validation of the systems that form part of the data warehouse, working closely with users to ensure any data quality issues are highlighted and addressed.
Ensure all data held within the data warehouse has been quality assured and validated.
Design, code, test and implement efficient and robust database schemas plus SQL Queries, Views, Stored Procedures, and Triggers as part of Business Intelligence development
Updating, repairing, modifying and developing existing and new applications
Lead in design, development and implementation of new information feeds, ETL processes and data marts required by the Information Department to support the Trusts activities.
Support the Trusts Information Manager and Data Warehouse Manager in the development and delivery of a new range of operational reports and performance dashboards, providing performance management and decision-making information to staff across the Trust
Advise and participate in the implementation of projects relating to new or replacement clinical/operational systems. Ensuring informatics provision of integrated solutions and user objectives are achieved.
Support the activities of project boards and project teams and making presentations to all levels of staff.
Assist in the procurement, implementation and support of new systems which may be required to deliver information to managers and clinicians.
Ensure any project management documentation or reports are delivered in line with agreed standards and timescales.
Be able to balance and prioritise conflicting deadlines from current development projects and deal with ad hoc requests.
Be able to deal immediately with complex systems issues whilst meeting deadlines of routine work
Be able to take corrective action regarding systems maintenance as required on a daily basis
Fully document all reports and systems developed
Provide support or project management for implementation of NHS Information Standards Notices (ISNs), as required.
Lead on specific Information Governance Standards compliance as directed.
Promote a wider understanding of data quality and its implications throughout the Trust.
Be aware of and promote national and local policies, issues, and initiatives relating to data collected and stored by the Trust.
Ensure that the data is maintained in line with national definitions as laid down in the NHS Data Manual and Data Dictionary, with necessary updates for Information Standards Notices (ISNs). Ensure the data warehouse reference tables match the NHS data dictionary.
Support and train analysts on the data warehouse system architecture and data structure.
Provide training on NHS Standards and Data Dictionary.
MANAGING RELATIONSHIPS:
The key internal relationships will be
- Head of Business Intelligence and Data Quality
- Chief Information Officer
- Senior Management Team
- Chief Clinical Information Officer
- Divisional Managers and Service Managers
- IM&T Programme Board members
- Other senior clinicians
- Other Trust clinical and administrative staff.
External:
- Partner organisations and neighbouring NHS Trusts
- Other NHS organisations
- NHS England
- The Health and Social Care Information Centre and other relevant external bodies
- Other external forums and professional associations related to Health Informatics.
This is not an exhaustive list of duties and a regular review will take place with the post holder as part of their ongoing development and performance management.
Person Specification
Qualifications
Essential
- Educated to degree level in relevant subject area or equivalent level of experience working at a similar level in specialist area
- Evidence of continuing professional development
Experience
Essential
- Experience in an information developer role
- Experience of using MS SQL Server
- Experience in extracting data from clinical systems/producing NHS Datasets
Desirable
- HL7 interface engine management/maintenance experience
- Experience of processing and developing data interchanges using XML
Experience
Essential
- Specialist and comprehensive knowledge and experience of the Microsoft BI Stack (SSMS/SSRS/SSAS/SSIS)
- Specialist knowledge and experience of developing and implementing Business Intelligence solutions
- Specialist knowledge and experience of dealing with data integration issues and tool
- Understanding of data warehousing techniques (e.g. Kimball methodology)
Skills
Essential
- Excellent communication and interpersonal skills with evidence of persuasive and motivational skills.
- Able to communicate and present highly complex information on a range of levels
- Good people management skills, with the ability not only to manage and prioritise their own workload but also to be able to manage other staff and their workload in times of high pressure
- Ability to work to regular, tight deadlines and to re-prioritise when necessary
- Able to cope with uncertainty and change in a busy environment
- Ability to work under pressure and produce high quality work to tight deadlines
- Ability to work on own initiative.
Desirable
- Knowledge of ASP.NET MVC, Winforms, C#, Javascript (JQuery/AngularJS)
- Knowledge of NHS data definitions and information standards
- Experience of project principles techniques and tools such as Prince 2 and Managing Successful Projects
Personal Qualities
Essential
- Effective Communicator with personnel at all levels of organisation
- Pro-active and self-motivated in completing work to a high standard
- Outgoing, sociable resilient character
- Problem solver
- Lateral thinker
- Attentive to detail
Person Specification
Qualifications
Essential
- Educated to degree level in relevant subject area or equivalent level of experience working at a similar level in specialist area
- Evidence of continuing professional development
Experience
Essential
- Experience in an information developer role
- Experience of using MS SQL Server
- Experience in extracting data from clinical systems/producing NHS Datasets
Desirable
- HL7 interface engine management/maintenance experience
- Experience of processing and developing data interchanges using XML
Experience
Essential
- Specialist and comprehensive knowledge and experience of the Microsoft BI Stack (SSMS/SSRS/SSAS/SSIS)
- Specialist knowledge and experience of developing and implementing Business Intelligence solutions
- Specialist knowledge and experience of dealing with data integration issues and tool
- Understanding of data warehousing techniques (e.g. Kimball methodology)
Skills
Essential
- Excellent communication and interpersonal skills with evidence of persuasive and motivational skills.
- Able to communicate and present highly complex information on a range of levels
- Good people management skills, with the ability not only to manage and prioritise their own workload but also to be able to manage other staff and their workload in times of high pressure
- Ability to work to regular, tight deadlines and to re-prioritise when necessary
- Able to cope with uncertainty and change in a busy environment
- Ability to work under pressure and produce high quality work to tight deadlines
- Ability to work on own initiative.
Desirable
- Knowledge of ASP.NET MVC, Winforms, C#, Javascript (JQuery/AngularJS)
- Knowledge of NHS data definitions and information standards
- Experience of project principles techniques and tools such as Prince 2 and Managing Successful Projects
Personal Qualities
Essential
- Effective Communicator with personnel at all levels of organisation
- Pro-active and self-motivated in completing work to a high standard
- Outgoing, sociable resilient character
- Problem solver
- Lateral thinker
- Attentive to detail
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).
Employer details
Employer name
The Royal Orthopaedic Hospital NHS Foundation Trust
Address
The Royal Orthopaedic Hospital NHS Foundation Trust
Bristol Road South
Northfield
B31 2AP
Employer's website
https://www.roh.nhs.uk/ (Opens in a new tab)
