Business Intelligence - Avon and Somerset Constabulary - Office for Data Analytics

Tender description

Summary of the work Provide Business Intelligence development support for the ODA and act as a delivery partner in the development of ODA Technical Output for a period of two years. The ODA will commission statements of work during the course of the Contract to define specific requirements on project work and deliverables. Expected Contract Length 2 years from contract award Latest start date Monday 18 March 2019 Budget Range The capped value of this Contract is £150,000. Why the Work is Being Done In November 2017, Avon and Somerset were awarded a Police Transformation Fund (PTF) allocation to create, deploy and sustain an analytics capability to support multi-agency working across the South West region. Now termed the Office for Data Analytics (ODA), this team has worked closely with Partners to share data and provide insight to enable early interventions, reduce risk and improve social outcomes. The Office for Data Analytics will inform and drive reductions in vulnerability within communities by helping leaders to reform service provision, improve outcomes and reduce costs through the effective use of data across partner agencies. Problem to Be Solved The initial services offered by the ODA to Partners in 2019/20 are detailed below: Stakeholder management Visualisation projects Partner on-boarding and relationship management Strategic programme governance Analytics projects and ad-hoc analytics Visualisation as a service Promote to production Information governance and GDPR compliance In order to deliver these services the ODA maintains the following capabilities: Business Intelligence (BI): Tasked with developing visualisation projects and providing visualisation as a service to Partners. Data Science (DS): Tasked with analytics projects and ad-hoc analytics through the application of data science methodologies such as machine learning and predictive analytics. Who Are the Users The ODA collaborates with Partners to bring together disparate datasets that, when collated, can provide greater insight to Users in order to inform better decision making. This is achieved through visualising the data and applying data science methodologies. Existing Team Partners are primarily located within the South West region; however, the ODA has established Partners located outside of the region. It is anticipated that the number of Partners will continue to grow outside of the South West over the course of the Contract. The ODA will maintain a small, permanent team to conduct business analysis. The team will develop projects to the point of development, when statements of work will be drafted in order that the Supplier can be engaged to cost and subsequently provide business intelligence outcomes under this Contract. Current Phase Live Skills & Experience • The Supplier shall work as part of a team of contractors (including business analysts and business intelligence developers) to develop meaningful insights into data, providing value to Partners. • The Supplier shall design, develop and maintain applications developed through the ODA’s data visualisation platform, QlikSense. • The Supplier shall support the business analyst, providing technical knowledge and expertise when interacting with Partners and Users to develop use cases and requirements for development. • The Supplier shall be proactive in recommending improvement projects that further enhance the ODA’s ability to deliver a quality standard of service to Partners and Users. • The Supplier shall possess a working knowledge of QlikSense and QlikGeoAnalytics. • The Supplier shall operate using an ‘agile’ approach to delivery. Nice to Haves • The Supplier shall test, debug, and build code that works across multiple browsers and digital platforms, develop database-driven applications and use external APIs to generate quality applications. • The Supplier shall have a good understanding of design and user experience principles. • The Supplier shall have lead times of a maximum of two weeks as statements of work are generated. Work Location Avon and Somerset Police HQ, Valley Road, Portishead, BS20 8QJ Working Arrangments All personnel provided by the Supplier shall be based at Avon and Somerset HQ, Portishead. Security Clearance Any personnel who carry out work as part of this Contract must be vetted to NPPV Level 2. Vetting can be reviewed at any time by the Authority. ODA will progress Vetting procedures with the Authority for personnel who do not possess adequate clearances prior to commencing statements of work. Additional T&Cs To be discussed with successful provider No. of Suppliers to Evaluate 3 Proposal Criteria • Technical Solution • Approach and methodology • Value for money Cultural Fit Criteria • The Supplier shall have experience of operating in a law enforcement and local government domain. • The Supplier shall have significant and extensive experience and knowledge of working in data analytics and the application of business intelligence development to complex problem solving. Payment Approach Fixed price Evaluation Weighting Technical competence 40% Cultural fit 20% Price 40% Questions from Suppliers 1. Can we ask how many QlikSense consultants are required for this contract, if they are required full-time (or ad hoc) and whether they need to be located on-site? This will be a call-off arrangement and resource allocation will be required based on work volume and capacity, therefore multiple consultants may be required. ASC HQ (Portishead site) will be the primary work location however working remotely is possible. 2. Are you asking for a single person to support the requirement, or would a team of relevant experts that you can draw down to support projects be suitable? A team would be suitable / preferable.