EPR Data Engineering Manager

About our Trust

Candidate Information Pack

At UHSussex we’re proud to be at the heart of the NHS. As one of the UK’s largest acute trusts, we’re a leading example of the excellence, the ambition and the values that have embodied the NHS for over 70 years.

Our hard-working, talented and dedicated people work together towards a common goal – to deliver Excellent Care Everywhere for our patients, our people and our communities. Whatever your role here at UHSussex you will play a part in driving us forwards and in improving the lives of patients across Sussex.

At UHSussex, diversity is our strength, and we want you to feel included to help us deliver Excellent Care Everywhere. Your uniqueness and experiences will be part of our creative and innovative community where everyone is encouraged to succeed. We have a range of staff networks to help break down barriers, and can offer a buddy to help new members settle in. We’re proud to be a Disability Confident Employer (Level 3) and a Veteran Aware Trust.

We value compassion, inclusion and respect as our core values. We treat our patients and staff with the same compassion and empathy we expect for ourselves. We’re here for them when they need us, and we go above and beyond to meet their needs. This can be seen in our wellbeing programme for staff which is extensive and designed to support you when you need it, including where possible, flexible working to support work life balance - because we know that to look after others we must first look after ourselves.

As a university trust and a leader in healthcare research, we value learning, teaching and training so that we can be the best that we can be. From the moment you start with us and throughout your career we will help you to grow and develop. We hope that in choosing UHSussex you are choosing a long and happy career where you will be able to see the difference you make and feel valued for all that you do.

As part of our commitment to access for all, please see the different ways you can access the application form: https://apps.trac.jobs/accessibility?_ts=1

We look forward to receiving your application and the start of your journey with UHSussex.

Job overview

The post holder will use highly developed specialist technical knowledge and experience of healthcare data to provide operational management and leadership to the Data Engineering function within the IT division focusing on deployment of the EPR programme.

In line with Trust and team priorities, the role will be responsible for managing, developing and motivating team members on a daily basis; coordinating the teams involvement with major programmes including Electronic Patient Record (EPR) and Strategic Data Platform (SDP); leading on the design, development and assurance of data pipelines, data platforms and data warehouse solutions that underpin the Trust’s reporting, analytics and statutory reporting functions; overseeing the development of sophisticated data engineering solutions, using the Microsoft SQL Server stack (T-SQL, SSIS, SSRS), Microsoft Fabric, PowerBI, Google Cloud Platform and other tools as required to ensure efficient, timely and accurate data is available for onwards consumption and usage across the Trust.

Advert

· To manage a team of Data Engineers, their day to day and project activities, and ensure all targets & deadlines are met.

