Senior Data Warehouse Developer

Job summary

At Leeds Community Healthcare, we're seeking a skilled Senior Data Warehouse Developer to join our team and help us develop and maintain our data warehouse infrastructure.

Using your expertise in SQL Server and SSIS, you'll design, build, and optimise ETL processes, from data ingestion through to transformation, ensuring high-quality, reliable data is available for the Business Intelligence Team and other stakeholders.

You'll work closely with colleagues across the BI team to ensure the data warehouse continues to evolve in line with organisational needs and is managed in a secure, efficient, and scalable manner. This role offers flexible and remote working options, with occasional face-to-face meetings (weekly or fortnightly).

If you're passionate about leveraging data to deliver insight, improve services, and support better decision-making, and have strong technical skills in SQL Server data warehousing and ETL development, we'd love to hear from you.

Main duties of the job

In addition to the brief overview below, please ensure you review the full Job Description and Person Specification attached to this advert before applying.

As a Senior Data Warehouse Developer, you will work closely with colleagues across the wider Business Intelligence Team to develop, enhance, and maintain our data warehouse processes.

Your responsibilities will include creating and managing SSIS packages, maintaining database access and permissions, and designing reporting tables and external data sets to support the Trusts reporting and analytical needs.

You will also design and implement complex data models using advanced SQL techniques, structuring the data warehouse to ensure its smooth operation, scalability, and ongoing development to meet the evolving needs of the organisation.

For questions about the job role, please contact Adam Furness afurness@nhs.net

Adverts will close early where the maximum number of applicants is reached.

About us

Working for Leeds Community Healthcare NHS Trust:

Who are we?

Leeds Community Healthcare provides a range of community-based health services across the whole city. We treat people in their homes, local health centres and community hospitals, and work in partnership with other local Trusts, charities and Leeds City Council. We have a strong culture based on deeply-held values, and our focus at all times is on delivering high quality care to the people of Leeds. In our most recent CQC evaluation, we were rated "Good", with our Adult Services rated "Outstanding" for caring.

Perks of the job:

Our benefits range from generous annual leave to access to NHS discount sites. You can find the full list of attractive benefits and rewards at www.leedscommunityhealthcare.nhs.uk click on the Join Our Team Tab.

Right to Work:

This role is based in the UK. Employment is conditional on confirmation of the right to work in the UK - either as a UK or Irish citizen, under the EU settlement scheme or having secured any other relevant work visa. If you do not have the right to work in the UK and the role does not meet eligibility for sponsorship, please consider carefully whether you meet the eligibility to apply.