Job overview
The Strategic Performance and Information Service delivers key functions across the organisation, including:
* Developing and managing performance assurance frameworks
* Providing data, performance metrics, and analytical support
* Submitting statutory information to external stakeholders
* Managing the data warehouse to integrate clinical and corporate systems for internal/external reporting
* Using advanced analytics to produce insightful reports and KPIs
The Data Engineer role:
* Follows the software development lifecycle to deliver high-quality, performance-tuned data for analysts
* Works with the data engineering and systems teams to ensure robust architecture and alignment with warehouse needs
* Ensures Information Governance compliance and escalates risks promptly
* Troubleshoots data issues and collaborates with the wider team for resolution
Main duties of the job
To support the continued development of the trusts Data Warehouse and reporting function including the processing of data for statutory & mandatory submissions and the automation of submission processes.
Please see the attached Job description and person specification for full details.
Working for our organisation
We are proud to provide high quality mental health and learning disability services, both inpatient and in the community across five boroughs of Greater Manchester - Bury, Oldham, Rochdale, Stockport and Tameside and Glossop.
Our vision is for a happier and more hopeful life for everyone in our communities and our staff work hard to deliver the very best care for the people who use our services. We’re really proud of our #PennineCarePeople and do everything we can to make sure we’re a great place to work.
All individuals regardless of race, age, disability, ethnicity, nationality, gender, gender reassignment, sexual orientation, religion or belief, marriage and civil partnership are encouraged to apply for this post. We would also encourage applications from individuals with a lived experience of mental illness, either individually or as a carer.
Detailed job description and main responsibilities
The post holder will work with the rest of the Data Engineering team to develop and maintain the organisations Microsoft SQL Server based Data Warehouse.
Some of the main duties are highlighted below but please view the attached job description and person specification for further detail.
* Work closely with the wider team and customers using Agile Project Management techniques to enable the team to deliver a more responsive, relevant and proactive service.
* To prepare/automate submissions of statutory and mandated returns and national datasets ensuring that the relevant procedure are followed and statutory deadlines are met.
* Highlight any issues or risks with the processes for producing data returns and datasets to Senior Team to ensure that these are timely, accurate and fully assured.
* Analyse requests to support developing solutions from a range of options, taking into account all available systems and associated reporting requirements.
Person specification
ation / Qualifications
Essential criteria
* Educated to A-level or equivalent
* Degree in IT related subject or equivalent experience
* Evidence of continuous professional and personal development
Experience
Essential criteria
* Experience writing SQL queries and stored procedures.
* Experience developing or maintaining data systems.
Desirable criteria
* Experience with Microsoft SQL Server, SSIS, or Azure Data Factory.
Knowledge
Essential criteria
* Understanding of data warehouse architecture and principles.
* Good understanding of Information Governance and data security.
* Good analytical and problem solving skills.
* Adaptability and willingness to learn.
Desirable criteria
* Familiarity with Tableau or similar BI tools.
* Awareness of NHS datasets and reporting requirements (e.g. MHSDS, RTT).
* Understanding of Kimball or other dimensional modelling techniques.
* Knowledge of Agile development methodology.
Skills
Essential criteria
* Excellent interpersonal and communication skills
* Ability to work on own initiative and deliver objectives to agreed timescales
* Ability to work independently and also work as part of a team
* Self-motivated and ability to motivate others
* Problem solver
* Demonstrates trust values and principles
📝 Application support - We also offer virtual application support sessions each month, where you will learn some hints and tips to support you in completing your application form. To secure your place, and to find out more visit the on our website.
🌍 Sponsorship Information - We are an approved sponsoring organisation. Applications will be considered from applicants requiring sponsorship alongside all other applications. Please be aware, not all roles are eligible for sponsorship. You can review the list of eligible role and requirements on the
📬 After You Apply - Once your application is submitted, you’ll receive updates via email. Shortlisting is based on how well you meet the criteria outlined in the person specification. Only shortlisted candidates will be invited to interview, and invitations will be sent by email.
✅ If You're Offered the Role - If successful, the hiring manager will contact you directly with a verbal offer. They will then notify the Recruitment Team and submit the necessary paperwork. You’ll receive a formal conditional offer via email
🔍 Pre-Employment Checks - To confirm your suitability for the role, we will carry out pre-employment checks in line with. These include:
* Identity verification
* Right to work check
* Disclosure and barring service (DBS)/Criminal record check (dependent on role)
* Professional registration and/or qualification check
* Occupational health assessment
* Employment history and reference validation
All applicants external to Pennine Care NHS Foundation Trust will be required to provide their to cover the most recent three years employment. This information will used to validate employment history and references.
If you require sponsorship, we will assess your eligibility based on current If the role is not eligible and you cannot demonstrate your right to work, your conditional offer may be withdrawn.
🚀 Once Checks Are Complete -
The Recruitment Team will coordinate with you and the hiring manager to confirm a start date. You’ll be booked onto a Trust Welcome Session and receive your Pennine Care NHS Terms and Conditions.
📣 Additional Information -
We are committed to equality, diversity, and inclusion (EDI), and we strive to ensure our workforce reflects the communities we serve. We actively encourage applications from individuals of diverse backgrounds to help us grow, innovate, and improve.
If you wish to be considered under the Disability Confident Scheme, you will be guaranteed an interview if you meet the essential criteria for the role.
If you need reasonable adjustments during the recruitment process, please contact us on 0161 716 3181 as early as possible so we can support you.
Please note:
* We do not accept unsolicited contact from recruitment agencies. Hiring managers should not be contacted directly.
* We may close vacancies early if we receive a high volume of applications. To ensure your application is considered, please apply as soon as possible.