Job summary
East Cheshire NHS Trust is committed to driving innovation in healthcare through the use of data analytics. We are seeking a skilled and dedicated data engineer to join our dynamic team on a fixed term contract to support the implementation of our new electronic patient record system.
You will play a critical role in the successful implementation of our new EPR system by contributing to the development and maintenance of our data infrastructure, enabling the reliable and efficient flow of data across our organisation.
Working closely with the data analysts, you will contribute to the design, implementation and optimisation of data integration processes and data warehousing solutions.
You will collaborate with stakeholders in the EPR programme, including project managers, data analysts and operational managers, to understand data requirements and develop key datasets supporting local and national reports including CDS and SITREPs.
Hours per week: 37.5
Main duties of the job
The overall aim of the role is to support and proactively maintain the trust's data warehouse to underpin the effective use of data, information, knowledge and technology to support and improve health and health care delivery at the trust.
The post holder will collaborate with stakeholders in the EPR programme in the development of key operational reports and datasets, ensuring that the data flows in to the data warehouse are accurate and efficient.
Additionally, they will be responsible for supporting and maintaining the trust's information data warehouse so that the Information Department can deliver services to all parts of the Trust. This involves supporting data feeds, databases, platform environment, system security, system planning and technical documentation.
About us
Whether you are just starting out in your career or are looking to use your skills and experience in a new role, East Cheshire NHS Trust is the right employer for you. An organisation with a real sense of community we actively support and develop our staff to ensure our patients receive the best quality care, delivering the right care first time, every time.
COVID-19 vaccination remains the best way to protect yourself, your family, your colleagues and of course our patients from the virus when working in our healthcare settings. Whilst COVID-19 vaccination is not a condition of employment at this time, we do encourage our staff to get vaccinated. We will be checking the vaccination status of all new starters so that we can manage individual and environmental risks, and so that we can support those who may be undecided about vaccination. If you are unvaccinated there is helpful advice and information at https://www.eastcheshirehrdirect.nhs.uk
Job description
Job responsibilities
Please read the attached Applicant Pack prior to completing your application form to find out more information.
Please download a copy of the Job Description and Person Specification located under the Supporting documents heading to read more about the advertised role.
As part of making your application we encourage you to review the Trusts Careers webpage www.careersateastcheshire.nhs.uk for more information about working for East Cheshire NHS Trust
We are an equal opportunities employer and welcome all applications irrespective of age, disability, gender, sexual orientation, race or religion. The Trust is a Disability Confident Leader and as such, applicants with disabilities will be offered an interview providing they meet the minimum criteria for the post (outlined in the Person Specification).
Applicants are advised to apply early as we reserve the right to close the advert prior to the advertised closing date should we receive a large number of applications.
We look forward to receiving your application.
Job description
Job responsibilities
Please read the attached Applicant Pack prior to completing your application form to find out more information.
Please download a copy of the Job Description and Person Specification located under the Supporting documents heading to read more about the advertised role.
As part of making your application we encourage you to review the Trusts Careers webpage www.careersateastcheshire.nhs.uk for more information about working for East Cheshire NHS Trust
We are an equal opportunities employer and welcome all applications irrespective of age, disability, gender, sexual orientation, race or religion. The Trust is a Disability Confident Leader and as such, applicants with disabilities will be offered an interview providing they meet the minimum criteria for the post (outlined in the Person Specification).
Applicants are advised to apply early as we reserve the right to close the advert prior to the advertised closing date should we receive a large number of applications.
We look forward to receiving your application.
Person Specification
Qualifications
Essential
- oEducated to Degree level
- oMicrosoft Certification (in SQL server/Azure) or equivalent.
Knowledge and Skills
Essential
- oIn-depth knowledge of SQL server.
- oIn-depth knowledge of SQL development/coding
- oExtensive knowledge of messaging technologies
- oExtensive knowledge of writing SQL and stored procedures and query tuning on high transaction systems.
- oKnowledge of database mirroring using processes such as change data capture
- oKnowledge of Business Intelligence systems and reporting tools such as Power BI Advanced use of Microsoft Office suite: Word, Excel, PowerPoint and Access
- oExperience of working in an Information Management team of large organisation
- oExperience of administering Microsoft SQL server databases
- oExperience of assisting in hardware and operating system deployment for BI projects
- oAble to work independently and proactively
- oHighly numerate, articulate and able to assimilate, analyse, interpret and compare highly complex facts/situations
- oAble to effectively communicate difficult messages to stakeholders at all levels both internally and externally
- oWorking knowledge of NHS Information Governance requirements
- oAbility to Communicate effectively with internal staff and external agencies to ensure compliance with trust objectives
- oExcellent interpersonal skills and the ability to influence others across a wide range of stakeholders both within the Trust and externally
- oExcellent communication skills, both verbal and written
- oAbility to produce good technical documentation including data flow maps
Desirable
- oKnowledge of NHS and acute datasets
- oKnowledge of patient and data flows in an hospital setting
- oKnowledge of programming languages
- oExtensive knowledge of Microsoft Azure and its data management offering
Experience
Essential
- oExtensive data extract, transfer/translate and load experience for a large data warehouse
- oExperience of interpreting system log files.
- oExperience of system security, permissions, groups and authentication.
- oExperience of system patching.
- oExperience of technical system back up and recovery approaches.
Desirable
- oExperience of working in an acute NHS trust
- oCloud technology management including platform as a service and infrastructure as a service models.
- oAbility to solve problems & make decisions under pressure
- oExperience of system performance monitoring and tuning.
Other Role Requirements
Essential
- Please refer to the Job Description and Person Specification for further details.
Person Specification
Qualifications
Essential
- oEducated to Degree level
- oMicrosoft Certification (in SQL server/Azure) or equivalent.
Knowledge and Skills
Essential
- oIn-depth knowledge of SQL server.
- oIn-depth knowledge of SQL development/coding
- oExtensive knowledge of messaging technologies
- oExtensive knowledge of writing SQL and stored procedures and query tuning on high transaction systems.
- oKnowledge of database mirroring using processes such as change data capture
- oKnowledge of Business Intelligence systems and reporting tools such as Power BI Advanced use of Microsoft Office suite: Word, Excel, PowerPoint and Access
- oExperience of working in an Information Management team of large organisation
- oExperience of administering Microsoft SQL server databases
- oExperience of assisting in hardware and operating system deployment for BI projects
- oAble to work independently and proactively
- oHighly numerate, articulate and able to assimilate, analyse, interpret and compare highly complex facts/situations
- oAble to effectively communicate difficult messages to stakeholders at all levels both internally and externally
- oWorking knowledge of NHS Information Governance requirements
- oAbility to Communicate effectively with internal staff and external agencies to ensure compliance with trust objectives
- oExcellent interpersonal skills and the ability to influence others across a wide range of stakeholders both within the Trust and externally
- oExcellent communication skills, both verbal and written
- oAbility to produce good technical documentation including data flow maps
Desirable
- oKnowledge of NHS and acute datasets
- oKnowledge of patient and data flows in an hospital setting
- oKnowledge of programming languages
- oExtensive knowledge of Microsoft Azure and its data management offering
Experience
Essential
- oExtensive data extract, transfer/translate and load experience for a large data warehouse
- oExperience of interpreting system log files.
- oExperience of system security, permissions, groups and authentication.
- oExperience of system patching.
- oExperience of technical system back up and recovery approaches.
Desirable
- oExperience of working in an acute NHS trust
- oCloud technology management including platform as a service and infrastructure as a service models.
- oAbility to solve problems & make decisions under pressure
- oExperience of system performance monitoring and tuning.
Other Role Requirements
Essential
- Please refer to the Job Description and Person Specification for further details.
Additional information
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).
