DFID Aid Management Service Team

Tender description

Why the Work is Being Done DFID’s in-house development team are developing a range of applications to support international development activities, particularly programme management and management information. DFID seeks specialist input to support the team in delivering to an ambitious agenda using modern methods and cloud tools. Problem to Be Solved DFID wishes to improve the capability of DFID’s existing aid management and management information platforms through: Developing and implementing an evolution of the technical application architecture for the Aid Management Platform (AMP) to improve modularity and separation of services. The current architecture is a monolithic ASP.NET MVC implementation, but we have defined a new architecture based upon SOLID and Clean Architecture principles – the new architecture now requires strong technical leadership. Developing core business features in the existing Aid Management Platform solution, in line with the objectives defined in the AMP Business Case. Implementing a set of practices and tools to embed quality, support continuous integration and continuous deployment using Microsoft Azure DevOps. Building data pipelines within Microsoft Azure to support data warehousing, relational and dimensional querying, supporting end user data needs through APIs, datasets or Power BI. Design and development of MI/data reporting layer that meets high end self service reporting user needs and ensures integrity of underlying datasets. Who Are the Users End users are DFID staff who manage planning, delivery and monitoring of UK development programmes. AMP architecture team need to implement a modular architecture in .NET Core, based on SOLID and Clean Architecture principles, with a clear migration path to Azure hosting. Appropriate elements of Microservice architecture must be considered now to ensure easy integration at a later stage. Additionally, development resource is required to compensate for a reduction in team capacity. responsible for delivering core business as usual features using latest Microsoft web technology stack and C#. Continuous deployment team needs to migrate code repositories from SubVersion to GitHub, then define Continuous Integration/Continuous Deployment pipelines running on Azure Dev Ops. They must integrate unit, integration and UI level tests with the CI/CD pipeline and control deployments to test/live environments. This includes improving the current live environment set up to accommodate staging and live “switch-over” deployment or something similarly robust. Data engineering team need to build data pipelines on Azure to replace existing SQL Server ETL routines. This includes using appropriate services within the Azure Data Factory (ADF) on a DFID live tenant environment to accommodate data lake storage into staging tables on Microsoft Azure SQL Database as appropriate Early Market Engagement Work Already Done AMP architecture future state has been defined, a full-stack slice is developed. The model has been communicated. The AMP team’s capacity will reduce starting Jan 2020 during a period of planned rapid delivery of core business features. Team Foundation Server (TFS) 2017 (precursor to Azure DevOps Server) has been implemented and is used for Boards functionality. Two smaller codebases have moved to Git repositories on to TFS. Testing has been carried out on build and pipeline creation, but is not currently operational. An Azure development instance has been created for data pipelines and current ETL processes are very well understood. Existing Team AMP and DevOps: The team consists of seven developers, 2 testers, 3 business analysts, a product owner and a programme delivery specialist. The test manager has taken many release and TFS duties. Data Engineering: The team has 5 data engineers, 3 data scientists and a business analyst. Both teams operate an agile methodology based on Scrum, and wish to release value early to end users. Current Phase Live Work Location Department for International Development, Abercrombie House, Eaglesham Road, East Kilbride G75 8EA Working Arrangments The team should be co-located with the DFID team at Abercrombie House for at least 3 days per week, with scope to work offsite for 2 days per week. DFID operate flexible working including the extensive use of Microsoft Teams for collaboration. Security Clearance All staff should have Baseline Personnel Security Standard (BPSS) clearance, involving identity checks, criminal record checks and references. Additional T&Cs Skills & Experience Strong communication and collaboration skills. Agile methodologies and delivery experience. Modelling and visualising data and solution concepts Designing and implementing .NET framework and .NET Core systems that conform to SOLID and Clean Architecture principles A clear understanding of how such an implementation should be designed to be deployable and scalable on Azure and / or AWS is essential. (with regards point 4.) Proficiency at delivering web solutions using Microsoft web technologies, employing appropriate design patterns and delivering within an Agile team. Implementation of DevOps practices to support continuous integration and deployment using Microsoft Azure WebOps. Experience of building assets in Microsoft Azure specifically for accessing data storage from an existing corporate tenant database and data lake. Experience of processing of data using Azure Data Factory tools into Microsoft Azure SQL Database. Nice to Haves Knowledge of Microservices architectures, their key components, the pros and cons of these, and how they could be applied where appropriate to the AMP system. Azure Data Factory , DataBricks or Jupyter Notebooks for Spark XML file parsing. No. of Suppliers to Evaluate 10 Proposal Criteria Client case studies of similar work Technical capability – essential and desirable skills and experience Approach and methodology How the approach or solution meets our user needs, policy or goal Team structure Value for money Availability for the period required Up to 5 suppliers invited to Telephone interview Cultural Fit Criteria Work as a team with our organisation Evidence of managing delivery in an agile environment Evidence of knowledge and skills transfer, equipping DFID’s internal team Take responsibility for their work Payment Approach Time and materials Assessment Method Evaluation Weighting Technical competence 60% Cultural fit 20% Price 20% Questions from Suppliers No questions have been answered yet Budget range