Job summary
The Information Department at Chelsea and Westminster is a cutting edge environment, looking to utilise modern technologies and working methods.
The Data warehouse manager role is a senior member of the Information Department. The post holder will take responsibility for the engineering and management of the Trust's data warehouse hosted on Azure cloud.
The post-holder will be expected to work closely with all members of the data warehouse team, with line-management of junior members of the team as an intrinsic part of the role.
This is an exciting opportunity to become involved with an evolving team and utilising cloud technology and modern development tools.
Main duties of the job
To lead the Trust Data Warehouse function and provide continual improvements to the Trust's Azure based Data Warehouse product.
To act as an advocate for cloud based solutions.
The post holder will have line management responsibilities for the Data Warehouse team
As part of the wider Information function the post holder will serve as the subject matter expert for all aspects of Data Warehouse design, SQL code, database tuning and the overall cloud architecture of the warehouse.
About us
We provide services from two main hospitals, Chelsea and Westminster Hospital and West Middlesex University Hospital, and a number of clinics across London and the South-East.
We have over 6,000 members of staff that are PROUD to Care for nearly one million people. Both hospitals provide full clinical services, including full maternity, emergency and children's, in addition to a range of community-based services across London, such as award-winning sexual health and HIV clinics.
We're one of the safest and best performing Trusts in the country. We're also one of the top trusts to work for - our staff say they're engaged, motivated, and would recommend us as a place to work and receive treatment.
In 2020 Trust was rated by the Care Quality Commission as Outstanding in the well-led and use of resources domains and Good in the safe, effective, caring, and responsive domains. The Trust as a whole was Good, but the Chelsea site was Outstanding.
Our facilities are some of the best in the country. We have been investing around £10 million a year in our estate. We are currently spending £25 million on expanding our adult and neonatal critical care facilities at Chelsea and Westminster and redevelopment of our children's unit at West Middlesex - in partnership with our charity, CW+ and generous donors.
Job description
Job responsibilities
- Custodian of data accuracy, integrity, security and performance in the data warehouse.
- Perform, deploy and automate business data loads providing the appropriate testing requirements for live deployment.
- Maintain and improve the Data warehouse and product knowledge bases.
- Become an authority of the Trust data providing insight into data flows and architecture considerations.
- Maintain and consolidate data flows in the live data architecture.
- Lead the Trust data warehousing environments architecture design of data marts, tabular models, databases, data modelling, data imports, data exports, data quality, data storage and data security.
- Lead in the management of extraction, transformation and loading of data into and out of the data warehouses, ensuring that all key data items are stored efficiently and in a way that is conducive to effective and efficient information reporting.
- Lead on the planning, development and deployment of efficient and robust data extraction, transformation and load routines.
- Translate business data requirements into logical and physical data models, applying the concepts of proper data modelling and database design and ensuring a strong understanding of source data to ensure the design approach results in a logical and efficient data model to support the Trusts Information reporting capabilities.
- Ensure the data warehouse environment is operating at optimum performance and ensure procedures are in place to regularly review and improve performance and database efficiency.
- Responsible for maintaining data completeness, accuracy and integrity and resolving issues if they arise.
- Ensure the data warehouse environment is regularly audited and that there are documented procedures and policies in place.
- Develop and maintain documented data architecture and administration standards including standardisation of table names, column names, data types; this will involve the development of policies and procedures where required.
- Work closely with ICT and Information Analysts to ensure the construction and presentation of data supports their requirements and conforms to the NHS Data Dictionary Standards and Information Standard Notices
- Provide expertise to the wider team around database analysis and data interpretation, including problem solving using SQL programming, use of advanced functions and complex methodology.
- Mentor junior team members.
- Extract and analyse relevant information to support and develop proposals for improvements or in response to issues raised
- Responsible for the overall architecture of the Trusts data warehouse which will drive reporting and income by collating data from many sources into a single source.
- Identify and evaluate the advantages/ disadvantages of options, providing considered reasoning and suggested course of action
- Handle sensitive information pertaining to patients necessary to resolve incidents.
- Undertaking detailed analysis of how complex data applications currently work.
- Analysis of reported faults within the data warehouse and judging how these faults can be resolved.
- Understanding the detail of complex requests for the provision of data/information from a variety of sources internal and external to the Trust, whether these requests can be met and, if so, how these requests might best be met. This will include detailed dialogue with the data/information requestor on the fine detail of the request and what format should be utilised to provide this data/information.
- Providing input into the design of solutions that meet business requirements based on experience and knowledge of already-developed applications.
- Ensuring that business requirements and possible solutions are fit for purpose and appropriate (based on many factors ... scale, risk, criticality, availability of development resource, funding, target user-base, etc.).
- Handling, manipulating and presenting data extracted from systems using appropriate tools.
- Undertaking all work with a clear customer focus. Ensuring that all developed solutions are designed to be relevant to the user-base with appropriate levels of end-user documentation, implementation planning, communication, etc.
- Analysis of live platform statistics delivering suggestions and improvements.
- Analysing live platform performance to drive proactive improvements preventing live issues and ensuring SLAs are maintained.
- Analysing and working with significantly complex data often made up from a large number of significantly inter-related sources
- Manage and deliver projects and work packages vital to the Information and Performance team service provision of the Trust.
- Manage the benefits, risks and dependencies of key issues within specific work stream(s).
- Plan and prioritise own work and the work of the team to ensure deadlines are met.
- Meet with external and internal stakeholders to evaluate requirements and organise implementation where deemed required.
- Working collaboratively with other team members to support Trust requirements.
- Leading on any changes to the data architecture of the Trust, planning what resources will be required (human resources, routines/objects, etc.), determining which products will be produced as part of change requests, the deployment lifecycle, what user documentation will be required, what training may be required, etc. i.e. Project Planning (defining project deliverables, success criteria, dependencies, change control).
- Will have overall decision making responsibility for the design and architecture of the Trust data warehouse.
- Taking responsibility for own actions and working under guidance from the posts line manager. For the role, it is expected that the post holder will be provided with an outline of each piece of work from their line manager and guidance as to what should be delivered for that piece of work; beyond that, it is expected that the Data Warehouse Manager will have sufficient ability and confidence to determine and find their way through the development of that piece of work with minimum guidance.
- Seeking out new ways of working and ideas for system improvements whilst adhering to ICT Policies and Procedures.
- Pushing at boundaries and thinking outside the box regarding the introduction of new ideas, tools and techniques that increase the effectiveness of the team to support the Service.
- Becoming a technical specialist of NHS data especially the data flows in and around the Trust.
Job description
Job responsibilities
- Custodian of data accuracy, integrity, security and performance in the data warehouse.
- Perform, deploy and automate business data loads providing the appropriate testing requirements for live deployment.
- Maintain and improve the Data warehouse and product knowledge bases.
- Become an authority of the Trust data providing insight into data flows and architecture considerations.
- Maintain and consolidate data flows in the live data architecture.
- Lead the Trust data warehousing environments architecture design of data marts, tabular models, databases, data modelling, data imports, data exports, data quality, data storage and data security.
- Lead in the management of extraction, transformation and loading of data into and out of the data warehouses, ensuring that all key data items are stored efficiently and in a way that is conducive to effective and efficient information reporting.
- Lead on the planning, development and deployment of efficient and robust data extraction, transformation and load routines.
- Translate business data requirements into logical and physical data models, applying the concepts of proper data modelling and database design and ensuring a strong understanding of source data to ensure the design approach results in a logical and efficient data model to support the Trusts Information reporting capabilities.
- Ensure the data warehouse environment is operating at optimum performance and ensure procedures are in place to regularly review and improve performance and database efficiency.
- Responsible for maintaining data completeness, accuracy and integrity and resolving issues if they arise.
- Ensure the data warehouse environment is regularly audited and that there are documented procedures and policies in place.
- Develop and maintain documented data architecture and administration standards including standardisation of table names, column names, data types; this will involve the development of policies and procedures where required.
- Work closely with ICT and Information Analysts to ensure the construction and presentation of data supports their requirements and conforms to the NHS Data Dictionary Standards and Information Standard Notices
- Provide expertise to the wider team around database analysis and data interpretation, including problem solving using SQL programming, use of advanced functions and complex methodology.
- Mentor junior team members.
- Extract and analyse relevant information to support and develop proposals for improvements or in response to issues raised
- Responsible for the overall architecture of the Trusts data warehouse which will drive reporting and income by collating data from many sources into a single source.
- Identify and evaluate the advantages/ disadvantages of options, providing considered reasoning and suggested course of action
- Handle sensitive information pertaining to patients necessary to resolve incidents.
- Undertaking detailed analysis of how complex data applications currently work.
- Analysis of reported faults within the data warehouse and judging how these faults can be resolved.
- Understanding the detail of complex requests for the provision of data/information from a variety of sources internal and external to the Trust, whether these requests can be met and, if so, how these requests might best be met. This will include detailed dialogue with the data/information requestor on the fine detail of the request and what format should be utilised to provide this data/information.
- Providing input into the design of solutions that meet business requirements based on experience and knowledge of already-developed applications.
- Ensuring that business requirements and possible solutions are fit for purpose and appropriate (based on many factors ... scale, risk, criticality, availability of development resource, funding, target user-base, etc.).
- Handling, manipulating and presenting data extracted from systems using appropriate tools.
- Undertaking all work with a clear customer focus. Ensuring that all developed solutions are designed to be relevant to the user-base with appropriate levels of end-user documentation, implementation planning, communication, etc.
- Analysis of live platform statistics delivering suggestions and improvements.
- Analysing live platform performance to drive proactive improvements preventing live issues and ensuring SLAs are maintained.
- Analysing and working with significantly complex data often made up from a large number of significantly inter-related sources
- Manage and deliver projects and work packages vital to the Information and Performance team service provision of the Trust.
- Manage the benefits, risks and dependencies of key issues within specific work stream(s).
- Plan and prioritise own work and the work of the team to ensure deadlines are met.
- Meet with external and internal stakeholders to evaluate requirements and organise implementation where deemed required.
- Working collaboratively with other team members to support Trust requirements.
- Leading on any changes to the data architecture of the Trust, planning what resources will be required (human resources, routines/objects, etc.), determining which products will be produced as part of change requests, the deployment lifecycle, what user documentation will be required, what training may be required, etc. i.e. Project Planning (defining project deliverables, success criteria, dependencies, change control).
- Will have overall decision making responsibility for the design and architecture of the Trust data warehouse.
- Taking responsibility for own actions and working under guidance from the posts line manager. For the role, it is expected that the post holder will be provided with an outline of each piece of work from their line manager and guidance as to what should be delivered for that piece of work; beyond that, it is expected that the Data Warehouse Manager will have sufficient ability and confidence to determine and find their way through the development of that piece of work with minimum guidance.
- Seeking out new ways of working and ideas for system improvements whilst adhering to ICT Policies and Procedures.
- Pushing at boundaries and thinking outside the box regarding the introduction of new ideas, tools and techniques that increase the effectiveness of the team to support the Service.
- Becoming a technical specialist of NHS data especially the data flows in and around the Trust.
Person Specification
Education and Qualifications
Essential
- Masters level education in computing, healthcare informatics, or equivalent work experience
Desirable
- Project Management qualification (e.g. Prince2)
- Other computing qualifications (e.g. Microsoft certification)
Trust Values
Essential
- Putting patients first
- Responsive to, and supportive of, patients and staff
- Open, welcoming and honest
- Unfailingly kind, treating everyone with respect, compassion and dignity
- Determined to develop our skills and continuously improve the quality of care
Experience
Essential
- Extensive experience of working with SQL scripting
- Significant experience of administration of MS SQL databases
- Deep understanding of relational database structures and architecture (Indexing, column stores, clustering, partitioning, execution plans)
Desirable
- Experience of the Azure cloud
- Experience using Azure Data Factory to build ETL pipelines
- Line management experience
- Experience of other programming languages
- Experience with NHS data sets
Skills and knowledge
Essential
- SQL Scripting for data and database manipulation
- Understanding of the Software Development Lifecycle
- Knowledge of data warehouse design and data warehousing principles
- Knowledge of relational database design
- Good understanding of version control processes
- Good knowledge of data modelling, e.g. Kimball
Desirable
- Sound knowledge of NHS business environment
- Working knowledge of Dev-Ops practices
- Working knowledge of Agile
- Expert level knowledge of Electronic Patient Records as a developer and analyst
- Working knowledge of the Azure stack
Personal qualities
Essential
- Attention to detail
- Ability to self-organise while dealing with multiple competing priorities
- Able to communicate sometimes complex concepts effectively
- Able to mentor more junior or less experienced colleagues
Person Specification
Education and Qualifications
Essential
- Masters level education in computing, healthcare informatics, or equivalent work experience
Desirable
- Project Management qualification (e.g. Prince2)
- Other computing qualifications (e.g. Microsoft certification)
Trust Values
Essential
- Putting patients first
- Responsive to, and supportive of, patients and staff
- Open, welcoming and honest
- Unfailingly kind, treating everyone with respect, compassion and dignity
- Determined to develop our skills and continuously improve the quality of care
Experience
Essential
- Extensive experience of working with SQL scripting
- Significant experience of administration of MS SQL databases
- Deep understanding of relational database structures and architecture (Indexing, column stores, clustering, partitioning, execution plans)
Desirable
- Experience of the Azure cloud
- Experience using Azure Data Factory to build ETL pipelines
- Line management experience
- Experience of other programming languages
- Experience with NHS data sets
Skills and knowledge
Essential
- SQL Scripting for data and database manipulation
- Understanding of the Software Development Lifecycle
- Knowledge of data warehouse design and data warehousing principles
- Knowledge of relational database design
- Good understanding of version control processes
- Good knowledge of data modelling, e.g. Kimball
Desirable
- Sound knowledge of NHS business environment
- Working knowledge of Dev-Ops practices
- Working knowledge of Agile
- Expert level knowledge of Electronic Patient Records as a developer and analyst
- Working knowledge of the Azure stack
Personal qualities
Essential
- Attention to detail
- Ability to self-organise while dealing with multiple competing priorities
- Able to communicate sometimes complex concepts effectively
- Able to mentor more junior or less experienced colleagues