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.
About us
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#PennineCarePeopleand 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.
Job 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 Specificationation / Qualifications
- Educated to A-level or equivalent
- Degree in IT related subject or equivalent experience
- Evidence of continuous professional and personal development
Experience
- Experience writing SQL queries and stored procedures.
- Experience developing or maintaining data systems.
- Experience with Microsoft SQL Server, SSIS, or Azure Data Factory.
Knowledge
- 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.
- 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
- 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
- Demonstrates trust values and principles
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.
