The Open Contracting Partnership is seeking a software development team with expertise in data dashboard design and development, to create a custom web dashboard for the website of the Colombian National Procurement Agency – Colombia Compra Eficiente (CNPA-CCE). This should include a broad range of functionalities, including data visualizations, that will allow users to visualize, analyze and download Colombia’s public procurement data, which follows the Open Contracting Data Standard (OCDS), using the OCDS data from their API.
The Open Contracting Partnership (OCP) is a silo-busting collaboration between government, business, civil society and technologists to transform government contracting and deal-making and drive systemic change using open data and radically-improved transparency and information for users. We work across sectors and along the whole process of government contracting to use open data and improved oversight to save governments money and time, deliver better goods and services to citizens, deter corruption and create a better business environment for all.
Our most powerful tool is the Open Contracting Data Standard (OCDS). It aims to: 1) support disclosure requirements in policy and law, 2) to link all stages of a contracting process, 3) promote the effective use of contracting data by improving its interoperability and comparability and 4) enable faster reforms by encouraging the reuse of tools.
The Open Contracting Partnership (OCP) has implemented, with the generous support of Colombia Prosperity Fund Bilateral Program (PF), a program aiming to enhance the disclosure, quality and use of procurement data by stakeholders of eight Colombian regions (departamentos). The program has a total duration of two years and is equipping diverse government and non-government stakeholders with technical skills to use the open contracting information for analysis, monitoring and advocacy.
The program is helping stakeholders build constructive dialogue spaces to address identified opportunities and challenges by using open contracting data. As part of the PF Bilateral Program, we seek to build a dashboard to facilitate the use of OCDS data through visualizations for different audiences, which will also serve as a tool to support CCE’s internal analysis of competition, red flags, market studies and monitoring of the public procurement system.
The dashboard will use the Colombian OCDS dataset that contains almost 8 million contracting processes from public agencies in Colombia, from 2011 to the present date. The data follows a JSON Schema and are updated daily through an API. The complete dataset has a size of around 21 GB.
Functionalities and Requirements for the Dashboard
The tools developed under this project should integrate with the support we offer to stakeholders that use public procurement data in Colombia, which will be mostly regional governments, civil society organizations that want to monitor public procurement, local media, academia, and private sector organizations. Some of their needed visualizations are listed below; additional visualizations will be included as deemed worthwhile by stakeholders:
Value of competitive and non-competitive public procurement processes by year and region.
Data quality by region.
Competition indicators: number of interested bidders, the number of bids received, concentration of suppliers, most used red flag indicators, by period and region.
The development team will develop the dashboard with a broad range of functionalities, such as:
The Dashboard should enable users to visualize and filter by the most important data fields. We presently estimate there to be 15-20 such fields, so that the loading times of the visualizations are optimized.
The option to download the selected data in CSV or Excel or JSON in OCDS format.
Responsive design, allowing data to be formatted on smartphone, tablet or computer.
OCP will refine the list of requirements with stakeholders through workshops, and communicate them clearly to the development team, in order to agree the list of requirements to implement.
OCP strongly favours re-using existing tools, database systems, queuing systems, visualization platforms, etc. Open-source dependencies are strongly preferred, but proprietary dependencies can be considered depending on the cost/benefit. To the extent possible, all project outputs will either be openly licensed or have copyright assigned to OCP.
Activities and responsibilities
The specification of activities will be agreed between the contractors and OCP. The contractors will meet at least monthly with OCP’s Head for Latin America, Colombia’s Program Manager and, when necessary, with the Head of Data Products and Services, to discuss progress updates and to agree the goals and workload of the coming month.
We anticipate the following activities will be needed:
Initial scoping work, based on the products that support this project (above) and on user research.
Description of the software architecture, to be submitted along with the contractor’s work plan.
Two visits to work with the team in Colombia; one at the beginning of the project to meet the Information and Technology Unit from CCE and attend one of the user workshops mentioned above, and a second one at the end of the project. This should be included in the budget.
Present mock-ups of the dashboard for review to OCP.
Implement, test and deploy the architecture in (3) and dashboard in (5), including:
A minimum-viable product, where the backend is calculating some metrics, which are then displayed in the frontend.
Iterative improvements and testing.
User testing and iteration.
Create guides, documentation (including handover documentation) and training for CCE’s Information and Technology Team, in Spanish.
Be in contact with CCE, since they own the information and will give the necessary access permissions. If the contractor is not in the country, at least one trip to work with CCE is required to ensure successful handover of the project.
To qualify for this project, contractors must:
Have past projects involving dashboard design and development, preferably with contracting data. Past projects might include red flag platforms, procurement indicator dashboards, business intelligence tools, search tools, etc. Expertise in relevant projects delivering products is required.
Speak Spanish and English, since the team that will maintain the dashboard is based in Colombia.
Front-end: Angular or React
Infrastructure: Oracle, Linux
Application server: Apache Tomcat
The contractor does not need to collect data. The input data for the dashboard is available as JSON via CCE’s API. OCP will organize an orientation to its existing tools and processes as part of the project, which will be carried out remotely.
Proposed activities can include workshops with OCP’s partners, organized with its assistance, in order to, for example: collect and prioritize user needs; refine and validate the specification of the checks or the design of the dashboard; or conduct user testing.
It should be possible for CCE or another contractor to improve and maintain the dashboard. As such, proposals should include the documentation in their budget, and implementation should use popular libraries where appropriate.
Timeline & Remuneration
We expect the project to last 7 months. Within this period, the contractor must transfer the technology necessary and train CCE and OCP to maintain the Dashboard.
We will prioritize submissions under $50,000 USD, including all corresponding taxes. Work must be completed by October 31, 2020.
Applications should include: 1. Proposal outlining your intended plan (including proposed software architecture) 2. A description of your most relevant project and qualifications (1 or 2 pages) 3. Representative list of projects to verify experience 4. Itemized budget with daily rates (1 page) 5. The names and CVs of the primary staff to be assigned to the project 6. Two references with whom we can follow up