Senior Data Engineer

NHS; Salford; Hybrid; GBP 46,000 - 53,000

Job description

Job summary

An exciting opportunity has arisen in the Data and Analytics Team, at Northern Care Alliance, for a Senior Data Engineer to help migrate the current on-premises solution to a cloud-based solution in Azure.

The Data and Analytics Team has recently undergone a period of natural growth and progression which has resulted in the opportunity for two Senior Data Engineers to join the existing Data Platform Team.

This is a fantastic opportunity to join a team that is looking to be one of the first hospitals in the country to have a complete Cloud Based Data Warehouse Solution.

The Data and Analytics Team is not only transitioning to a state-of-the-art Azure data platform, but we are also implementing an agile multi-disciplinary, product-focused approach to delivering cutting-edge insights, data science, and visualizations to the organization.

The Senior Data Engineer is pivotal to the delivery of high-quality efficient healthcare provision, robust information to operational, clinical, and corporate decision makers through the use of on-demand reporting through our current Data Warehouse and moving forward our cloud-based data warehouse. The successful candidate will help to design, develop & implement the trust's new cloud-based data warehouse, alongside being responsible for the migration away from legacy/on-prem solutions and replacing them with state-of-the-art cloud-based technologies (Azure). You will also help to maintain & develop existing on-prem solutions.

Main duties of the job

• You will be working within a team leading in the specification, development, and implementation of a Hybrid on-premise and Azure cloud Data warehouse and reporting platform.
• Work closely with members of the Data & Analytics Team to proactively develop/improve the trust's Data Warehouse platform/function into a highly efficient architecture.
• Ensure you are proactive rather than reactive when there are issues within the data warehouse to be fixed in a timely manner & documented for future references. Comprehensive knowledge of Data Engineering products such as SSIS, SSRS, SQL to help triage and signpost solutions to customers, and potential issues to internal teams.
• Work closely with Senior Data Engineering Manager and team to identify risks and rectify them before they become an issue, particularly those that have a detrimental impact on patients, service users, and Data Platforms' reputation.
• Manage/Support the day-to-day operations of the trust's data warehouse solution both on-prem & MS Azure to ensure they are kept running without any errors through our BAU requests portal, dealing with incidents & change through our Agile (Scrum) process, liaising with third-party vendors, internal & external teams to ensure business continuity.
• Design, implement, support, and continually improve the new Microsoft Azure based Data Warehouse, from bringing in new systems through to staging, data warehouse, and reporting layer using the Kimball methodology within Data Factory/Pipeline process.

About us

The Northern Care Alliance NHS Foundation Trust (NCA) provides hospital and integrated health and social care services to over one million people living across Greater Manchester. Our 20,000 colleagues care for people in hospital and in the community, working across Bury, Rochdale, Oldham, and Salford, to save and improve lives. As a large NHS trust, we are committed to enhancing the health of our local population by delivering consistently high standards of care and working closely with local authorities and key partners. We believe in our power and potential to make a difference and we're always looking for people who demonstrate our three core values - care, appreciate, and inspire - to join our team.

In return, we can offer you a job role with purpose and flexibility. The size and scale of the NCA means we can provide more challenge and opportunities so your career can always be moving in the right direction. By joining us you can also access a competitive benefits package, including, a fantastic annual leave allowance, flexible working opportunities, and protected hours for health and wellbeing activities, helping you to achieve more personal downtime and a better work-life balance.

Date posted

25 March 2025

Pay scheme

Agenda for change

Band

Band 7

Salary

£46,148 to £52,809 a year per annum

Contract

Permanent

Working pattern

Full-time, Flexible working

Reference number

C9236-25-0720

Job locations

Turnpike House / Remote Working

531 Eccles New Road

Salford

M50 1SY

Person Specification

Qualifications Essential

• Degree in related technical or informatics related field, or equivalent experience as Data Warehousing Developer or Business Intelligence Developer.
• Evidence of relevant continued professional development in both technical specialist SQL/Data Warehouse disciplines.
• Relevant technical skills qualifications backed up with accredited professional certification. Microsoft certification in SQL Server, MS Azure.

Desirable

• Leadership Qualifications Project Management Qualification (e.g. PRINCE2, Agile, Scrum etc.)

Knowledge Essential

• Advanced Experience/knowledge of Azure infrastructure or other cloud computing platforms including data factory and ETL processes/synapse.
• Advanced knowledge of Microsoft SQL Server (Indexes, Performance tuning & query optimization, complex Stored procedures/views/functions).
• Knowledge of dimensional/fact modelling methodologies and appropriate application of different techniques (Kimball).
• Knowledge of supporting & developing Microsoft Azure ETL pipeline solutions, triggers, connections/data lake, data bricks, power apps/automate.

Desirable

• Knowledge & experience in working within an Agile (Scrum) environment/framework.

Professional Registration Desirable

• Membership of a relevant Fed-IP recognized professional body is desirable (BCS, SOCITM, IHRIM, CILIP, AphA).

Experience Essential

• Experience in handling large datasets from multiple source systems.
• Experience of providing end user support, training, and advanced technical expertise through workshops/sessions.
• Experience of supervising/mentoring junior members of the team.
• Significant experience of supporting & developing ("on-prem") data warehouse environments using Microsoft stack (SQL Server, SSIS, SSRS, SSAS).

Desirable

• Experience of NHS information and data.

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.

Certificate of Sponsorship

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.

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.

Employer details

Employer name: Northern Care Alliance NHS Foundation Trust

Address: Turnpike House / Remote Working

531 Eccles New Road

Salford

M50 1SY

Employer's website: https://www.northerncarealliance.nhs.uk/