Data Warehouse/Data Consultant - Cerner/Oracle Health

Data Pipeline Remediation

Investigate performance and reliability issues affecting data pipelines.

Diagnose failures, bottlenecks and other data processing problems.

Identify root causes rather than simply addressing symptoms.

Develop and implement remediation activities.

Monitor the effectiveness of remediation and confirm that issues have been resolved.

Identify recurring problems and recommend longer-term improvements.

Troubleshoot data extraction, transformation and loading processes.

Investigate issues across upstream and downstream data dependencies.

Work collaboratively with technical teams to resolve complex data issues.

Database Performance & DBA

A significant element of the role will involve database performance investigation and remediation.

The successful candidate will be expected to:

Analyse database performance issues.

Identify SQL queries, processes and workloads contributing to performance problems.

Undertake SQL performance tuning and optimisation.

Review execution plans and query performance.

Identify indexing and database design issues.

Investigate resource utilisation and database bottlenecks.

Review database structures and data access patterns.

Recommend and implement appropriate performance improvements.

Monitor database performance following remediation.

Apply sound DBA principles to improve reliability and performance.

Troubleshoot complex database issues independently.

The role requires someone with practical DBA knowledge and performance-tuning experience, rather than someone whose experience is limited to database development.

Cerner/Oracle Health Data

Deep practical understanding of Cerner/Oracle Health data is essential.

The successful candidate will need to understand the structure, relationships and characteristics of Cerner data and how it is consumed within an NHS data warehouse environment.

This includes:

Understanding Cerner/Oracle Health data structures.

Understanding how Cerner data is extracted and transformed.

Working with Cerner-derived data within a data warehouse.

Understanding relationships between clinical and operational datasets.

Investigating data quality and data integrity issues.

Understanding the impact of source-system changes on downstream data pipelines.

Troubleshooting issues involving Cerner data feeds and transformations.

Working with stakeholders to understand the clinical and operational context of data issues., Stored procedures and database functions.

Data transformation.

Data validation.

Troubleshooting complex SQL.

Identifying inefficient queries and processing.

Developing efficient and maintainable SQL solutions.

The requirement is for a candidate who can use SQL as a primary troubleshooting and analytical tool rather than simply write routine queries.

Data Architecture & Data Structures

The successful candidate will require a strong understanding of data architecture and database structures.

This includes:

Data warehouse architecture.

Relational database design.

Data modelling.

Logical and physical data structures.

Data relationships and dependencies.

ETL/ELT architecture.

Data lineage.

Data flows.

Data integration.

Data quality.

Performance implications of data architecture and design decisions.

Understanding how changes to data structures can affect downstream processes.

The candidate should be able to understand a complex data environment and quickly establish how the different components interact.

NHS National Submissions & Data Dictionaries

Experience with NHS national submissions and data dictionaries is required.

The successful candidate should have a good understanding of:

NHS national data submissions.

Relevant NHS data standards.

NHS data dictionaries.

Data definitions.

Data validation requirements.

Data quality requirements.

Data mapping.

Data completeness and consistency.

The impact of changes to national requirements on data warehouse processes.

The candidate should be able to understand both the technical and operational implications of NHS data requirements.

Stakeholder & Requirements Gathering

Although this is a highly technical role, strong interpersonal and stakeholder-management skills are essential.

The consultants will work with relevant stakeholders across the Trust to understand requirements, investigate problems and establish the desired outcomes.

Responsibilities will include:

Engaging with technical, operational and business stakeholders.

Gathering and documenting requirements.

Understanding the business context behind technical issues.

Asking appropriate questions to establish root causes and requirements.

Translating business requirements into technical solutions.

Explaining technical issues in clear, non-technical language where required.

Managing stakeholder expectations.

Providing regular progress updates.

Validating proposed solutions with relevant stakeholders.

Building effective working relationships across the Trust.

The successful candidate will need to be comfortable working directly with stakeholders and should have strong communication and soft skills.

Problem-Solving & Troubleshooting

A strong problem-solving mindset is essential.

The successful candidate will be expected to:

Take ownership of complex technical problems.

Investigate issues systematically.

Analyse available data and evidence.

Identify root causes.

Challenge assumptions where appropriate.

Develop practical remediation options.

Implement agreed solutions.

Validate that remediation has been successful.

Identify potential longer-term improvements.

Escalate appropriately where issues fall outside their remit.

The role is particularly suited to someone who enjoys getting into the detail of difficult data and database problems and figuring out why something isn’t working as it should.

Key Deliverables

The consultants will be expected to contribute to:

Resolution of existing data pipeline performance issues.

