NHS
Senior Data Warehouse Manager
This job is now closed
Job Description
- Req#: C9230-25-0272?language=en&page=571&sort=publicationDateDesc
- Develop and maintain a robust data architecture that supports the storage, retrieval, and analysis of healthcare data within the Oracle Millennium system.
- Collaborate with cross-functional teams to design and implement ETL (Extract, Transform, Load) processes for the integration of data from various sources into the Oracle data warehouse
- Maintain regular contact with designated areas/staff members in providing support and advice to ensure that objectives are met and outcomes achieved and that these are documented and available to both staff and the line management structure.
- Effective coordination with internal and external IT teams.
- Where appropriate support the completion of investigations both patient and staff related.
- Ability to make use of appropriate information to help analyse a range of common types of problem.
- Work with the requestor of the analysis to understand the underlying question and apply own knowledge to plan the preferred approach to the analysis.
- Ensure the team's work conforms to project scope, adjusting as necessary following any authorised changes, allocating work efficiently whilst maintaining quality standards within the allocatedtimescales.
- Report progress effectively using the project management framework in use demonstrating accountability for the team's output
- The post holder must balance the conflicting priorities and demands of the organisation against the resource available.
- Produce accurate and timely information analysis in a constantly changing information environment.
- Understand how to take information analysis forward in line with the Trusts priorities and the available technologies.
- The post holder will be accountable for the accuracy of all Information produced and so, we cannot trade speed of delivery over accuracy.
- Develop and maintain a robust data architecture that supports the storage, retrieval, and analysis of healthcare data within the Oracle Millennium system.
- Collaborate with cross-functional teams to design and implement ETL (Extract, Transform, Load) processes for the integration of data from various sources into the Oracle data warehouse
- Maintain regular contact with designated areas/staff members in providing support and advice to ensure that objectives are met and outcomes achieved and that these are documented and available to both staff and the line management structure.
- Effective coordination with internal and external IT teams.
- Where appropriate support the completion of investigations both patient and staff related.
- Ability to make use of appropriate information to help analyse a range of common types of problem.
- Work with the requestor of the analysis to understand the underlying question and apply own knowledge to plan the preferred approach to the analysis.
- Ensure the team's work conforms to project scope, adjusting as necessary following any authorised changes, allocating work efficiently whilst maintaining quality standards within the allocatedtimescales.
- Report progress effectively using the project management framework in use demonstrating accountability for the team's output
- The post holder must balance the conflicting priorities and demands of the organisation against the resource available.
- Produce accurate and timely information analysis in a constantly changing information environment.
- Understand how to take information analysis forward in line with the Trusts priorities and the available technologies.
- The post holder will be accountable for the accuracy of all Information produced and so, we cannot trade speed of delivery over accuracy.
- Proven ability to lead, influence and motivate with project / resource planning experience.
- Extensive experience of SQL Database Administrator tools and utilities including advanced scripting and basic coding.
- A Masters' degree or equivalent relevant experience to achieve expert status in the use MS-SQL, SSRS and MS Excel.
- Experience of designing, coding, testing and implementation of efficient and robust database schemas.
- Ability to understand a broad range of complex information quickly and making decisions where opinions differ/no obvious solution
- Knowledge of the information needs and processes of the Clinical and Operational functions within an Acute hospital.
- Expert knowledge of the NHS Data Manual, Information Standards, data flows and statistical returns gained through at least 2 years in an NHS informatics role.
- Proven ability to lead, influence and motivate with project / resource planning experience.
- Extensive experience of SQL Database Administrator tools and utilities including advanced scripting and basic coding.
- A Masters' degree or equivalent relevant experience to achieve expert status in the use MS-SQL, SSRS and MS Excel.
- Experience of designing, coding, testing and implementation of efficient and robust database schemas.
- Ability to understand a broad range of complex information quickly and making decisions where opinions differ/no obvious solution
- Knowledge of the information needs and processes of the Clinical and Operational functions within an Acute hospital.
- Expert knowledge of the NHS Data Manual, Information Standards, data flows and statistical returns gained through at least 2 years in an NHS informatics role.
Job summary
Senior Data Warehouse Manager
37.5 hours per week
Fixed term for 15 months
Salary: £53,755 - £60,504 per annum
Closing Date: 1st August 2025
Interview Date: TBC
**This post may close early due to high numbers of applications, so you are advised to apply promptly. **
All correspondence for this vacancy will be sent by email; please check your account regularly including your Junk and SPAM areas.
A great and friendly place to work, so bring your passion, commitment and expertise and enjoy the opportunities to make a difference every day.
We welcome applications from the Armed Forces Community - get in touch to find out more
#JoinTeamEliot
Main duties of the job
We are seeking a highly skilled and motivated Information and Data Warehouse Specialist to join our Oracle Millennium Implementation team. In this critical role, you will be responsible for designing, implementing, and maintaining information and data warehousing solutions that are essential to the successful deployment of Oracle Millennium EPR systems. Your expertise in data architecture, ETL processes, and data analytics will be instrumental in ensuring the seamless integration of Cerner solutions with our healthcare operations.
About us
Here at George Eliot our vision to' excel at patient care' takes centre stage. An ever evolving clinically-led acute service provider we are on a journey to continually provide high quality, safe and responsive services delivered by inspiring, friendly and compassionate staff who share our corporate values which underpin everything we do. Our values are not just words on a piece of paper, they bond us together, reflect our ambition and shape who we are:
Effective Open Communication
excellence and safety in everything we do
Challenge but support
Expect respect and dignity
Local health that inspires confidence
Benefits: On-site nursery, 27 days minimum annual leave plus bank holidays, cycle to work scheme, flexible working, in house training and development, buying and selling of annual leave, subsidised restaurant, tranquillity garden and generous subsidised on-site parking.
If you are applying for a Domestic Assistant or Health Care Assistant role you may be eligible for the refer a friend scheme - find out more here: https://www.geh.nhs.uk/about-us/people-and-workforce/vacancies/refer-friend-scheme
Details
Date posted
11 July 2025
Pay scheme
Agenda for change
Band
Band 8a
Salary
£53,755 to £60,504 a year per annum
Contract
Fixed term
Duration
15 months
Working pattern
Full-time
Reference number
230-52383862-EPR-C
Job locations
George Eliot Hospital
College Street
Nuneaton
CV10 7DJ
Job description
Job responsibilities
Data Warehousing
Leadership and Management
Problem Solving
Project Management
Most Challenging Part of the Job
For a full comprehensive list of main responsibilities and duties, please kindly refer to job description and personal specification attached.
Job responsibilities
Data Warehousing
Leadership and Management
Problem Solving
Project Management
Most Challenging Part of the Job
For a full comprehensive list of main responsibilities and duties, please kindly refer to job description and personal specification attached.
Person Specification
Technical
Essential
Desirable
Technical
Essential
Desirable
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.
Certificate of Sponsorship
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).
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.
Certificate of Sponsorship
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
George Eliot Hospital NHS Trust
Address
George Eliot Hospital
College Street
Nuneaton
CV10 7DJ
Employer's website
http://www.geh.nhs.uk/ (Opens in a new tab)
Employer details
Employer name
George Eliot Hospital NHS Trust
Address
George Eliot Hospital
College Street
Nuneaton
CV10 7DJ
Employer's website
http://www.geh.nhs.uk/ (Opens in a new tab)
About the company
National Health Service (NHS) is the umbrella term for the publicly-funded healthcare systems of the United Kingdom (UK). The founding principles were that services should be comprehensive, universal and free at the point of delivery—a health service based on clinical need, not ability to pay. Each service provides a comprehensive range of health services, free at the point of use for people ordinarily resident in the United Kingdom apart from dental treatment and optical care.
Notice
Talentify is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or protected veteran status.
Talentify provides reasonable accommodations to qualified applicants with disabilities, including disabled veterans. Request assistance at accessibility@talentify.io or 407-000-0000.
Federal law requires every new hire to complete Form I-9 and present proof of identity and U.S. work eligibility.
An Automated Employment Decision Tool (AEDT) will score your job-related skills and responses. Bias-audit & data-use details: www.talentify.io/bias-audit-report. NYC applicants may request an alternative process or accommodation at aedt@talentify.io or 407-000-0000.