Principal Data Warehouse Developer

Welsh Ambulance NHS Trust; Swansea, Cwmbran, St Asaph; On-site; GBP 45,000 - 55,000; Full time

Job summary

A healthcare organization in the United Kingdom seeks a Principal Data Warehouse Developer to lead the enhancement of data warehousing and BI capabilities. The role involves designing ETL processes, managing data pipelines, and collaborating with various stakeholders to provide actionable insights. Candidates should have substantial experience in database development, proficiency with the Microsoft BI Stack, and strong communication skills. Knowledge of NHS data requirements is essential for success in this position.

Benefits

Opportunities for continuous professional development

Diversity and inclusivity initiatives

Work-life balance support

Qualifications

• Proven experience in a database development role in a formal environment.
• Knowledge of NHS Clinical/Administrative Information.
• Experience working in an Agile Development environment.

Responsibilities

• Design and implement ETL processes for diverse datasets.
• Collaborate with stakeholders to understand business needs.
• Manage workload effectively to meet deadlines.

Skills

Self-motivated

Data warehousing expertise

ETL development

Business Intelligence (BI)

Excellent communication skills

Stakeholder engagement

Education

Bachelor's degree in Software Development

Industry recognized Database Development qualifications

Agile development methodology qualification

Tools

Microsoft BI Stack

Qlik Business Intelligence Software

SQL Server

Job description

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

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

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

• 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
• Excellent working knowledge of relational database systems.
• 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

• Ability to demonstrate the trust values.

Other

• Able to work flexibly.

Aptitude and Abilities

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