· To design, develop, test, implement and maintain localised bespoke data engineering solutions, assist in the implementation of newly procured systems, and develop and maintain the Trust’s data warehouse and information reporting systems utilising SQL Programming (Microsoft T-SQL), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Visual Studio (ASP.Net, VB, C#), Microsoft Fabric (including Power BI) and Google Cloud Platform (including BigQuery)

· Undertake a variety of data engineering and data management tasks, using industry standard and locally developed software applications to support the Trust’s information requirements.

· To act as Subject Matter Expert (SME) for multiple locally developed systems, and Trust software solutions.

Working for our organisation

At UHSussex, diversity is our strength, and we want you to feel included to help us always deliver Excellent Care Everywhere, as shown in our Outstanding for Caring CQC rating. Your uniqueness and experiences will be part of our creative and innovative community where everyone is encouraged to succeed. We have a range of staff networks to help break down barriers, and can offer a buddy to help new members settle in. We’re proud to be a Disability Confident Employer (Level 3) and a Veteran Aware Trust.
Candidate Pack

Detailed job description and main responsibilities

Communication

· Close liaison with other team leaders within the Data Management function and wider IT department and active contribution to the successful running of the overall department will be expected from the post holder.

· Confidently and effectively communicate with users of the Trusts’ Information Systems across all levels of the organisation, conveying the complex and multi-faceted aspects of Data Engineering in a clear, concise and easily consumable way to facilitate improved understanding and learning.

· Be able to articulate and translate complex technical information and data concepts in a way that is appropriate to users with different levels of digital/data literacy and technical capability in relation to the developments and activities required to reach an effective, efficient solution to the problems at hand, negotiating priorities and delivery timescales with customers and other IT function leads as required.

· Establish and develop effective relationships with external system suppliers, negotiating on priorities and delivery for support and development.

· Represent the Data Engineering function in senior forums and meetings relating to major programmes including EPR & SDP.

· Deputise for the Head of Data Management where required.

Service Delivery and Improvement

· Analyse and investigate system errors and unplanned downtime for root causes, making recommendations on remedial actions and implementing required changes to prevent recurrence.

· Translate user requirements into actionable data engineering proposals, making recommendations as to best approach to achieve the desired outcome and negotiating timescales.

· Ability to manage and prioritise own and team workload within given timescales in partnership with customer deadlines and operational needs, prioritising highly complex competing demands from multiple concurrent projects, business as usual activities and the tehnical requirements involved with all elements, ensuring plans are produced and managed to make best use of available development resource and reduce overlap between projects.

· Provide senior leadership for the delivery, resilience and continuous improvement of the Trust’s data platforms, ensuring they effectively support reporting, analytics and information requirements arising from the EPR and SDP programmes.

· Lead the design, development and optimisation of data pipelines and data warehouse solutions to ensure EPR data is processed, integrated and made available in a timely, accurate and consistent manner to support clinical care, operational performance and statutory reporting.

· Ensure data engineering services are delivered in line with agreed priorities, standards and governance arrangements, maintaining a strong focus on data quality, information assurance and compliance with NHS data standards and information governance requirements.

· Able to work methodically and logically on own initiative with minimum supervision.

· Create User Guides and training plans for newly developed applications and reporting solutions.

· Contribute towards planning of the Trust’s IT & Data Strategies.

· Fully exploit opportunities to streamline existing processes by making recommendations for change through advances in programming and database technologies.

· Own, author, implement and maintain departmental policies and standard operating procedures, making changes to reflect newly developed applications and reporting solutions.

· Keep up to date with newly issued ISB directives, determining required changes to existing systems to ensure full compliance with their requirements.

· Responsible for the proper use of developed data engineering and reporting solutions.

· Develop, implement and support the database elements of NHS trust software solutions using Microsoft SQL Server and other database oriented tools and technologies.

· Design, develop, and implement processes and solutions to allow the collection, collation and presentation of information that deliver effective solutions to the business needs of the Trust.

· Support the delivery of strategic development of designated Trust information and clinical applications and reporting systems, including systems analysis and design.

· Assist in the design and development of key systems that extract information from appropriate data sources as required, using own judgement as to appropriate methods of extraction, manipulation and presentation.

· Ensure systems are tested for accuracy, performance, data quality and resilience.

· Adopt new methodologies, languages and technologies for existing and new solution delivery.

· Develop new information flows to support the Service Line Reporting (SLR), Patient Level Costing (PLC) and National Costs Collective (NCC) requirements of the Trust, and to allow intelligent linkage between information held on disparate systems across the Trust, ensuring accuracy, completeness and timeliness of data flows.

Important information for applicants:

A Note on AI Use in Applications

UHSussex values authenticity and encourages applicants to ensure that all application materials accurately reflect their own skills, experience, knowledge and motivations. Candidates may use AI and digital tools to support the preparation of applications, for example to assist with spelling, grammar, structure or accessibility needs. However, applicants remain responsible for the content submitted and should ensure that it genuinely represents their own abilities and experience. Where there are reasonable concerns that an application does not authentically reflect the applicant's own knowledge, skills, experience or suitability for the role, the Trust reserves the right to explore this further and, where authenticity cannot be satisfactorily demonstrated, to reject the application.

Closing Adverts Early: In the event of exceptional interest, we may close adverts earlier than specified.

Some of our adverts are capped for a limited number of applications; therefore, the advert will close once the cap has been reached. We therefore encourage you to submit your application as soon as possible if you are interested in the position to prevent you from missing out on applying for the opportunity.

Flexible Working: If you would like to explore potential options regarding flexible working please speak with the appropriate recruiting/line manager.

DBS Checks: As part of our commitment to a safe working environment, we undertake a Disclosure and Barring Service check on all new employees where the role is eligible for a criminal record check . We make offers in line with the Rehabilitation of Offenders Act 1975.

Skilled Worker Visa: Applications for Skilled Worker sponsorship are welcome for the roles that meet the Visa and Immigrations eligibility criteria. For further information please visit the gov.uk website searching for Skilled Worker. It is your responsibility as the applicant to ensure that you meet this criteria.

UHSussex reserves the right to close the role early if we receive a high volume of applications

Further Information

For help with the application process for Nursing vacancies, please email [email protected].

For help with the application process for Non-Nursing vacancies, please email [email protected].