Job Description

**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

• 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

Leadership and Management

• 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.

Problem Solving

• 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.

Project Management

• 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

Most Challenging Part of the Job

• 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.

For a full comprehensive list of main responsibilities and duties, please kindly refer to job description and personal specification attached. Job description
Job responsibilities
Data Warehousing

• 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

Leadership and Management

• 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.

Problem Solving

• 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.

Project Management

• 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

Most Challenging Part of the Job

• 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.

For a full comprehensive list of main responsibilities and duties, please kindly refer to job description and personal specification attached.
Person Specification
Technical
Essential

• 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

Desirable

• 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.

Person Specification
Technical
Essential

• 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

Desirable

• 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.