Data Engineer

Pennine Care NHS FT; Ashton-under-Lyne; On-site; GBP 35,000 - 50,000; Full time

Job summary

A healthcare organization in the UK seeks a Data Engineer to support their Data Warehouse and reporting functions. The ideal candidate will have experience with SQL, data system maintenance, and a degree in an IT-related subject. Responsibilities include developing solutions for data submissions and collaborating with Agile teams. Join us to help enhance our data services and contribute significantly to healthcare efforts in our communities.

Qualifications

• Experience writing SQL queries and stored procedures.
• Experience with Microsoft SQL Server, SSIS, or Azure Data Factory.
• Evidence of continuous professional development.

Responsibilities

• Develop and maintain the organisations Microsoft SQL Server-based Data Warehouse.
• Prepare/automate submissions of statutory returns ensuring deadlines are met.
• Analyse requests to support developing solutions from a range of options.

Skills

SQL queries

Data system maintenance

Microsoft SQL Server

Communication skills

Problem solving

Agile methodology

Education

A-level or equivalent

Degree in IT related subject or equivalent experience

Tools

SSIS

Azure Data Factory

Tableau

Job description

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 Specification

ation / 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.