Development and Support for Data Analytics Hub

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 to support internal and nationwide programs. The current support provided by a development partner will end the 31st Aug 2017. This procurement will select the next development partner to provide support to The Data Analytics Hub from 1st July 2017 to 30 June 2019 (with two months of overlap for KT and Handover taken into account). Problem to Be Solved New development and BAU support to ensure a responsive service to critical data driven programmes including, but not limited to,: Model Hospital, Cost Transformation Program (PLICS), NRLS, Single Oversight Framework and other analytical products developed and used by NHSI such as operational performance & quality dashboards, financial and performance monitoring and benchmarking and improvement services. Rapid, scalable and automated data collection, extraction, processing and presentation are critical deliverables to reduce burden, improve responsiveness and manage significant and increasing load. Solutions developed must build on the core to managed scaled data marts underpinning multiple self-serve and central analytics services. Who Are the Users “As users of the single data store, variant user types need to view, retrieve, process, interrogate and interpret data so that they can better understand operating activities within the NHS and support improvement in service delivery and financial sustainability. As Director of Data Warehousing and Development I need a flexible team to provide new development and technical support to enhance and maintain the Data Analytics Hub from the 1st July 2017 until 30 June 2019 so NHSI can comply its regulatory obligations and support programs covered in the NHS Five Year Forward View” Early Market Engagement Work Already Done Existing Team The supplier will be working closely with a Product Manager (Data Warehousing), one analyst, data architect and the enterprise architect. The supplier will be part of other already formed teams according to demand. Current Phase Not applicable Work Location Wellington House 133-155 Waterloo Road London SE18UG Onsite / Offshore model will be ideal. Working Arrangments The current team supporting the platform for the last year includes: Fifteen (15) Offshore and twelve (12) onsite resources as follows: (Skill, Offshore, Onsite): .Net Developer 1 1 BI Developer 8 2 Business Analyst 0 1 DevOps 0 1 Project Manager 0 1 Python Developer 2 1 Scrum Master 0 2 Tableau Developer 0 1 Technical Analyst 0 2 Tester 4 0 Grand Total 15 12 Security Clearance Additional T&Cs Skills & Experience At least two years 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) Experience with BI visualization tools Tableau (10 points) Experience using Alteryx or similar tools for data blending (10 points) At least two live projects using Python (20 Points) Nice to Haves No. of Suppliers to Evaluate 3 Proposal Criteria Technical Solution (30 Points) Approach and methodology (30 Points) Team Structure and Mobilisation time (30) Value for money (10) Cultural Fit Criteria Work as a team with our organisation and other suppliers (30) Share knowledge and experience with other team members (30) Challenge the status quo (30) Can work with clients with low technical expertise (10) 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 up to £3.5 million subject to approvals and expectation of call off up to – not commitment to spend the numbers