Clinical Research Front-End Query Builder - Technology Refresh

Tender description

Why the Work is Being Done We are looking to engage a technical partner to develop, deploy and (potentially) provide on-going support for a bespoke web-based query builder that will sit on top of an existing SQL Server database. This development is the final phase of a wider technology refresh programme. The query builder, already known as CRIS (the Case Register Interactive Search), will replace an existing and well-established product that has been successfully in use for c.10 years but is sitting over a data repository that is no longer supported (Microsoft FAST). Problem to Be Solved CRIS is used to access clinical data for research purposes. The new CRIS will provide query access to de-identified clinical data from local electronic health records stored in an existing SQL Server database. The principle source database currently consists of c.150 separate tables, each containing patient level data from the records of c.350000 patients with a size of c.150 GB. On the existing CRIS c.25000 queries have been carried out by c.150 distinct users over the last 12 months. The query builder and its source SQL Server data base are likely to be deployed in the Azure cloud. Who Are the Users Users will be academic researchers and local NHS Trust staff. In essence the query builder will enable users to: - define specific cohorts of patients based on criteria/filters from or more columns from any table(s) across the DB, including structured fields (e.g. date, int) and unstructured text fields (e.g. text, varchar (max)), - to return specific fields (columns) for the cohort identified from any table across the whole database, including those used to define the cohort, - To render results in a user-friendly (‘readable’) format, including unstructured text with string highlighting. - To export results, e.g. in csv format. Early Market Engagement An initial technology review has already been undertaken and recommended a deployment in Azure on Micosoft SQL Server. Work Already Done Different data repositories were considered and tested, including open source RDBS and dedicated search platforms. The recommendation was made through consideration of the starting point for the project plus minimum performance requirements, including free text search. Existing Team The Supplier will be working with Team members from Trust Communications and supported by Information Technology. Current Phase Alpha Work Location The South London & Maudsley NHS Foundation Trust, The Maudsley Hospital, Denmark Hill, Camberwell, London SE5 8AZ. Working Arrangments We would like the supplier working at a location near the Maudsley Campus, Denmark Hill, Camberwell SE5, to enable interaction with key users/stakeholders and user groups. Security Clearance A separate Data Sharing Agreement will be required between SLaM and Supplier. Additional T&Cs Skills & Experience Experience of successfully concluding projects in this area. Experience in the deployment of solutions in this area. Experience of Microsoft Azure. Nice to Haves Demonstrate an understanding of NHS and healthcare An understanding of the requirements provided in this document Clarity over how you would typically undertake a project of this nature. Expected costs for a project of this nature and the basis upon which you make a commercial offer. Any innovation, including innovative ways this project can be achieved. No. of Suppliers to Evaluate 5 Proposal Criteria Quality & Technical Requirements (60%) Cultural fit (15%) Value for money (25%) Cultural Fit Criteria Transparent and collaborative when making decisions Work as a team in a collaborative manner with the Trust and any other suppliers Payment Approach Capped time and materials Assessment Method Written proposal Case study Work history Reference Presentation Evaluation Weighting Technical competence 60% Cultural fit 15% Price 25% Questions from Suppliers Budget range £100k - £150k