Dataset Developer: Sponsorship Available

Greater Manchester Mental Health NHS Foundation Trust

Job Summary

Please note: This role is not fully remote. The successful candidate will be required to work from the Prestwich office for a minimum of 50% of their working week.

This role is critical in supporting the organisation’s data infrastructure, enabling high-quality reporting, analytics, and data-driven decision-making to improve patient care and operational efficiency.

Working closely with clinical, operational, IT, and Business Intelligence colleagues, the post holder will play a leading role in the design, development, and optimisation of high-quality Power BI data models. A strong understanding of data modelling, particularly dimensional modelling principles, is essential, as these models will underpin analytical reporting and the ongoing development of the Trust’s data warehouse.

The post holder will ensure that data models and reporting solutions are robust, scalable, and performant, meeting current needs while remaining adaptable to future requirements. They will help develop trusted data structures that support consistent metrics and reliable insight across the Trust.

This role requires a strong understanding of data architecture, ETL processes, and business intelligence tooling, alongside a commitment to data quality, security, and information governance. The successful candidate will play a key role in supporting the Trust’s digital transformation and strategic objectives through well-designed, sustainable data solutions.

Role subject to job matching.

 

Main duties of the job

  • Lead the design, development, and optimisation of high-quality Power BI data models, underpinned by robust dimensional modelling principles to support accurate and consistent reporting.
  • Support the development, maintenance, and optimisation of the Trust’s data warehouse and associated data platforms, ensuring solutions are scalable, performant, and fit for purpose.
  • Design, develop, and maintain ETL/ELT processes to integrate data from multiple clinical and operational source systems into trusted analytical datasets.
  • Work collaboratively with clinical, operational, IT, and BI colleagues to translate reporting and analytical requirements into effective data models and datasets.
  • Ensure data quality, integrity, and consistency across reporting solutions through validation processes, monitoring, and resolution of data issues.
  • Support statutory, regulatory, and national reporting requirements by ensuring datasets and models are accurate, auditable, and compliant with information governance standards.
  • Proactively identify and implement opportunities to improve data warehouse structures, Power BI semantic models, and reporting performance using best-practice design.
  • Operate within agreed development, change, and release management frameworks to deliver secure, well-documented, and maintainable data solutions.

Person Specification

Education / Qualifications

Essential

  • Degree or equivalent and / or relevant technical experience
  • Evidence of continuous professional development

Desirable

  • Project management qualification

Experience

Essential

  • Experience of implementing reporting datasets (Power BI/ Tableau) across a range of service areas
  • Extensive experience in informatics roles and functions.
  • Experience in the development and management of Data warehouse systems

Desirable

  • Experience of working with NHS Mental Health Data
  • Experience of line management and providing support to other colleagues
  • Experience working with modern cloud based analytical platforms, such as Microsoft Fabric
  • Experience using Python for data engineering

Knowledge

Essential

  • Strong proficiency in T-SQL for writing complex queries, stored procedures, and performance tuning.
  • Understanding of Data Architecture / Data Modelling principles and practices.
  • Understanding of the importance of data quality, confidentiality and security and Information Governance principles
  • Expertise in building and optimizing Power BI data models

Desirable

  • Experience with Git-based version control
  • Understanding of the current key targets for the NHS
  • Experience of working within an agile environment

Skills

Essential

  • Well-developed interpersonal, communication, negotiation and influencing skills, with the ability to develop and manage positive relationships with a range of stakeholders
  • Maintains own personal and professional development and supports the development of others
  • Able to work under pressure and meet deadlines, dealing with changing and sometimes conflicting priorities
  • Experience of implementing internal processes and procedures

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 (Opens in a new tab).

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 (Opens in a new tab).

Closing Date: 15 March 2026

To apply for this job please visit apps.trac.jobs.