Job summary
We have embarked on a programme to implement a single Electronic Patient Record (EPR) as part of the NHS digital health ongoing initiative across the Norfolk and Waveney Acute Hospital Collaborative (NWAHC). The collaborative is made up of three acute hospitals in Norfolk and Waveney;
James Paget University Hospitals NHS Foundation Trust (JPUH)
Norfolk and Norwich University Hospitals NHS Foundation Trust (NNUH)
The Queen Elizabeth Hospital King's Lynn NHS Foundation Trust (QEH)
This is a unique opportunity to contribute your skills and expertise to create a meaningful impact on the health and well-being of individuals throughout Norfolk and Waveney. We are dedicated to advancing our digital capabilities in alignment with our long-term strategic goals, ensuring a high standard of patient care and safety for our diverse communities.
The acute hospitals in Norfolk are a vital part of the health and social care system. Our digital mission is an essential part of our transformation into a post-modern healthcare system.
Main duties of the job
The Data Warehouse Project Manager is responsible for the delivery of the Meditech data warehouse strategy, development and management within the EPR Core Informatics team and manages the team of developers, leading them in the analysis, requirements, design, development, testing, enhancement, documentation, and ongoing support of development and reporting requests. They will need to work closely with the three Trust's data warehouse and technical teams to support their continuity of reporting, taking account of their local needs when developing any plans. They will have extensive experience in data warehousing, SQL Server Management Studio and data architecture.
About us
Join us at the Norfolk and Norwich University Hospital and be part of a workforce of over 10,000 staff!
The NNUH is one of the largest NHS trusts in the UK, providing first-class acute care for around one million people, living in Norfolk and surrounding areas. We are a teaching and research hospital, at the forefront of innovation, home to state-of-the-art facilities, such as the Quadram Institute. We are pleased to work closely with the University of East Anglia, providing teaching opportunities for our staff and placement opportunities for their students. We attract some of the best and leading professionals from across the country and are proud that our workforce represents 94 countries from across the world.
We are a friendly, collaborative hospital, working with local services and home to N&N Hospitals Charity
We can offer you the full range of NHS benefits/discounts and in addition:
- Flexible working hours
- Fast Track Staff Physiotherapy Service
- Multi Faith prayer room
- Discounted gym memberships
- Excellent pension scheme and annual leave entitlement
- Wagestream - access up to 40% of your pay as you earn it
- Free Park & Ride service direct to NNUH site
- Free 24-hours confidential counselling support
- On-site Nursery
- On-site cafes offering staff discounts
- Support in career development
- Flexible staff bank
- Salary Sacrifice schemes including lease cars, Cycle to Work scheme and home electronics
Job description
Job responsibilities
- Leads the discussions with stakeholders to understand extremely complex reporting needs across multiple existing systems and sites. Applies Meditech build and design expertise to analyse current business practices to enable full documentation and provide the recommended reporting solutions.
- The role will be the lead on advice, guidance and insight into the correct application of NHS data dictionary and rules within the data warehouse environment to ensure maximum compliance within the Meditech build, data integration, data warehouse development and retention of legacy systems and associate data flows and data warehouses. Insight into the NHS, its reporting requirements and the data are therefore essential.
- This is a key team management role within the EPR Business Intelligence Team. They will work with the members of the three trusts Informatics teams, EPR team and clinical and operational management teams to ensure a consistent approach to the implementation of the trusts digital and information reporting strategy.
Job description
Job responsibilities
- Leads the discussions with stakeholders to understand extremely complex reporting needs across multiple existing systems and sites. Applies Meditech build and design expertise to analyse current business practices to enable full documentation and provide the recommended reporting solutions.
- The role will be the lead on advice, guidance and insight into the correct application of NHS data dictionary and rules within the data warehouse environment to ensure maximum compliance within the Meditech build, data integration, data warehouse development and retention of legacy systems and associate data flows and data warehouses. Insight into the NHS, its reporting requirements and the data are therefore essential.
- This is a key team management role within the EPR Business Intelligence Team. They will work with the members of the three trusts Informatics teams, EPR team and clinical and operational management teams to ensure a consistent approach to the implementation of the trusts digital and information reporting strategy.
Person Specification
Qualifications
Essential
- Degree level or equivalent experience relevant to the role.
- Postgraduate qualification (master's degree) or equivalent experience or qualification in relevant area or equivalent experience in a Health Informatics environment.
Experience
Essential
- Experience of managing, developing and recruiting staff. Extensive experience with Business Intelligence development lifecycle.
- Experience and understanding of data quality issues within the NHS and how to resolve them. Experience of managing projects including use of project plans, identifying risks and issues and mitigation plans.
- Proven experience with business and technical requirements analysis, elicitation, modelling, verification, documentation and methodology development. Evidenced experience of communicating complex issues and data concepts to a range of people.
Skills
Essential
- Expert and in-depth knowledge of data warehouse and reporting development frameworks. Expert and in-depth knowledge and experience of programming languages, SQL Server Management Studio and scripting languages.
- Ability to write advanced, complex relational and multidimensional SQL queries and complex stored procedures. Expert knowledge and understanding of mandatory reporting requirements, NHS data standards and definitions.
- Expert knowledge of the NHS Data dictionary and Model. Exceptional communication skills - written and verbal - able to identify key points from complex issues and explain them appropriately and with clarity. Advanced key board skills and VDU use.
Attitude, Aptitude
Essential
- Ability to build consensus across teams, with staff and leadership. To act in ways that support equality and diversity and the rights of individuals, ensuring own practice is in accordance with Trust policies.
- Ability to identify and embrace change in the drive towards continuous improvement. Thrives in a fast-paced environment and is adaptable to changing priorities.
- Participate in out of hours work e.g. weekends, evenings as and when required. In particular during peak periods of activity for the EPR programme e.g. key upgrades. Be responsible for, working autonomously to plan and organise own and team members' workload to meet multiple and often conflicting deadlines.
- Ability to listen and interpret users' needs and to inspire confidence. Effective role model, demonstrating NNUH's PRIDE values of People focussed, Respect, Integrity, Dedication and Excellence Demonstrates understanding and commitment to Equality, Diversity, and Inclusion
Person Specification
Qualifications
Essential
- Degree level or equivalent experience relevant to the role.
- Postgraduate qualification (master's degree) or equivalent experience or qualification in relevant area or equivalent experience in a Health Informatics environment.
Experience
Essential
- Experience of managing, developing and recruiting staff. Extensive experience with Business Intelligence development lifecycle.
- Experience and understanding of data quality issues within the NHS and how to resolve them. Experience of managing projects including use of project plans, identifying risks and issues and mitigation plans.
- Proven experience with business and technical requirements analysis, elicitation, modelling, verification, documentation and methodology development. Evidenced experience of communicating complex issues and data concepts to a range of people.
Skills
Essential
- Expert and in-depth knowledge of data warehouse and reporting development frameworks. Expert and in-depth knowledge and experience of programming languages, SQL Server Management Studio and scripting languages.
- Ability to write advanced, complex relational and multidimensional SQL queries and complex stored procedures. Expert knowledge and understanding of mandatory reporting requirements, NHS data standards and definitions.
- Expert knowledge of the NHS Data dictionary and Model. Exceptional communication skills - written and verbal - able to identify key points from complex issues and explain them appropriately and with clarity. Advanced key board skills and VDU use.
Attitude, Aptitude
Essential
- Ability to build consensus across teams, with staff and leadership. To act in ways that support equality and diversity and the rights of individuals, ensuring own practice is in accordance with Trust policies.
- Ability to identify and embrace change in the drive towards continuous improvement. Thrives in a fast-paced environment and is adaptable to changing priorities.
- Participate in out of hours work e.g. weekends, evenings as and when required. In particular during peak periods of activity for the EPR programme e.g. key upgrades. Be responsible for, working autonomously to plan and organise own and team members' workload to meet multiple and often conflicting deadlines.
- Ability to listen and interpret users' needs and to inspire confidence. Effective role model, demonstrating NNUH's PRIDE values of People focussed, Respect, Integrity, Dedication and Excellence Demonstrates understanding and commitment to Equality, Diversity, and Inclusion
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).
