Senior Data Engineer

Mid Yorks

Dewsbury

On-site

GBP 70,000 - 90,000

Full time

2 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

NHS pension
27 days holiday + Bank holidays
Wellbeing services
Cycle to work
Car lease scheme
Flexible working
Training and progression

Job summary

Mid Yorks is seeking a Senior Data Engineer to join our Office of Data and Analytics. You will help design, build and deploy high-priority datasets in Azure, while transitioning from on‑prem architectures toward modern cloud-based solutions.

Your expertise in NHS data warehousing and ETL development will be pivotal as we evolve our analytics capabilities. You will work within a small team of Data Engineers alongside BI, Analytics Engineering, Data Science and Insight functions to deliver robust,

Qualifications

  • Postgrad qualification or equivalent level of experience.
  • Experience designing, developing, testing and maintaining complex ETL Data Warehouse solutions.
  • Ability to design dimensional and relational data models for NHS data.
  • Strong SQL skills, including DDL/DML and SSMS.
  • Ability to translate non-technical requirements into technical specifications.

Responsibilities

  • Design, develop, test and deploy high-priority datasets in Azure-oriented architecture.
  • Debug complex technical issues under pressure and manage competing priorities.
  • Design review discussions with peers and provide peer reviews within the team.
  • Communicate progress and issues clearly, and manage technical debt effectively.

Skills

ETL development
Dimensional modeling
SQL Server
Data warehousing
Communication

Education

Postgrad degree

Tools

MS SQL Server

Job description

About the role

As a Senior Data Engineer, you will join a small team of Data Engineers, which compliment our wider disciplines in the Office of Data and Analytics, such as Business Intelligence, Analytics Engineering, Data Science and Insight functions.

We are embarking on a journey towards an EPR implementation (Electronic Patient Record), in addition to transitioning to modern architecture in Azure.

As a Senior Data Engineer, you will be pivotal to supporting us on this journey, aspiring to all our on prem architecture to be in the Azure platform. Regardless of your level of experience with Azure, this will provide you with the opportunity to continue your professional development in the Azure environment.

Our Data Engineering function is key to remodelling, developing and building our priority datasets in Azure to support our onward evolution of analytics and insights aligned to EPR.

Expert skills and experience in ETL processes is essential for this role, as is previous experience in an Informatics Department and NHS Data Warehousing.

Main duties

Day to day, the Senior Data Engineer will be working on designing, developing, testing and deploying high priority datasets in our plan.

Debugging and problem solving complex technical issues under pressure is a daily occurrence, whilst balancing competing priorities.

You will design solutions, and conduct design review conversations with peers, and peer review work for other Data Engineers as part of closely aligned team.

You will be a good communicator in terms of progress of development, and provide progress updates of arising technical issues, assessing impact and bring to a resolution effectively without contributing to technical debt.

For further details, refer to the Job Description and Personal Specification

Essential person specification requirements

Qualifications:

  • Post grad qualification, or equivalent level of experience relevant to the post

Experience:

  • Highly experienced in full cycle of design, development, testing, and maintenance of complex technical ETL DW solutions
  • Design and development of dimensional and relational data models
  • Development across the MS SQL Server stack
  • Debugging, and resolving complex technical issues under pressure
  • Ability to ensure quality of development, creating repeatable test plans
  • Good communicator, with experience of translating non-technical requirements into formal technical specifications
  • Experience of working in a team, and the complexities of working in a technical team

Knowledge:

  • Data warehousing in NHS setting
  • Knowledge and understanding of SQL DML and DDL statements, and front end counterpart actions in SSMS
  • Data flow diagrams and appreciates importance
  • Good working knowledge of ERDs to describe relationships within datasets
  • Good working knowledge of star schema models and how to implement within a DW
  • Strong knowledge of NHS information standards, guidance and definitions

For further details, refer to the Job Description and Personal Specification

Be part of MY team

We are an acute trust caring for over one million people in Wakefield and Kirklees. Our 10,000 staff work in patients’ homes, the community, and our three hospitals in Pontefract, Dewsbury, and Pinderfields (Wakefield). We prioritise our people and values so we can deliver the best possible care to patients. Our team is friendly, passionate, and innovative, always seeking better ways to work.

We support work-life balance and foster a diverse, inclusive environment where everyone belongs. Our staff networks offer safe spaces to share ideas and concerns so we can increase awareness and appreciation of equality, diversity, and inclusion. We welcome applicants from all backgrounds and especially encourage members of the LGBTQ+ community, ethnic minority groups, and people with disabilities or neurodivergence to apply, as they are currently underrepresented in the Trust.

If you value caring, high standards, improvement, and respect, join the MY team to make a difference every day.

Our benefits
  • Access to the NHS pension plan
  • Generous holiday allowance of 27 days plus bank holidays, increasing with 5 and 10 years of service
  • Exceptional employee health and wellbeing services
  • Extensive benefits and support, including:
  • Onsite nurseries and childcare salary sacrifice scheme
  • Home electronics scheme
  • Cycle to work scheme - subject to eligibility criteria
  • Car lease salary sacrifice scheme - subject to eligibility criteria
  • Working carers support and advice, carers network and carers passport
  • Flexible working options and family and carer-friendly policies
  • Established staff networks, including LGBTQ+ and Race Equality
  • Career progression, training and support
Skilled worker sponsorship

You can find out more about skilled worker and health and care visas on our careers site.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Engineer (Nhs Data)
Data Engineer (Nhs Data)

Our Future Health • Greater London

Hybrid
GBP 56,000 - 68,000
Generous pension
30 days holiday + bank holidays
Enhanced parental leave
+5
Senior Data Engineer
Senior Data Engineer

Supply Chain Coordination Limited • England

Hybrid
GBP 56,000 - 66,000
Hybrid work
Annual bonus schemes
27 days holiday plus bank holidays
+6
Senior Data Engineer
Senior Data Engineer

The Royal Marsden NHS Foundation Trust • Greater London

On-site
GBP 64,000 - 71,000
Data Engineer
Data Engineer

Our Future Health • Greater London

Hybrid
GBP 56,000 - 68,000
Salary from £62,000 per year
Pension scheme up to 12%
30 days holiday + bank holidays
+7
Senior Data Engineer
Senior Data Engineer

Supply Chain Corporation • Nottingham

Hybrid
GBP 56,000 - 66,000
Hybrid work
Annual bonus
Long service awards
+8
Senior Data Engineer
Senior Data Engineer

Supply Chain Corporation • Brighton

Hybrid
GBP 56,000 - 66,000
Hybrid working
Annual bonus
Long service awards
+6
Senior Data Engineer
Senior Data Engineer

NHS Resolution • Greater London

Hybrid
GBP 70,000 - 95,000
NHS Pension Scheme
27 days annual leave
Flexible working arrangements
+5
Senior Data Engineer
Senior Data Engineer

NHS Supply Chain • Nottingham

Hybrid
GBP 56,000 - 66,000
Hybrid working
Annual bonus schemes
27 days holiday
+6
Data Engineer
Data Engineer

NHS Thames Valley Integrated Care Board • Oxford

On-site
GBP 42,000 - 52,000
Data Engineer — Secure Health Data Pipelines
Data Engineer — Secure Health Data Pipelines

Our Future Health • Greater London

Hybrid
GBP 56,000 - 68,000
Salary from £62,000 per year
Pension scheme up to 12%
30 days holiday + bank holidays
+7