LW255197 - Data Engineer

NHS Grampian; Aberdeen City; Hybrid; GBP 55,000 - 75,000; Full time

Benefits offered by this job

Flexible working

Hybrid working

Professional development support

University collaborations

Job summary

NHS Grampian in Aberdeen is seeking a Data Engineer to join our Health Intelligence team and help build the next generation of NHS Grampian's data services.

You will help design and implement a new enterprise data platform around Microsoft Fabric, OneLake and Power BI, shaping data pipelines, lakehouse and warehouse structures, reusable data models and semantic layers to support clinicians and service leaders.

Qualifications

• Experience with modern data platforms and building scalable data services.
• Ability to design data pipelines, lakehouse, warehouse structures and semantic models.
• Knowledge of governance, security and privacy in data environments.

Responsibilities

• Help design and build NHS Grampian's Microsoft Fabric data estate.
• Develop and improve data ingestion, transformation and ELT pipelines.
• Build lakehouse, warehouse and reusable data models.
• Support the migration from Tableau to Power BI.
• Develop trusted semantic models and reusable data products.
• Integrate data from clinical, operational and corporate systems.
• Improve automation, testing, deployment, monitoring and documentation.
• Embed governance, lineage, security and access controls.
• Collaborate with analysts, clinicians and service leaders to turn problems into data solutions.

Skills

Data engineering

ELT

Lakehouse architecture

Dimensional modelling

SQL

Python

APIs & system integration

CI/CD

Data governance

Security & privacy

Tools

Microsoft Fabric

Azure

Databricks

Snowflake

Power BI

Job description

NHS Scotland is committed to encouraging equality and diversity among our workforce and eliminating unlawful discrimination. The aim is for our workforce to be truly representative and for each employee to feel respected and able to give their best. To this end, NHS Scotland welcomes applications from all sections of society.

Data Engineer

Summerfield House | Permanent | Full Time

NHS Grampian is an intelligence-led organisation using data and analytics across clinical, operational, public health and corporate services.

We are looking for an experienced and forward-thinking Data Engineer to join our Health Intelligence team and help build the next generation of NHS Grampian's data services.

We are developing a new enterprise data platform around Microsoft Fabric, OneLake and Power BI, while moving away from our existing on-premise and Tableau estate.

The successful candidate will help shape and build that environment, including data pipelines, lakehouse and warehouse structures, reusable data models and semantic layers, governance, security and the migration from Tableau to Power BI.

SQL and Python are useful, but we are particularly interested in someone who understands how modern data platforms fit together and can design reliable, scalable and maintainable data services.

What You Will Do

• Help design and build NHS Grampian's Microsoft Fabric data estate
• Develop and improve data ingestion, transformation and ELT pipelines
• Build lakehouse, warehouse and reusable data models
• Support the migration from Tableau to Power BI
• Develop trusted semantic models and reusable data products
• Integrate data from clinical, operational and corporate systems
• Improve automation, testing, deployment, monitoring and documentation
• Help embed good approaches to governance, lineage, security and access control
• Work with analysts, clinicians and service leaders to turn real problems into practical data solutions

About You

We are looking for someone who can self-lead and take technical ownership.

You should be comfortable taking a problem, understanding what is needed, working out a sensible approach and taking it through to delivery without needing every step mapped out for you.

Experience In Some Of The Following Would Be Useful

• Microsoft Fabric, Azure, Databricks, Snowflake or similar platforms
• Power BI and semantic modelling
• Data engineering and ELT
• Lakehouse or data warehouse architecture
• Dimensional modelling
• SQL and Python
• APIs and system integration
• Version control, testing and CI/CD
• Data governance, security and privacy

Whilst desirable, you do not need NHS experience and you do not need to tick every box. We would much rather find someone who understands data engineering, learns quickly, thinks independently and wants to help us build something substantial.

What We Offer

• A genuine opportunity to help shape a major new NHS data platform
• Flexible and hybrid working
• Strong support for professional development and research
• Close links with the University of Aberdeen and Aberdeen Centre for Health Data Science
• Work with a broad range of health data that directly supports patient care, services and population health

There is a lot to build, a lot to improve and a wee bit to untangle. For the right person, that is a big part of what makes the role interesting.

Additional Information For Candidates

AI-generated content for the completion of Supporting Statements may lack specificity and fail to address key criteria outlined in the job description. Personalisation is essential to convey individual skills, knowledge, and experiences effectively.

As a disability confident employer we are committed to ensuring our recruitment processes are inclusive and accessible to all.

Shortlisted candidates will be invited to attend the interview in person. Alternative arrangements or adjustments will be considered in the event there are circumstances that may prevent candidates attending in person to ensure it is inclusive and accessible to all.

• Please note - If this post operates within Aberdeen City Low Emission Zone, you will be responsible for all costs associated with entering.

NHS Grampian forms one of the fourteen regional health boards of NHS Scotland and is responsible for providing health and social care services to a population of over 500,000 people living in Aberdeen, Aberdeenshire and Moray.

As a board we strive to ensure the environment is conducive to nurturing a positive culture, supported and delivered through our NHS and Social Care values.