Data & Analytics Specialist — Pipelines & Warehousing

NHS Scotland; City of Edinburgh; Hybrid; GBP 53,000 - 61,000; Full time

Benefits offered by this job

Pension scheme

Work-life balance policies

Occupational health services

Learning resource centres

Discounted leisure/ shopping benefits

Job summary

PSD Scotland is recruiting a Technical Analyst to join the Data & Analytics team. The role focuses on designing, building, and deploying scalable data solutions, with responsibilities spanning data modelling, data pipelines, and data warehouse structures.

You’ll translate business needs into precise technical specifications and work with stakeholders across health and social care. The ideal candidate has strong business and technical analysis skills, experience with large datasets, and a solid

Qualifications

• Experience in business and technical analysis, including requirements elicitation, documentation, and validation.
• Ability to translate business needs into clear, accurate technical specifications.
• Experience with large, complex datasets, including data profiling and data quality assessment.
• Strong understanding of data structures, data warehousing concepts, and backend data processes.
• Proven stakeholder engagement and communication skills, across the full project lifecycle.

Responsibilities

• Support the development and delivery of national data services across NHS Scotland.
• Translate business needs into robust data solutions and specifications.
• Document data sourcing, flows, transformations, and validation requirements.
• Collaborate across multidisciplinary teams using Agile and DevOps approaches.

Skills

Business analysis

Technical analysis

Requirements elicitation

Documentation

Data profiling

Data quality

Data structures

Data warehousing

Stakeholder engagement

Communication

Agile/DevOps

Tools

SQL

Job description

PSD Scotland is recruiting a Technical Analyst to join the Data & Analytics team. The role focuses on designing, building, and deploying scalable data solutions, with responsibilities spanning data modelling, data pipelines, and data warehouse structures.

You’ll translate business needs into precise technical specifications and work with stakeholders across health and social care. The ideal candidate has strong business and technical analysis skills, experience with large datasets, and a solid