Data Warehouse Manager

Health-Education-and-Improvement-Wales; Cardiff; Hybrid; GBP 50,000 - 57,000; Full time

Benefits offered by this job

Flexible working

Corporate induction

Performance appraisal

Impact on health and social care

Job summary

Health Education and Improvement Wales (HEIW) invites applications for the Data Warehouse Manager (Band 7) based in Cardiff. You will lead the design, implementation and ongoing development of HEIW's workforce data warehouse, steering a secure, scalable platform to support workforce planning and organisational performance.

The role requires expert SQL database architecture, data governance and cloud migration experience, with leadership of the Data Warehouse team and collaboration across NHS

Qualifications

• Experience designing and leading data warehouse solutions.
• Strong data governance, GDPR and information governance knowledge.
• Ability to work with stakeholders across NHS Wales and partners.

Responsibilities

• Lead design, development and management of HEIW's workforce data warehouse.
• Ensure secure, reliable and scalable platform for workforce planning and reporting.
• Provide expert analysis, dashboards and reports for forecasting and planning.
• Lead and develop the Data Warehouse team and drive continuous improvement.

Skills

Data Warehouse Design

Team leadership

Analytical skills

Azure cloud technologies

Education

Prince 2 Foundation or equivalent

Tools

MS SQL

Microsoft Azure

Fabric

Job description

Main area Data Warehouse Grade Band 7 Contract Permanent Hours

• Full time
• Flexible working

37.5 hours per week (An agile working model to allow flexibility between home and office-based working.) Job ref 082-AC060-1026

Employer Health Education and Improvement Wales Employer type NHS Site Ty Dysgu Town Cardiff Salary £50,129 - £57,365 per annum Salary period Yearly Closing 29/10/2026 23:59

Data Warehouse Manager

Band 7

We are committed to promoting inclusion at HEIW and we welcome applications from everybody recognising the value that diversity brings to our workforce. To work in the UK, candidates who are not UK or Republic of Ireland (ROI) nationals require sponsorship via a Skilled Worker Visa, unless they have permission to work via another route. Please note that HEIW does not currently hold a licence to appoint skilled workers from overseas by sponsoring them to work in the UK. If successful, candidates from outside of the UK or ROI would be responsible for obtaining their own sponsorship or visa to enable them to work for HEIW - Work in the UK .

This vacancy may close early if it receives a high number of applications. Please complete and submit your application in good time to avoid disappointment.

Job overview

The Data Warehouse Manager is responsible for leading the design, implementation, management and continuous development of HEIW's workforce data warehouse, providing a robust, secure and high-quality information platform to support workforce planning, strategic decision-making and organisational performance.

The post holder will act as the organisation's expert in SQL database architecture, data warehousing and workforce modelling, ensuring the effective integration, governance and analysis of complex workforce data from multiple internal and external sources.

Working collaboratively with stakeholders across HEIW, NHS Wales, Welsh Government and partner organisations, they will develop innovative data solutions and workforce data models, ensuring compliance with data governance and GDPR requirements. The role also provides leadership for the Data Warehouse team, driving continuous improvement in data quality, reporting, system development and analytical capability while supporting the delivery of national workforce intelligence and organisational performance objectives.

Main duties of the job

You will lead the design, development, implementation and management of HEIW’s workforce data warehouse, ensuring the delivery of a secure, reliable and scalable platform to support workforce planning, operational delivery and strategic decision-making across NHS Wales. They will be responsible for the development and maintenance of SQL database solutions, including database architecture, complex queries, data integration processes, reporting interfaces and the migration of existing on-premises SQL solutions to Azure cloud-based architecture.

The post holder will ensure effective data governance, quality and compliance with GDPR, information governance standards and data-sharing agreements, integrating workforce data from multiple sources including the ESR Data Warehouse and external datasets. They will provide expert analysis, develop workforce intelligence products, dashboards and reports, and apply advanced analytical techniques and workforce modelling methodologies to support forecasting, scenario planning and strategic workforce planning.

Working collaboratively with stakeholders across HEIW, NHS Wales, Welsh Government and partner organisations, the post holder will provide specialist advice, improve data capability and lead innovation in data analysis and visualisation. They will also provide leadership and direction to the Data Warehouse team, supporting staff development, continuous improvement and the effective delivery of workforce information services.

Working for our organisation

Health Education and Improvement Wales (HEIW) is the strategic workforce body for NHS Wales with statutory functions that include education and training, workforce planning, workforce development and transformation, leadership and succession planning, and careers. Our purpose is to develop a workforce that delivers excellent care to patients/service users and excellent population health. We are a Special Health Authority working closely with our partners; Social Care Wales, education providers, professional and regulatory bodies and Welsh Government.

HEIW’s is committed to developing an internal culture of choice. Our Values reflect our thoughts, feelings and beliefs in how we will, and will not, behave and treat others:

- Respect for All in every contact we have with others,

- Ideas that Improve: Harnessing creativity and continuously innovating, evaluating and improving,

- Together as a Team: Working with colleagues across NHS Wales and with partner organisations.

HEIW received the HPMA Award for Employee Engagement in 2019.

What you can expect:

- a corporate induction and 90 day Welcome itinerary,

- a meaningful values based performance appraisal process,

- the opportunity to impact upon health and social care services and the lives and wellbeing of the people of Wales.

Many of our colleagues and stakeholders have commented on the buzz and atmosphere we create by working together as “One HEIW Team”. Do you want to join that team?

Detailed job description and main responsibilities

The ability to speak Welsh is desirable for this post; Welsh and/or English speakers are equally welcome to apply.

Person specification

Experience

• Data Warehouse Design
• Demonstrable success in building, leading, motivating, managing and developing teams.
• Excellent analytical, communication and presentation skills.
• Azure and Cloud based technologies

Qualifications & Knowledge

• In-depth knowledge of MS SQL
• Knowledge and practical use of Microsoft Azure & Fabric
• Python
• Prince 2 Foundation or equivalent

Skills

• Able to write high quality workforce reports and documentation for both technical and non-technical audiences.
• Ability to work autonomously, prioritise, meet deadlines and solve problems.
• Able to focus, concentrate and accurately complete tasks within given timeframes whilst dealing with unscheduled interruptions.
• Welsh Language Skills

It is essential that your application demonstrates how you meet the job description / person specification for this post.