Digital outcome specalists to design and develop a new in house data warehouse

Tender description

Why the Work is Being Done The Trust currently has what would be widely known in the industry as a ‘reporting database’ that has evolved organically from former MS Excel and MS Access data repositories and eventually became reported from MS SQL Server, the industry standard product. While the product is modern, the data architecture (how the data is stored, structured and designed) is not. Therefore there is a requirement to move to a fully modelled data warehouse where the data structures underlying reporting, are designed based on the Trust’s business requirements. Problem to Be Solved The primary aim of this project is to provide a stable, consolidated, structured data warehousing model which will: • Provide a transparent view of patient care and all associated activity captured across the various systems in use within the Trust • Facilitate the provision of nationally mandated submission datasets • Facilitate the provision of as much automatically delivered routine reporting as possible • Underpin the Trust’s statutory reporting and commissioning requirements • Simplify the complexities of reporting ensuring accuracy and also a reduction in the amount of time required to turnaround routine reporting requests Who Are the Users SaTH staff from all disciplines, and external organisations within in the local STP. The data warehouse design must move to a fully modelled data warehouse (adopting industry standard methodologies), where data feeds are independent of the upper layers in the data warehouse and onward reporting, and can be plugged in or out as Trust systems change and develop. Early Market Engagement Work Already Done Existing Team The supplier will work with internal multi disciplinary teams. Current Phase Not started Work Location The Shrewsbury and Telford Hospital NHS Trust. There are three main locations as follows; The Royal Shrewsbury Hospital, Mytton Oak Rd, Shrewsbury SY3 8XQ. The Princess Royal Hospital, Apley Castle, Apley, Telford TF1 6TF. Shrewsbury Business Park, 1&2 Douglas Court, Anchorage Avenue, Shrewsbury, Shropshire SY2 6LG. Working Arrangments The people will keep SaTH standard admin team hours in order to maximise knowledge transfer and integrate with team development processes: Monday to Friday based in our office starting work by 9.00am, 7.5 hours per day + lunch time (30 mins). There may be an expectation to work extended hours to support the implementation. Security Clearance All staff working on site MUST be DBS cleared. Additional T&Cs All vendors are obliged to provide sufficient guarantees to implement appropriate technical and organisational measures so that the processing meets the requirements of GDPR and ensures the protection of the rights of data subjects. For further information please see the Information Commissioner's Office website:https://ico.org.uk/for-organisations/data-protection-reform/overview-of-the-gdpr/ Skills & Experience Experience Architecting flexible, scalable data warehousing solutions Experience implementing full stack SQL server data warehousing infrastructures in both green and brownfield environments Extensive experience of ETL and ELT data consolidation and transformation techniques with data stored in both structured and unstructured sources Data modelling experience in multi platform, multi system,multi disciplinary environments Project management, team building / management / mentoring experience Experience implementing change management software, associated processes and controls Full lifecycle software development experience Within the last 4 years, EPR and PAS migration experience with specific focus on data warehouse integration Experience collaborating with 3rd party suppliers Track record of delivering large scale projects into NHS environments Nice to Haves No. of Suppliers to Evaluate 3 Proposal Criteria Provide details of the Technical Competence and Relevant Skills relevant to the following 3 area’s, Core SQL, data warehousing & technical skills. Provide details of your proposed methodology and approach to data warehousing implementation drawing from previous experience. Provide details of your proposed methodology and approach to sustaining data warehousing business continuity during EPR implementation. Provide details of the approach and methodology you would use the deliver the requirement. This should include suggested SLA’s to show how the project will be monitored and managed. identify risks and dependencies and how will you manage them to ensure project delivery on time and budget. Provide the proposed team structure and governance arrangements including proposed escalation process. Please detail how you will ensure value for money and how you will bring the project in, on time and under budget. Cultural Fit Criteria The supplier must mirror the Trust values, Proud to Care, Together We Acheive, Make It Happen, We Value Respect. Work Transparently and collaborativley to ensure a seamless transition to BAU team. Payment Approach Fixed price Assessment Method Written proposal Case study Work history Reference Evaluation Weighting Technical competence 60% Cultural fit 5% Price 35% Questions from Suppliers Budget range up to £813,000