Job overview
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
1. 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.
2. 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.
3. Design, develop, and maintain ETL/ELT processes to integrate data from multiple clinical and operational source systems into trusted analytical datasets.
4. Work collaboratively with clinical, operational, IT, and BI colleagues to translate reporting and analytical requirements into effective data models and datasets.
5. Ensure data quality, integrity, and consistency across reporting solutions through validation processes, monitoring, and resolution of data issues.
6. Support statutory, regulatory, and national reporting requirements by ensuring datasets and models are accurate, auditable, and compliant with information governance standards.
7. Proactively identify and implement opportunities to improve data warehouse structures, Power BI semantic models, and reporting performance using best‑practice design.
8. Operate within agreed development, change, and release management frameworks to deliver secure, well‑documented, and maintainable data solutions.
Working for our organisation
Greater Manchester Mental Health (GMMH) Foundation Trust employs over 7000 members of staff, who deliver services from more than 122 locations.
We provide inpatient and community-based mental health care for people living in Bolton, the city of Manchester, Salford, Trafford and the borough of Wigan, and a wide range of specialist mental health and substance misuse services across Greater Manchester, the north west of England and beyond.
Greater Manchester is one of the world's most innovative, original and exciting places to live and work. From the beauty of the surrounding countryside to the heart of the vibrant inner city with great shopping, entertainment and dining options.
Wherever you go you will experience a great northern welcome with people famed for their warmth, humour and generosity.
Our people enjoy their work, have opportunities to learn and develop their skills and are encouraged to generate new ideas that improve care for our service users.
Detailed job description and main responsibilities
Please refer to the attached job description and person specification.
Staff benefits
9. 27 days annual leave plus bank holidays rising to 29 after 5 years and 33 days after 10 years
10. Excellent pension
11. Cycle to work scheme
12. Salary sacrifice car scheme
13. Wellbeing programme
Person specification
Education / Qualifications
Essential criteria
14. Degree or equivalent and / or relevant technical experience
15. Evidence of continuous professional development
Desirable criteria
16. Project management qualification
Experience
Essential criteria
17. Experience of implementing reporting datasets (Power BI/ Tableau) across a range of service areas
18. Extensive experience in informatics roles and functions.
19. Experience in the development and management of Data warehouse systems
Desirable criteria
20. Experience of working with NHS Mental Health Data
21. Experience of line management and providing support to other colleagues
22. Experience working with modern cloud based analytical platforms, such as Microsoft Fabric
23. Experience using Python for data engineering
Knowledge
Essential criteria
24. Strong proficiency in T-SQL for writing complex queries, stored procedures, and performance tuning.
25. Understanding of Data Architecture / Data Modelling principles and practices.
26. Understanding of the importance of data quality, confidentiality and security and Information Governance principles
27. Expertise in building and optimizing Power BI data models
Desirable criteria
28. Experience with Git-based version control
29. Understanding of the current key targets for the NHS
30. Experience of working within an agile environment
Skills
Essential criteria
31. Well-developed interpersonal, communication, negotiation and influencing skills, with the ability to develop and manage positive relationships with a range of stakeholders
32. Maintains own personal and professional development and supports the development of others
33. Able to work under pressure and meet deadlines, dealing with changing and sometimes conflicting priorities
34. Experience of implementing internal processes and procedures
The Trust mandates all post holders who require a DBS for their role to subscribe to the DBS Update Service. You will be required to enrol for this service for a fee of £16 per year and maintain registration throughout your employment with GMMH.
Applicants are encouraged to apply for posts at Greater Manchester Mental Health who have direct experience of mental health, learning disability or drug and alcohol services either as a service user or a carer.
The Trust is also committed to safeguarding children, young people and vulnerable adults and requires all staff and volunteers to share this commitment.
We are aspiring to ensure our workforce is representative of the diverse communities that we serve, and we are strongly committed to removing barriers to employment for candidates from under-represented groups, for example BAME, Disabled and LGBT+ communities. If you would like to have an informal chat about the recruitment process for this role or would value some additional support, we’d love to hear from you.
Use of Artificial Intelligence (AI) when writing job applications
A candidate may utilise the help of AI when writing job application. The assessment of an application is made on its entirety and most times AI-generated content does not fully grasp the context and requirements of the job one applies for thus producing inaccurate and misleading information, especially in the supporting statement section of an application that can lack real life examples of one’s achievements, success and challenges.
We have added a disclaimer to our application process advising that the use of AI is monitored. GMMH reserves the right to follow up with a candidate at the interview on specific responses and those examples used in the supporting statement to explore it further.
Sponsorship
We are proud to be an approved sponsor for the Skilled Worker visa. Applications from individuals who require sponsorship will be considered alongside all other applications. Please be aware that not all roles are eligible for sponsorship. You can review the list of eligible roles and salary requirements on the UK Government’s website – click .
If you are offered a role with us and you require sponsorship, we will check your eligibility in line with the information on the above website. Your offer of employment could be withdrawn if the role is not eligible for sponsorship, and you are not otherwise able to evidence your right to work in the UK.
The Home Office introduces new changes from 22/07/2025 that impact the health and care sector, you may wish to familiarise with it.
Do you have experience outside the NHS?
We want to attract and retain people with diverse skills and experience, to deliver inclusive healthcare services to our communities.
We will consider relevant experience outside the NHS to calculate your salary on appointment.