Senior Data Warehouse Manager

Job description

Job responsibilities

Data Warehousing

• Develop and maintain a robust data warehouse and analytics architecture that integrates data from clinical, operational, and corporate systems and supports scalable storage, transformation, and analysis of healthcare data.
• Lead the design and implementation of robust data ingestion and transformation pipelines (ETL/ELT) to integrate data from a wide range of internal and external systems into the Trusts enterprise data platform.
• Establish and promote data quality standards, validation processes, and monitoring mechanisms to ensure the accuracy, completeness, and consistency of data held within the Trusts analytics platform.
• Monitor and optimise the performance, scalability, and reliability of the data warehouse and associated data pipelines to ensure efficient data processing and retrieval.
• Work with analysts, reporting teams, and operational stakeholders to understand analytical requirements and develop well-structured data models and curated datasets that support reporting and advanced analytics.
• Ensure comprehensive documentation of data architecture, data pipelines, data models, and metadata, including the maintenance of data dictionaries and technical standards.
• Implement and maintain robust data security and access control mechanisms to protect patient and operational data, ensuring compliance with information governance policies and relevant data protection legislation.

Leadership and Management

• Maintain effective working relationships with key stakeholders across the Trust, providing specialist advice and support to ensure that agreed objectives and deliverables are achieved and appropriately documented.
• Work closely with internal Digital Services teams and external technology partners to ensure effective coordination of infrastructure, integration, and platform support for the Trusts data and analytics environment.
• Where required, support organisational investigations and reviews by providing specialist data analysis, interpretation, and technical advice
• Liaise with third-party system vendors and technology partners to support the effective implementation, integration, and ongoing operation of data platform technologies.

Strategic Contribution

• Contribute to the development and implementation of the Trusts data and analytics strategy, ensuring that the data warehouse and analytics platform evolve to meet organisational needs.
• Provide technical leadership and advice on the design and adoption of modern data platform technologies and data engineering practices.
• Identify opportunities to improve the Trusts use of data through better integration, modelling, and accessibility of datasets to support operational improvement and patient care.

Technical and Platform Leadership

• Provide technical leadership and guidance to the Data Warehouse Team, ensuring adoption of best practices in data engineering, data modelling, and platform management.
• Oversee the selection, implementation, and optimisation of data platform tools and technologies, ensuring solutions are scalable, secure, and fit for purpose.
• Maintain awareness of emerging tools, techniques, and industry trends, advising the team and wider organisation on opportunities to enhance the Trusts data and analytics capabilities.
• Promote consistency, quality, and maintainability across data pipelines, datasets, and analytics solutions, ensuring alignment with organisational data strategy.

Problem Solving

• Analyse a wide range of data, system, and analytical issues, making effective use of available information to identify root causes and inform appropriate solutions.
• Work with stakeholders to understand the underlying business or clinical question and translate this into an appropriate analytical or technical approach.
• Work with stakeholders to understand the underlying business or clinical question and translate this into an appropriate analytical or technical approach.

Insight Generation & Communication

• Use appropriate communication methods to present analytical findings clearly and effectively to a range of audiences.
• Tailor communication and analytical outputs to the needs of different stakeholders, using language and context that is accessible to both technical and non-technical audiences.
• Present analytical findings using clear visualisations and structured narratives that support understanding and informed decision-making.
• Translate complex technical or analytical concepts into clear, practical insights and recommendations for operational, clinical, and senior leadership audiences.

Influencing Skills

• Build effective working relationships with stakeholders across the organisation in order to influence decision-making and promote the effective use of data and analytics.
• Facilitate discussions with clinical, operational, and technical stakeholders to develop shared understanding and agreement on analytical approaches and priorities.
• Use negotiation and persuasion skills to balance competing requirements and achieve practical solutions to complex analytical or data-related challenges.
• Apply strong interpersonal and communication skills to build trust, encourage collaboration, and support the adoption of data-driven approaches across the organisation.

Continuous Skills Development

• Maintain and develop professional knowledge and technical expertise in data engineering, analytics platforms, and emerging technologies relevant to the Trusts data strategy.
• Proactively seek opportunities for professional development, contributing to a culture of continuous learning within the Data Warehouse Team.
• Share knowledge, best practice, and technical expertise with colleagues to support the development of team capability and improve the quality of analytical delivery.
• Promote professional standards and behaviours in line with the Trusts values, fostering a supportive and collaborative working environment.

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

Person Specification

Data warehousing

• Extensive familiarity with complex computerised information systems
• Integrated dashboard scope, design, and development.
• Proven ability to lead, influence and motivate with project / resource planning experience.
• Experience of designing, coding, testing and implementation of efficient and robust database schemas.
• 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 of modern analytics platforms.
• Knowledge of the information needs and processes of the Clinical and Operational functions within an Acute hospital.
• Experience designing and managing modern data pipelines (ETL/ELT), curated datasets, and semantic layers.
• Experience managing technical teams of developers or data engineers, including mentoring, prioritisation, and professional development.

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.

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.

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/