Principal Data Warehouse Developer

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.

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.

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.

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.

• 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…