Job summary
An exciting opportunity has arisen for a talented and experienced Principal Data Warehouse Developer to join our Digital Services team. We have set out an ambitious five-year Digital Plan to deliver world-class information and digital solutions, with patient care at its core.
As Principal Data Warehouse Developer, you will play a key role in enabling and enhancing the Trust's data warehousing and Business Intelligence capabilities. You will design, develop, and maintain ETL processes, create and update data pipelines, and support the integration of new datasets to ensure high-quality, actionable insights are available across the organisation.
The ability to speak Welsh is desirable for this post; Welsh and/or English speakers are equally welcome to apply.
Main duties of the job
Key Responsibilities
- Contribute to the Trust's Digital and Data Strategies through advanced technical delivery.
- Design and implement robust ETL processes for diverse datasets.
- Collaborate with senior clinicians, operational teams, and support staff to understand business needs.
- Deliver information solutions that enable evidence-based decision-making.
- Work on enablement of:
- Data linkage across multiple systems.
- API development and integration.
- Cloud migration of data assets.
- Metadata management and governance.
- Establishing and maintaining a data catalog.
- Creating new data pipelines and transforming and upgrading existing ones.
- Manage your workload effectively, in order to meet tight deadlines while maintaining high standards.
- Contribute to a culture of innovation, teamwork, and continuous improvement.
About You
We are looking for someone who is:
- Self-motivated, personable, and confident in stakeholder engagement.
- Experienced in data warehousing, ETL, and BI development.
- Skilled at translating complex business needs into technical solutions.
- A strong team player with excellent communication skills.
- Able to manage competing priorities and deliver under pressure.
Application Process
Please read the job description and person specification carefully and ensure your application demonstrates the required knowledge, skills, and experience to carry out the role.
About us
#RemarkablePeople
Our workforce is made up of over 4,000 remarkable people who contribute to the delivery of world-class patient care across Wales, 24 hours a day, 365 days a year. Whether you work in a patient-facing role or within our range of support services, the work that you do enables us to provide high quality care, wherever and whenever we're needed.
The Trust recognises the need for its workforce to represent the diversity of the population it serves across the whole of Wales and seeks to create an environment where diversity is celebrated and inclusivity matters. We are also keen to break down any barriers into the Trust, and would encourage applications from under-represented groups, including those from Black, Asian and Minority Ethnic communities, LGBTQ+ communities and disability groups.
Careers within the Welsh Ambulance Services University NHS Trust are diverse and varied, with opportunities arising right across the service. Whatever your skills and background, you're sure to find a career with us which is fulfilling, challenging, and rewarding.
In line with the Trust's Starting Salary Procedure, all applicants will start at the bottom of the band for the position applied for, but can apply for a higher salary if they have previous experience relevant to the position.
Job description
Job 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.
Job description
Job 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.
Person Specification
Qualifications and/or Knowledge
Essential
- Bachelor's degree in Software Development or equivalent qualifications, knowledge, or experience.
- Demonstrable expertise in Database Development, either obtained via industry recognised qualifications (e.g. Microsoft Certification) or equivalent practical experience
- Proven knowledge and understanding of the Software Development Lifecycle (SDLC) either through a suitable qualification (e.g. Agile) or equivalent practical experience.
- Evidence of SQL Server Database Administration either through formal qualifications or via equivalent practical experience.
- Evidence of continuing professional development and post qualification learning and development.
Desirable
- Advanced qualification in an agile development methodology.
- Qualification in team leadership (such as the Institute of Leadership and Management's Level 2 Diploma in Team Leadership)
Experience
Essential
- Proven experience of database development role in a formal development environment.
- Evidence of leading the design, development, and deployment of large-scale database development projects.
- Evidence of experience with Windows PC and server operating systems.
- Proven record of management of successful and substantial software development and implementation.
- Evidence of a strong understanding of NHS Clinical/Administrative Information and IT requirements.
- Proven experience of using Microsoft BI Stack to prepare, move, store and present data. This includes; SSIS, SSAS, SSRS
- Proven experience using T-SQL, XML to solve complex queries.
- Excellent working knowledge of relational database systems.
Desirable
- Experience developing software for Clinical Information or Healthcare systems.
- Good working knowledge of database administration activities
- Experience of working in an Agile Development environment.
- Experience of using Qlik Business Intelligence Software.
Values
Essential
- Ability to demonstrate the trust values.
Other
Essential
Aptitude and Abilities
Essential
- Highly skilled in development using a suitable IDE and programming language.
- Ability and confidence to speak publicly to groups of people, demonstrating ideas, concepts and working software and answer related questions.
- Excellent planning skills. Ability and confidence to lead and motivate a team, chairing team meetings (such as Daily SCRUMS and Sprint retrospectives.)
- Able to establish good working relationships with people at all levels.
- Able to work under own initiative.
- Able to communicate with staff on complex business or clinical processes.
- Ability to assess and recommend the recruitment of suitable staff.
- Display high quality written and verbal communication skills.
- Able to learn new technologies and IT systems quickly through both self-study and professional courses.
- Highly professional and flexible attitude to work.
Desirable
- Ability to speak Welsh
- Understands the Data Protection Act and its implications for the holding of patient information NHS Information flows / services.
Person Specification
Qualifications and/or Knowledge
Essential
- Bachelor's degree in Software Development or equivalent qualifications, knowledge, or experience.
- Demonstrable expertise in Database Development, either obtained via industry recognised qualifications (e.g. Microsoft Certification) or equivalent practical experience
- Proven knowledge and understanding of the Software Development Lifecycle (SDLC) either through a suitable qualification (e.g. Agile) or equivalent practical experience.
- Evidence of SQL Server Database Administration either through formal qualifications or via equivalent practical experience.
- Evidence of continuing professional development and post qualification learning and development.
Desirable
- Advanced qualification in an agile development methodology.
- Qualification in team leadership (such as the Institute of Leadership and Management's Level 2 Diploma in Team Leadership)
Experience
Essential
- Proven experience of database development role in a formal development environment.
- Evidence of leading the design, development, and deployment of large-scale database development projects.
- Evidence of experience with Windows PC and server operating systems.
- Proven record of management of successful and substantial software development and implementation.
- Evidence of a strong understanding of NHS Clinical/Administrative Information and IT requirements.
- Proven experience of using Microsoft BI Stack to prepare, move, store and present data. This includes; SSIS, SSAS, SSRS
- Proven experience using T-SQL, XML to solve complex queries.
- Excellent working knowledge of relational database systems.
Desirable
- Experience developing software for Clinical Information or Healthcare systems.
- Good working knowledge of database administration activities
- Experience of working in an Agile Development environment.
- Experience of using Qlik Business Intelligence Software.
Values
Essential
- Ability to demonstrate the trust values.
Other
Essential
Aptitude and Abilities
Essential
- Highly skilled in development using a suitable IDE and programming language.
- Ability and confidence to speak publicly to groups of people, demonstrating ideas, concepts and working software and answer related questions.
- Excellent planning skills. Ability and confidence to lead and motivate a team, chairing team meetings (such as Daily SCRUMS and Sprint retrospectives.)
- Able to establish good working relationships with people at all levels.
- Able to work under own initiative.
- Able to communicate with staff on complex business or clinical processes.
- Ability to assess and recommend the recruitment of suitable staff.
- Display high quality written and verbal communication skills.
- Able to learn new technologies and IT systems quickly through both self-study and professional courses.
- Highly professional and flexible attitude to work.
Desirable
- Ability to speak Welsh
- Understands the Data Protection Act and its implications for the holding of patient information NHS Information flows / services.
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.
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 (Opens in a new tab).
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 (Opens in a new tab).
Additional information
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.
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 (Opens in a new tab).
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 (Opens in a new tab).
