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
The post holder 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. The ability to speak Welsh is desirable for this post; Welsh and/or English speakers are equally welcome to apply.
Detailed job description and main responsibilities
You will be able to find a full Job description and Person Specification attached within the supporting documents or please click “Apply” now to view in Trac.
Applicant requirements
Welsh language skills are desirable
Person specification
Skills
Essential
- 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.
Desirable
- Welsh Language Skills
Experience
Essential
- Data Warehouse Design
- Demonstrable success in building, leading, motivating, managing and developing teams.
- Excellent analytical, communication and presentation skills.
Desirable
- Azure and Cloud based technologies
Qualifications & Knowledge
Essential
- In-depth knowledge of MS SQL
- Knowledge and practical use of Microsoft Azure & Fabric
- Python
Desirable
- Prince 2 Foundation or equivalent
WhatsApp job alerts
Get instant WhatsApp alerts for Administrative and IT roles in Cardiff
Create your Job Clerk account first. We'll collect your alert preferences during onboarding and help you turn on WhatsApp notifications for matching healthcare roles.
Applying for this NHS job
This advert is for Data Warehouse Manager with Health Education and Improvement Wales in Cardiff, Wales. It is listed as a Administrative and IT role. The advertised salary is £50129.00 to £57365.00. The contract type is Permanent. The application deadline is 20 Aug 2026.
Before you apply, compare the job description with the person specification and mirror the employer's essential criteria in your supporting information. Use the vacancy title, employer, location, salary, contract type, closing date and posted date (07 Aug 2026) to decide whether this role fits your current NHS job search. If the employer can close applications early, prepare the application before the stated deadline rather than waiting for the final day.
For more context, review related Job Clerk pages for the same profession, band or location where they exist, then use the application-support guides to tailor your statement and prepare for interview.