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.
About us
Greater Manchester Mental Health (GMMH) Foundation Trust employs over 7000members of staff, who deliver services from more than122locations.
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.
Job description
Job responsibilities
Please refer to the attached job description and person specification.
Staff benefits
- 27 days annual leave plus bank holidays rising to 29 after 5 years and 33 days after 10 years
- Excellent pension
- Cycle to work scheme
- Salary sacrifice car scheme
- Wellbeing programme
- Blue Light Card Discounts
Job description
Job responsibilities
Please refer to the attached job description and person specification.
Staff benefits
- 27 days annual leave plus bank holidays rising to 29 after 5 years and 33 days after 10 years
- Excellent pension
- Cycle to work scheme
- Salary sacrifice car scheme
- Wellbeing programme
- Blue Light Card Discounts
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
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.
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).
Additional information
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.
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).
