Job summary
The primary responsibility of the post holder will be to manage the day-to-day operation of the Trust's data warehouse, associated applications and related visualisation products.
Main duties of the job
This will include maintaining the integrity of the data warehouse and to ensure that it remains a trusted single point of truth.
The post holder will be expected to work closely with other teams within the IM&T service in addition to operational and management teams across both the Trust and system partners as appropriate.
They will be expected to support and maintain the data warehouse architecture as well as develop and support, for example, SQL, Dimensional Modelling and ASP.net systems and applications.
They will also be expected to apply best practice to database management, and work closely with the IM&T department to manage system performance.
About us
Kingston Hospital NHS Trust has five key values and we want to employ and work with people who share these values and demonstrate behaviours that support them. They are:
Caring - Design and deliver care around each individual patient's needs and wants.Safe - Make the safety of patients and staff our prime concern as safety comes firstResponsible - All staff take responsibility for the hospital, its services and reputationValue Each Other - Value each other's contributionInspiring - We always strive to empower each other to develop and deliver improvements to benefit our patients
Job description
Job responsibilities
Please ensure that you have read the job description and person specification and that your supporting statement reflects these, as your application will be assessed and scored against these criteria.
Job description
Job responsibilities
Please ensure that you have read the job description and person specification and that your supporting statement reflects these, as your application will be assessed and scored against these criteria.
Person Specification
Education
Essential
- Educated to degree level in a numerate/quantitative discipline or demonstrable equivalent experience and competencies in relevant or similar roles.
- Evidence of continuing professional development
Desirable
- Qualified at practitioner level of a recognised project management methodology.
- IT, Information or statistical qualification
Knowledge
Essential
- Adequate experience required on data analysis - extracting, analysing and presenting
- Adequate experience required in managing the development business intelligence applications including relevant documentation.
- Excellent understanding of NHS Data and NHS Data Dictionary
- SQL for the production of datasets and database manipulation
- SQL Server Data Tools for the development of SSIS, SSRS or SSAS packages.
- Can implement and execute Database recovery plans
- Knowledge of NHS Information requirements and experience of statutory reporting.
- Experience of creating and maintaining BI Data Marts based on the principles of dimensional modelling.
- Experience of using and developing on other third party Analysis tools. Examples include Qlikview, PowerBI
- Experience of documenting Database processes as well as Standard Operation Procedures and change control processes
- Experience of creating Data Quality for monitoring ETL loads.
Skills
Essential
- Excellent customer relationship and communication skills
- Be able to manage diverse workloads, including competing priorities
- Ability to work on own initiative and to be accountable for own actions including the prioritisation of workload.
- To be able communicate clearly and effectively with all internal and external staff.
- Ability to communicate complex information effectively a range of Trust staff including Senior Managers, Analysts, Clinicians and Operational staff as well as other external NHS members of authority.
- Knowledge of system documentation and change control procedures.
- Highly numerate with knowledge of good practices in Data Warehouse design.
Person Specification
Education
Essential
- Educated to degree level in a numerate/quantitative discipline or demonstrable equivalent experience and competencies in relevant or similar roles.
- Evidence of continuing professional development
Desirable
- Qualified at practitioner level of a recognised project management methodology.
- IT, Information or statistical qualification
Knowledge
Essential
- Adequate experience required on data analysis - extracting, analysing and presenting
- Adequate experience required in managing the development business intelligence applications including relevant documentation.
- Excellent understanding of NHS Data and NHS Data Dictionary
- SQL for the production of datasets and database manipulation
- SQL Server Data Tools for the development of SSIS, SSRS or SSAS packages.
- Can implement and execute Database recovery plans
- Knowledge of NHS Information requirements and experience of statutory reporting.
- Experience of creating and maintaining BI Data Marts based on the principles of dimensional modelling.
- Experience of using and developing on other third party Analysis tools. Examples include Qlikview, PowerBI
- Experience of documenting Database processes as well as Standard Operation Procedures and change control processes
- Experience of creating Data Quality for monitoring ETL loads.
Skills
Essential
- Excellent customer relationship and communication skills
- Be able to manage diverse workloads, including competing priorities
- Ability to work on own initiative and to be accountable for own actions including the prioritisation of workload.
- To be able communicate clearly and effectively with all internal and external staff.
- Ability to communicate complex information effectively a range of Trust staff including Senior Managers, Analysts, Clinicians and Operational staff as well as other external NHS members of authority.
- Knowledge of system documentation and change control procedures.
- Highly numerate with knowledge of good practices in Data Warehouse design.
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.
