Senior Data Warehouse Manager

Integrated Care System; Nuneaton; On-site; GBP 40,000 - 55,000; Full time

Job summary

An exciting opportunity for an Information and Data Warehouse Specialist is available at a leading healthcare provider, essential for implementing and maintaining Oracle Millennium systems. Candidates should have expertise in data architecture and ETL processes with a strong focus on data analytics to enhance healthcare operations. This role promises to contribute significantly to improving patient care through effective data management.

Benefits

On-site nursery

27 days minimum annual leave plus bank holidays

Cycle to work scheme

Flexible working arrangements

In-house training and development

Subsidised restaurant

Generous subsidised on-site parking

Qualifications

• Extensive experience with SQL Database Administration and scripting.
• Expert knowledge in NHS Data Manual and Information Standards.
• Ability to deliver accurate analysis under changing conditions.

Responsibilities

• Develop and maintain data architecture within Oracle Millennium system.
• Design and implement ETL processes for data integration.
• Ensure project work meets quality standards and timelines.

Skills

Data architecture

ETL processes

Data analytics

Problem Solving

Education

Masters' degree or equivalent

Tools

MS-SQL

SSRS

MS Excel

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

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

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

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

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.