Mid Cheshire Hospitals NHS Foundation Trust
Information Services objective is to provide data and analytics capabilities to support patient care, quality, performance, financial flows and service development. Enabling operational and clinical excellence through data excellence.
The Data Engineering Team's purpose is to build, develop and assure the Trust's Data Platform and leverage this asset for the organisation using modern technologies, tools, and techniques.
The role will be responsible for developing and improving the data platform in Microsoft Azure, including the integration of artificial intelligence into the data warehouse and analytics. This involves managing data pipelines, databases, Azure cloud environment, system security, system planning, and technical documentation.
You will provide strong technical leadership with the vision to grow the service and introduce new concepts that deliver data excellence. The role will require hands-on development as well as management.
Hybrid working would be supported for this role.
Main duties of the job
1. Successful delivery of the data warehouse for the Trust's clinical and non-clinical systems.
2. Adhere to and participate in the Trusts IT change management process.
3. Provide technical support as required to the Information Department teams.
4. Build a high achieving team that can deliver data excellence to support trust objectives.
5. Ensure value is unlocked from the growing volume of clinical data.
6. Support the New Hospital Programme data requirements.
7. Embed artificial intelligence into the data architecture to provide enhanced insight.
8. Use strong influencing skills to represent data engineering interests with colleagues at all levels within this organisation and with senior external colleagues.
9. Deputise for the Head of Information and Performance when required.
10. Derive and ensure delivery of an overall strategy of master data management that supports data exploitation for analysis.
11. Establish a strategy and processes for specialised data handling for example for unstructured data.
12. Lead on the design of a trusted secure research environment for collaborative research.
Job responsibilities
Summary points below:
1. Provision and maintain on premise servers and SQL servers where required.
2. Manage cloud service fees and optimise the environment to proactively manage cost.
3. Respond to and manage any incidents and events which occur in the platform.
4. Database Management: Provision and maintain On Premise SQL databases and Azure SQL databases.
5. Monitor and optimise SQL performance including database tuning.
6. Data Management: Design, develop and maintain an industry standard data architecture.
7. Review and implement a real-time data extraction process.
8. Security Management: Configure, test and support data warehouse authentication arrangements.
9. Data Warehouse Planning: Undertake system capacity management and plan upgrades to the data warehouse environment.
10. Documentation: Create detailed documentation including diagrams of database infrastructure.
11. Governance: Develop data architecture and software development policies and processes.
12. Managerial/Leadership: Team manager for a small, high performing team.
13. Education/Learning: Remain up to date on data engineering best practices.
Person Specification
Qualifications
* Educated to masters level in an Informatics related subject or equivalent experience.
Knowledge/Experience
* Extensive knowledge of writing SQL and stored procedures.
* Extensive data extract, transfer/translate and load experience for a large data warehouse.
* Knowledge of Business Intelligence systems and reporting tools.
* Extensive knowledge of Microsoft Azure and its data management offering.
Skills
* Experience of working in an Information Management team.
* Highly numerate and articulate.
* Experience of working with Microsoft Azure.
Values and Behaviours
* Commitment to quality and safety.
* Willingness to act as a role model.
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.
#J-18808-Ljbffr