Data Analytics Hub Extended Support

Tender description

Why the Work is Being Done The Data Analytics Hub has been built to provide a single source of truth (sourced from internally and externally sourced datasets) which has been quality assured for all organisational and system wide reporting. The current support provided by a development partner will end the 31st Oct 2016. This procurement will select the next development partner to provide support and enhancements to The Data Analytics Hub from 1st Oct 2016 to 30 June 2017 (with a month of overlap for KT and Handover taken into account). Problem to Be Solved BAU Support Support the shared platform in order to ensure a responsive service to critical programmes (including but not limited to): Carter Program, Cost Transformation Program (PLICS), Benchmarking Tools, Single Oversight Framework Support the analytical products developed (including but not limited to): Hes Browser, reference cost browser, patient experience, ECIP. Enhancements Data platform to cater for near real time data feeds Automation framework to improve responsiveness of support Improve load performance for large datasets in order to support patient level costing collections New developments Integrate on-line form data collections to support emergency care reporting Data Mart creation for new projects Who Are the Users As Director of Data Warehousing and Development I need a flexible team to provide technical support to enhance and maintain the Data Analytics Hub from the 1st Oct. 2016 until 30 June 2017 so NHSI can comply its regulatory obligations and Internal projects. Early Market Engagement Work Already Done Existing Team The supplier will be working closely with two product owners, one analyst, data architect and the enterprise architect. Current Phase Live Work Location Wellington House 133-155 Waterloo Road London SE18UG Working Arrangments The current team supporting the platform for the last year includes: 1 Senior Scrum Master (onsite) 1 Senior Analyst (onsite) 1 Solutions Architect (onsite ) 8 Senior BI Developers (offshore) 3 Senior QA (Offshore) This team had proven to be sufficient for the regular workload, although we have scaled it up or down depending of NHSI internal demand. We would like to maintain the same team structure but we will evaluate any alternative arrangements proposed by the suppliers. Security Clearance Additional T&Cs Please include in the written proposal a total price with a breakdown (day-rate / role type ) based on the team described under the summary section for the period 1st Oct. 2016 until 30 June 2017 (approx. 188 days). Please notice 1) The team could be a mixed offshore/onsite model 2) The actual team will be arranged based on the SoW and work-packages that will be issued depending on NHSI internal Data Analytics demands. Skills & Experience At least one year of experience of Microsoft SQL Server development on APS platform (20 Points) At least two years in software development with NHS datasets (10 Points) At least one year Development, performance management and troubleshooting experience on Microsoft APS platform (10 Points) At least one live project using Data Vault as data model running on Microsoft APS technology (15 points) At least one year experience in Data Load Optimization using Data Vault and Microsoft APS (5 points) At least one live project implementing Master Data Management Solutions using Microsoft MDS (5 points) At least two years of solid experience in BIML framework (25 points) Use of source control and PBI planning using TFS (10 points) Nice to Haves Experience with BI visualization tools (Tableau, qlik) (10 points) Experience using Alteryx or similar tools for data blending (10 points) No. of Suppliers to Evaluate 3 Proposal Criteria Technical Solution (30 Points) Approach and metodology (30 Points) Team Structure (30) Value for money (10) Cultural Fit Criteria Work as a team with our organization Use Agile principles as fundation of work Payment Approach Time and materials Assessment Method Written proposal Presentation Evaluation Weighting Technical competence 50% Cultural fit 20% Price 30% Questions from Suppliers Budget range