Remediation of database performance problems.

Identification and resolution of data processing issues.

Improved reliability of data pipelines.

Improved SQL and database performance.

Resolution of data quality and integrity issues.

Improved understanding of data flows and dependencies.

Requirements documentation.

Technical recommendations and remediation plans.

Stakeholder updates and progress reporting.

Knowledge transfer to relevant Trust teams where appropriate., Some travel to the Trust’s site will be required, initially to:

Collect the company laptop and equipment.

Complete any required onboarding.

Attend occasional face-to-face meetings or workshops.

Engage with stakeholders where face-to-face interaction provides value.

The majority of day-to-day activity is expected to be undertaken remotely.

We are seeking two experienced Data Consultants/Data Warehouse Developers to support a major NHS data environment.

The successful candidates will be responsible for the investigation and remediation of performance issues and other problems affecting data pipelines, data warehouse processes and associated data services.

This is a highly hands-on role requiring a strong combination of:

NHS data experience

Cerner/Oracle Health knowledge

Advanced SQL

Database Administration (DBA) capability

Database performance tuning

Data warehouse development

Data architecture and data structure knowledge

Data pipeline troubleshooting

Strong analytical and problem-solving skills

The successful candidates will need to be comfortable diagnosing complex data and database issues, identifying root causes and implementing practical remediation., Minimum of five years’ NHS experience is required.

Candidates should have significant experience working within NHS organisations and should understand the complexities of working with healthcare data within a Trust environment.

The successful candidate will ideally have experience of:

NHS data warehouses.

NHS clinical and operational data., A strong understanding of the operational context in which NHS data is created, processed and consumed will be important.

Advanced SQL

Advanced SQL skills are essential.

The successful candidate will be expected to demonstrate strong practical SQL capability, including:

Complex SQL query development.

Query optimisation.

Performance tuning.

Execution plan analysis., 5+ years’ NHS experience.

Deep understanding of Cerner/Oracle Health data.

Strong experience within an NHS data warehouse environment.

Advanced SQL skills.

Strong practical DBA knowledge, particularly database performance tuning.

Experience diagnosing and remediating database performance issues.

Experience troubleshooting data pipelines.

Strong understanding of data warehouse architecture.

Strong understanding of data structures and data relationships.

Experience with NHS national submissions.

Understanding of NHS data dictionaries.

Experience working with complex healthcare data.

Demonstrable analytical and problem-solving skills.

Experience gathering requirements from stakeholders.

Strong communication and interpersonal skills.

Ability to work independently in a predominantly remote environment.

Desirable Experience

The following would be advantageous:

Experience working directly within an NHS Trust.

Experience supporting large or complex Cerner environments.

Experience with Oracle databases.

Experience with Oracle Health/Millennium.

Experience with NHS data warehouse platforms.

Experience with ETL/ELT technologies.

Experience with healthcare reporting and analytics.

Experience with NHS national datasets.

Experience working with clinical and operational data.

Experience with data quality remediation programmes.

Experience supporting major data transformation or migration programmes.

Experience documenting data lineage and dependencies.

Candidate Profile

The ideal candidate will be a senior, hands-on data professional who combines strong technical capability with a good understanding of the NHS environment.

They will be:

Analytical and methodical.

Naturally curious and investigative.

Comfortable troubleshooting complex problems.

Strong technically, particularly in SQL and databases.

Experienced in database performance tuning.

Comfortable working with large and complex datasets.

Familiar with Cerner/Oracle Health data.

Able to understand complex data architectures quickly.

Comfortable engaging directly with stakeholders.

Able to translate business requirements into technical solutions.

Pragmatic and delivery-focused.

Comfortable working independently.

A strong communicator., This is an opportunity for an experienced NHS Data Consultant/Data Warehouse Developer to play a key role in improving the performance, reliability and quality of a complex healthcare data environment.

The successful candidates will combine deep Cerner/Oracle Health knowledge, advanced SQL, DBA and performance-tuning capability, data warehouse expertise and strong NHS experience with the interpersonal skills required to work effectively with stakeholders across the Trust.

The key focus is problem solving and remediation - understanding what is going wrong within the data environment, identifying the underlying cause and implementing robust, sustainable solutions. Location Mostly remote - initial meeting on site to collect kit and meet the team., UK

Mostly remote - initial meeting on site to collect kit and meet the team. - £450/£500 Contract Posted by: Costello & Reyes Group Limited Posted: Sunday, 16 August 2026

Costello & Reyes Group Ltd ha been tasked with identifying two consultants in Data Warehousing and Data -Cerner/Oracle Health.