Job summary
We are looking for an experienced and highly motivated Data Warehouse Manager/Solutions Architect to join us in the journey towards advancing the Trust's HIMSS AMAM stages. You will be a subject matter expert in designing cloud and hybrid solutions that run on Microsoft Azure, including compute, network, storage, monitoring, and security. You will operate and develop the Trust's Data Warehouse (Dev, Test and Prod) environments secure, efficient, and reliable that supports the delivery of "Data driven insights to enhance the quality of care"
Main duties of the job
You will be operating latest Data and AI technology - Microsoft Intelligent data platform (including Azure SQL, Data Factory, Azure Synapse Analytics, Microsoft Fabric, Azure ML etc.,), Microsoft Power Platform, Azure DevOps etc.,
We support our team with a strategic training strategy and we are looking for a candidate that is looking to continuously improve, develop and learn new technologies and approaches in this exciting and ever developing environment.
About us
Our mission is to make a positive difference to people's lives by improving the quality of life for all we serve. Our values are: We Care, We Respect, We are Inclusive - so we are looking for people who live and breathe these qualities when supporting service users and carers, and in their relationships with colleagues in the Trust and our partner organisations
Job description
Job responsibilities
Please for further information kindly refer to the job description and person specification attached to this vacancy.
Job description
Job responsibilities
Please for further information kindly refer to the job description and person specification attached to this vacancy.
Person Specification
Education/ Qualification/ Training
Essential
- Educated to bachelor's level in computer science, software engineering or equivalent Has professional certification in Business Intelligence or Data warehouse technology
Desirable
- Microsoft certification in Azure Solution Architect Expert
- Educated to masters level in related subject or equivalent experience.
- Agile Project Management Foundation and Practitioner
Experience
Essential
- Advanced experience and knowledge of Cloud Infrastructure operations, including networking, virtualization, identity, security, business continuity, disaster recovery, data platforms, and governance.
- Experience leading and managing a team of Data Warehouse specialists
- Advanced level of technical expertise and skills in the management and development of a data warehouse
- Advanced experience in Database Administration with server configuration, performance tuning, and troubleshooting.
- Expertise in data modelling, database development and advanced skills in SQL
- Knowledge of designing and building dataflow pipelines using Data Factory, SSIS.
- Expertise in deploying and maintaining Azure
Desirable
- DevOps infrastructure
- Expertise in Microsoft Power Platform
- Detailed knowledge of data sets, collection and validation
- A detailed knowledge of NHS data definitions
- Knowledge of how data collection, information flows and reporting underpin the operational, clinical and business processes in an NHS acute hospital
- Understanding of the workings of a NHS provider organisation
- Experience of managing an informatics team in a healthcare setting
Knowledge and Skills
Essential
- Experience providing advice and guidance to non-Informatics colleagues in the use of technical and analytical systems and tools
- Effective inter-personal skills, able to liaise with managers and clinicians at all levels internal and external to the organisation offering guidance and interpretation on complex information pertaining to the Data Warehouse and Data Modelling
- Credible leadership, management and motivational skills
- Confident and articulate with good communication, interpersonal, presentational and report writing skills
- Excellent analytical, interpretation and problem solving skills
- Ability to prioritise own and others' workloads effectively to meet tight deadlines whilst managing conflicting priorities
- Able to translate technically complex information to non-technical staff
- An understanding of how Informatics can support the provision of high quality and efficient patient care
- Understanding of data protection legislation and NHS policies for the protection and use of personal and health data
- Able to work flexible hours to meet the needs of the service
- Motivated with a 'can do' attitude
- Negotiation Skills and conflict resolution
- Chairing and managing meetings including Daily Scrum meetings
- Ability to lead teams and motivate staff to achieve tasks within tight deadlines
- Ability to communicate and resolve contentious information issues for senior managers
Person Specification
Education/ Qualification/ Training
Essential
- Educated to bachelor's level in computer science, software engineering or equivalent Has professional certification in Business Intelligence or Data warehouse technology
Desirable
- Microsoft certification in Azure Solution Architect Expert
- Educated to masters level in related subject or equivalent experience.
- Agile Project Management Foundation and Practitioner
Experience
Essential
- Advanced experience and knowledge of Cloud Infrastructure operations, including networking, virtualization, identity, security, business continuity, disaster recovery, data platforms, and governance.
- Experience leading and managing a team of Data Warehouse specialists
- Advanced level of technical expertise and skills in the management and development of a data warehouse
- Advanced experience in Database Administration with server configuration, performance tuning, and troubleshooting.
- Expertise in data modelling, database development and advanced skills in SQL
- Knowledge of designing and building dataflow pipelines using Data Factory, SSIS.
- Expertise in deploying and maintaining Azure
Desirable
- DevOps infrastructure
- Expertise in Microsoft Power Platform
- Detailed knowledge of data sets, collection and validation
- A detailed knowledge of NHS data definitions
- Knowledge of how data collection, information flows and reporting underpin the operational, clinical and business processes in an NHS acute hospital
- Understanding of the workings of a NHS provider organisation
- Experience of managing an informatics team in a healthcare setting
Knowledge and Skills
Essential
- Experience providing advice and guidance to non-Informatics colleagues in the use of technical and analytical systems and tools
- Effective inter-personal skills, able to liaise with managers and clinicians at all levels internal and external to the organisation offering guidance and interpretation on complex information pertaining to the Data Warehouse and Data Modelling
- Credible leadership, management and motivational skills
- Confident and articulate with good communication, interpersonal, presentational and report writing skills
- Excellent analytical, interpretation and problem solving skills
- Ability to prioritise own and others' workloads effectively to meet tight deadlines whilst managing conflicting priorities
- Able to translate technically complex information to non-technical staff
- An understanding of how Informatics can support the provision of high quality and efficient patient care
- Understanding of data protection legislation and NHS policies for the protection and use of personal and health data
- Able to work flexible hours to meet the needs of the service
- Motivated with a 'can do' attitude
- Negotiation Skills and conflict resolution
- Chairing and managing meetings including Daily Scrum meetings
- Ability to lead teams and motivate staff to achieve tasks within tight deadlines
- Ability to communicate and resolve contentious information issues for senior managers
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.
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).
Additional information
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.
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).
