Breathing Space Scheme - Enterprise Reporting Requirements copy

Tender description

Why the Work is Being Done Breathing Space was a 2017 manifesto commitment by the Government. It gives people in problem debt the opportunity to take control of their finances and put them on a sustainable footing. Breathing Space will be introduced by Government legislation with a mandatory go-live date of April 2021. The Insolvency Service has been tasked with the administering the service and therefore delivering and running a (Digital First) service on behalf of citizens in England and Wales. Expected volumes of BSS applications is expected to be around 750,000 year 1 with volumes rising by between 5 and 10% year on year. Problem to Be Solved The Insolvency Service is transforming the way it thinks about data. It has a strategy on how it intends to improve the way it uses data, gaining more value out of its operational processes and enhancing the way in which it can use reporting for greater insights. Outside of the Breathing Space service itself, the new Breathing Space service has operational reporting needs to meet the expectations of both internal and external stakeholders. To align to the agency’s future vision, it has a need to design, build and deliver a suitable data warehouse, master data hub and reporting interface to meet both the initial and future operational reporting and data management needs of the Breathing Space service. In order to achieve this, the solution must adhere to the principles laid out in the Agency’s Data & Reporting strategy. Summary Scope: Technical: Familiarisation, Design, Build, Test (support UAT, Integration, Performance, etc.) Deployment, Hypercare & Documentation. Business: Acceptance Criteria Definition, Sign-offs, Show & Tells, Training Package, Deployment support, Guides, etc.) Governance: Supporting security reviews, supporting penetration testing, supporting architectural and design documents, team meeting participation, written/verbal reporting (progress/Risks/Issues), GDS & OGC Assessments (if applicable). Who Are the Users As a Reporting Consumer I need to have timely access to accurate live and/or historic data, reports and dashboards relevant to me. So that I can be confident that the service is operating as per the expectations of our users As a Data Custodian I need access to be confident in the confidentiality, integrity and availability of data I own across the Breathing Space service So that I can provide safe stewardship of the data used within my area of ownership. As a Data Engineer I need to be able to: schedule, monitor, and make changes to ETL processes; amend master data specifications; export data into other formats So that report developers and analysts can deliver reporting products and analysis to users As a Report Developer I need to be able to create, modify and publish reports and dashboards So that reporting consumers have access to accurate operational reports and dashboards relevant to them As a Data Analyst I need to use analytical tool to connect to the data warehouse to undertake bespoke analysis of record-level data So that operational leads and senior managers can derive actionable insight from the data Early Market Engagement Work Already Done The agency has completed a Discovery Phase and is progressing the Alpha Phase (due to complete June 2020). A future state Data & Reporting Strategy has been identified by the Agency which frames the solution and what the Agency’s vision is for getting the most out of its data. The proposed architecture is built upon the Microsoft BI platform, which has good synergy with the existing Agency investment in the Azure Cloud and Microsoft 365 platform. The project team is seeking ratification on this technology as part of the supplier’s deliverables. Existing Team The agency has a project team established and progressing the Alpha Phase deliveries. Current Phase Alpha Work Location The work is planned to be carried out primarily in Birmingham and/or London (exact location to be decided) – any applicant must state whether they can work from either of these locations. However due to Covid-19 restrictions at this time, appropriate arrangements to reduce travel to the office to an absolute essential minimum until such restrictions are lifted must be demonstrated to the Insolvency Service. As such, any successful supplier must be able to facilitate remote working into their delivery model. Working Arrangments Initiation workshop(s) will be organised to kick-off the engagement, agree working practises and generate a plan to be tracked and managed against. VC’s will be utilised for remote team communications, with ability to securely remotely login into appropriate Agency’s infrastructure platform for deployment. Work with internal team (product Owner, etc.) for sprint ceremonies, ‘Show & Tells’, etc. Security Clearance Min. BPSS, limited engagements may need SC. Supplier must be willing and able to undergo to SC clearance if / when required under this contract. Additional T&Cs Skills & Experience Be a Microsoft Gold Partner with proven Data Analytics competency in Go Live, Hypercare, Training, User Guides and Service Calls. Have experience of analytics Platform design, build, test and Deployment experience Have specialist Knowledge of Microsoft BI Technologies (SSDB, SSIS, SSAS, SSRS, Power BI) Have knowledge of Data repositories e.g. Data Lake, Data Marts, Data Store, MDM Repository Have experience in building and deployment of custom Data quality and Master Data Management systems Have experience in creation of a Kimball based Datawarehouse for MS Dynamics 365 as primary source Have experience of Data Modelling with Star / Snowflake diagrams Dimensional Data Modelling, Bus Architecture Scheme Have experience in Devops principles and practices and applying same to data warehousing deployments Have experience in declarative based development using Visual Studio Have experience of use of GITHub/TFS/VSTS with good understanding of code merges, builds, unit tests Have understanding of branching strategies in management of code and application lifecycle Have experience with Data Migration tools such as Kingswaysoft Have experience of usage and skills across DAX, MDX, T-SQL, SSIS, USQL, XML, JSON, Powershell, C# Have an understanding of core database and server administration skills such as creation of databases, filegroups, datafiles, SQL Jobs Have experience of supporting Knowledge Transfer for support providers to enable the solution to be handed over to the agency's ADSM support providers and service desk. Have experience of supporting Internal Teams to upskill on approach, methodology, technology, configuration and support. Have experience of IT Security (including reviews and penetration testing). Have experience of Agile Methodology Have experience of assurance through Architectural Review Boards, GDS and OGC Gateways Nice to Haves Demonstrate experience of working with public sector organisations on Government Digital Services. Demonstrate knowledge of UML and Archimate. No. of Suppliers to Evaluate 5 Proposal Criteria Demonstrate experience in developing solutions with the listed technologies. Demonstrate experience in integration with back-end systems in the chosen technology. Demonstrate experience in iteratively building (during project lifecycle) the solution based on feedback and input from user researchers, interaction/content designers, business requirements based on User Stories. Demonstrate experience in JIRA to manage and track development and testing. Describe how you typically handle hypercare/warranty with your customers. Provide clear plans that align to the agency timeline, including contingency Provide a clear, proposed project approach, integration approach with the project team and governance activities. Cultural Fit Criteria Have experience of similar size organisations and integration with existing project team. Aligned company values and culture (outline your values and how this aligns with the Agency's values and culture). Openness and approach to knowledge transfer and training Timeliness and effectiveness of communication. Willingness to engage as a partner. Payment Approach Capped time and materials Assessment Method Case study Presentation Evaluation Weighting Technical competence 60% Cultural fit 20% Price 20% Questions from Suppliers No questions have been answered yet Budget range