Institute for War & Peace Reporting is hiring a
Position: Database Development Consultant
Contract type: Consultant / Contractor
Location: Remote
Start date: ASAP
Input: Approximately 30 working days - over a period of 50-60 working days.
Application process: To apply please submit your personal or company CV with details of relevant skills and expertise in the field.
INTRODUCTION:
Founded in 1991 to support local activists and journalists in the collapsing Yugoslavia who stood against rising intolerance and hate speech, IWPR has grown into an independent not-for-profit organisation that works with media and civil society to promote positive change in closed societies, societies in conflict and in transitioning societies worldwide. From global headquarters in the United States and United Kingdom, we work on the ground in more than two dozen of the world’s most challenging environments.
In 2018 IWPR has introduced an internal reporting system to capture on a monthly basis the progress, achievements and challenges from the programmatic work we have conducted in over 30 projects in over 25 countries.
The reporting system has been recently (2022) re-designed to enable more efficient, rigorous and targeted data collection, analysis and access and to better respond to evaluation questions about our programmatic work. For example some of the questions are: what changes are we delivering, how are they contributing to the project and organisational goal? What are our recurrent challenges or how much have we spent to date? Who are our partners?
At the same time IWPR is developing a “Beneficiaries toolkit” to capture data about beneficiaries' reach and results across programs. The toolkit, which is currently under development, is expected to be finalised by July 2023.
SUMMARY / PURPOSE OF ROLE:
The consultancy’s primary objective will be to develop a user-friendly unified system to support collection/management/analysis/visualisation of the IWPR reporting system data and beneficiaries data analysis.
Consultants are encouraged to include in their estimate of costs a breakdown that may also cover the development of the beneficiaries mapping database (google sheets/dashboards).
The consultant will work under the supervision of the Principal MEL Manager.
KEY OUTPUTS, DELIVERABLES AND TIMELINES
Overview
The consultant(s) is expected to lead and deliver the below products. Our priorities are quality and time frame. We want the highest quality possible in the shortest time frame possible. The Consultant would coordinate and work closely with the IWPR Principal MEL Manager.
Deliverable 1: DATA COLLECTION |To set up data collection forms.
IWPR has already outlined projects’ data collection surveys (see list below) which are currently being tested together with a beneficiaries mapping toolkit. The consultant will be asked to review the tools and update on the basis of the feedback received. Priorities will be , ensuring user friendliness and automating as much as possible of the data analysis and processing.
Projects data collection tools:
Output 1.1: Google forms which are user friendly and enable easy combined data management through google sheets.
Output 1.2: Beneficiaries toolkit database reviewed on the basis of the feedback.
Deliverable 2: DATA MANAGEMENT | To set up a database.
The consultant will be required to set up a unified database on IWPR Google Sheets. This will enable data to be pulled from multiple sources including the two google forms, Finance and Compliance data and an acknowledgment from and specific data from beneficiaries mapping. The database set up should be set up to facilitate the use of dashboards (Data Visualizer) and future migration of data to proper databases.
Output 2.1: one database/dataset connected with the data capture forms (all in the same Google sheet file).
Output 2.2: one tab that generates tables and charts for the beneficiaries mapped in the database.
Deliverable 3: DATA MIGRATION and TESTING |To populate database
The consultant will have access to the existing organisational data and will ensure the migration of the data compatible to the database. Three to Four projects will pilot NPI and MR to support the initial population of data needed to develop the dashboards.
Output 3.1: two sets of data from previous forms (NPI and MR) migrated into the database.
Deliverable 4: DATA VISUALISATION |To design and develop a set of dashboards to enable staff data access and analysis.
Looking at the data available, the consultant will design and develop (in coordination with the MEL Manager) a set of dashboards to support easy access to the data and its analysis. The dashboards should be designed and made available via Google Looker Studio (previously called Data Visualizer).
In agreement with the IWPR Principal MEL Manager, the consultant should set up an interactive dashboard with several pages containing graphs/charts/maps/tables and filter functions to present the data contained in the dataset. Data should provide insights about changes over time, combine data from different sources and allow drill in (project specific) and out (global/regional level).
Output 4.1: at least 30 graphic visualisations (tables, graphs, maps) sourcing the data available in the unified database, compiled into a multi-pages master dashboard & a table of contents with hyperlinks.
Deliverable 5: Organisational capacity & Initial troubleshoot/backstopping | Enable IWPR full autonomy in managing the tools
The consultant should provide one technical session to facilitate IWPR management of tools developed, by the end of the training participants should be able to manage the dataset, dashboards, and modifications autonomously. IWPR staff will be selected based on existing capacity in managing Google Sheets and Dashboard. The consultant should offer up to 5 hours backstopping for the first 2 months for technical issues/bugs that may occur.
Output 5.1: Short tutorial in managing database and dashboards, including what to do/not to do if changes are required.
Output 5.2: At least 4 hours briefing sessions on database utilisation and dashboards setting for at least 4 IWPR staff.
Output 5.3: Up to 5 hours (tracked) or 15 requests for technical problems troubleshooting.
Output 5.4: One video tutorial of max 1 min for each product developed.
KEY DELIVERABLES AND OUTPUTS
Approximately 30 working days - over a period of 50-60 days.
DELIVERABLES AND OUTPUTS
Deliverable 1: DATA COLLECTION |To set up data collection forms. (3 days max)
Output 1.1: 4 Google forms user friendly and compatible to easy combined data management through google sheets.
Output 1.2: Beneficiaries toolkit database reviewed on the basis of the feedback.
Deliverable 2: DATA MANAGEMENT | To set up a database. (3 days max estimated)
Output 2.1: one database/dataset connected with the 4 data capture forms (all in the same Google sheet file).
Output 2.2: one tab that generates tables and charts for the beneficiaries mapped in the database.
Deliverable 3: DATA MIGRATION and TESTING |To populate database (2 days max estimated)
Output 3.1: two sets of data from previous forms (NPI and MR) migrated into the database.
Deliverable 4: DATA VISUALISATION |To design and develop a set of dashboards to enable staff data access and analysis. (2 days max estimated)
Output 4.1: at least 30 graphic visualisations (tables, graphs, maps) sourcing the data available in the unified database, compiled into a multi-pages master dashboard & a table of content with hyperlinks.
Deliverable 5: Organisational capacity & Initial troubleshoot/backstopping | Enable IWPR full autonomy in managing the tools
Output 5.1: Short tutorial in managing database and dashboards, including what to do/not to do if changes are required.
Output 5.2: At least 4 hours briefing session on database utilisation and dashboards setting for at least 4 IWPR staff.
Output 5.3: Up to 5 hours (tracked) or 15 requests for technical problems troubleshooting.
Output 5.4: One video tutorial of max 1 min for each product developed.
KEY REQUIREMENTS
KNOWLEDGE, SKILLS, AND ABILITIES: