Job summary
The Care Coordination Solution (CCS) is a module designed as part of the development of the Federated Data Platform. The Inpatient and Referral To Treatment (RTT) elements of that module are being implemented into the trust as part of a workstream designed to improve patient flow and patient experience.
This is part of our vision is to create a digitally enabled organisation that supports the delivery of efficient and effective patient care. We aim to achieve this through easy-to-use systems that provide staff and patients with access to the right information, in the right place, at the right time. To help us to achieve this vision, we are looking for passionate individuals to join our team.
Patients are at the centre of everything we do. Our integrated CCS will help us to ensure that we continue to improve our delivery of services and treatment plans around patient needs. The EPR is designed to wrap around our specialist ophthalmology clinical noting system, OpenEyes, to provide a seamlessly integrated patient record system.
Main duties of the job
This particular post will sit across the Data Warehouse and Information teams of the Performance & Information department and will work closely with the System Supplier (Palantir), CCS Implementation Team, IT Systems owners, developers and users to ensure appropriate development of the data warehousing element of the CCS implementation project.
Build the appropriate data tables, in an SQL environment, to capture the data required for thesuccessful operation of the Care Coordination System. All scripting should be structured andclearly commented, to ensure scalability and transferability for potential future development.
Ensure regular refreshes of the data tables as a minimum daily working towards an hourlydata refresh using near live data. Be instrumental in the development of the methodology fordata transfer to the new system i.e. which data can be automated, and which must bemanually entered.
Ensure a full specification for the data warehouse element of the CCS project is developedand approved by the project team and Palantir
Ensure full documentation of the table development and ensure that this is regularly updatedto capture any version changes or new requirements
Ensure that all stakeholders are aware of the data curation and the supply methodologies.
Ensure that data quality metrics are available and liaise with the trusts data quality team regarding required improvements.
About us
At Moorfields, we provide more than just an excellent career and great colleagues to work with. We also offer:
- Salary including High-Cost Area Supplement
- Opportunity to join the NHS Pension Scheme
- Free 24/7 independent counselling service
- Learning and development opportunities
- Easy and quick transport links
- A range of attractive benefits and discounts
- Access to Blue Light Card and other NHS Discount Schemes
- Free Pilates classes
- Full support and training to develop your skills
- Flexible working friendly organisation
And so much more! To see the full range of benefits we offer please see our Moorfields benefits document.
Job description
Job responsibilities
Liaise with a range of stakeholders to ensure that the data laid out in the requirements are fitfor purpose.
Ensure liaison with the trusts Information team to ensure that data flows and data usage aredocumented and understood.
Report regularly to the CCS Project Board to update on progress of development.
Ensure that the table completion and data-flow are sustainable without recourse to additionalstaffing resources.
Ensure that all work is compatible with a potential relocation of the current data warehouseinto a Cloud environment.
To ensure liaison with other trust project with a view to identifying synergies or duplications ofeffort.
Represent the trust with external partners and suppliers to ensure that all issues are dealtwith professionally.
Job description
Job responsibilities
Liaise with a range of stakeholders to ensure that the data laid out in the requirements are fitfor purpose.
Ensure liaison with the trusts Information team to ensure that data flows and data usage aredocumented and understood.
Report regularly to the CCS Project Board to update on progress of development.
Ensure that the table completion and data-flow are sustainable without recourse to additionalstaffing resources.
Ensure that all work is compatible with a potential relocation of the current data warehouseinto a Cloud environment.
To ensure liaison with other trust project with a view to identifying synergies or duplications ofeffort.
Represent the trust with external partners and suppliers to ensure that all issues are dealtwith professionally.
Person Specification
Education / Qualifications
Essential
- A Masters' degree in a data technology related discipline or equivalent relevant experience.
- Expert status in the use MS-SQL, SSRS and Data Warehouse functions.
- Registered with a relevant informatics professional body
Experience
Essential
- Significant experience in similar environment or system
- Extensive familiarity with complex computerised data warehouse structures.
- Experience of designing, coding, testing and implementation of efficient and robust database schemas.
- Extensive experience of SQL Database Administrator tools and utilities including advanced scripting and basic coding.
- Experience of supporting the transition of products from Delivery into Live Service
Knowledge
Essential
- Knowledge of the information needs and processes of the Clinical and Operational functions within an Acute hospital.
- Expert knowledge of the NHS Data requirements, Information Standards and data flows gained through at least 2 years in an NHS data warehousing role.
- Proven ability to lead, influence and motivate with project / resource planning experience.
Skills & ability
Essential
- A logical and analytical approach to problem solving demonstrated in an Information Systems environment.
- Independent self-starter, able to work with a high level of autonomy.
- Strong drive for accuracy, performance, and improvement. With the ability to remain flexible and have a resilient approach, able to work under pressure.
- Ability to make decisions autonomously, when required, on difficult issues.
- Excellent Business Analysis skills: able to produce metrics, analyse and interpret information and produce regular reports.
- Ability to make and communicate decisions on difficult issues where there may be several courses of action responding openly to questions to ensure full understanding and engagement.
- Excellent written and verbal communication skills suitable for a range of audiences.
- Proven track record of identifying and solving data quality issues arising from aligning data sources and data targets.
Person Specification
Education / Qualifications
Essential
- A Masters' degree in a data technology related discipline or equivalent relevant experience.
- Expert status in the use MS-SQL, SSRS and Data Warehouse functions.
- Registered with a relevant informatics professional body
Experience
Essential
- Significant experience in similar environment or system
- Extensive familiarity with complex computerised data warehouse structures.
- Experience of designing, coding, testing and implementation of efficient and robust database schemas.
- Extensive experience of SQL Database Administrator tools and utilities including advanced scripting and basic coding.
- Experience of supporting the transition of products from Delivery into Live Service
Knowledge
Essential
- Knowledge of the information needs and processes of the Clinical and Operational functions within an Acute hospital.
- Expert knowledge of the NHS Data requirements, Information Standards and data flows gained through at least 2 years in an NHS data warehousing role.
- Proven ability to lead, influence and motivate with project / resource planning experience.
Skills & ability
Essential
- A logical and analytical approach to problem solving demonstrated in an Information Systems environment.
- Independent self-starter, able to work with a high level of autonomy.
- Strong drive for accuracy, performance, and improvement. With the ability to remain flexible and have a resilient approach, able to work under pressure.
- Ability to make decisions autonomously, when required, on difficult issues.
- Excellent Business Analysis skills: able to produce metrics, analyse and interpret information and produce regular reports.
- Ability to make and communicate decisions on difficult issues where there may be several courses of action responding openly to questions to ensure full understanding and engagement.
- Excellent written and verbal communication skills suitable for a range of audiences.
- Proven track record of identifying and solving data quality issues arising from aligning data sources and data targets.
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.
