Data Analysis and Visualization Consultant

Background

The African Ministers’ Council on Water (AMCOW) has the primary mission of providing political leadership, policy direction and advocacy in the provision, use, and management of water resources for sustainable social and economic development and maintenance of African ecosystems. AMCOW serves as a delivery mechanism on water and sanitation to the Specialized Technical Committee (STC) on Agriculture, Rural Development, Water and Environment (ARDWE) of the African Union Commission.  At the African Union Heads of State and Government Summit of July 2008, the African Minister’s Council on Water (AMCOW) was mandated to report annually on progress achieved in implementing the African Union (AU) commitments made in the 2008 Sharm El-Sheikh Commitments on water and sanitation, taking into account several international agreements including the Africa Water Vision 2025, the Africa Agenda 2063, as well as the global Sustainable Development Goals 6 (SDG-6) targets on clean water and sanitation.

In response to this directive, AMCOW, in collaboration with the African Union Commission and with financial support from Africa Water Facility (AWF) through the Africa Development Bank (AfDB), developed a web-based reporting system, the African Water and Sanitation Sector Monitoring and Reporting System (WASSMO) in October 2015: https://www.africawat-sanreports.org/Ui. This platform provides for reporting on water and sanitation indicators under seven themes: water infrastructure for growth; managing and protecting water resources; water supply, sanitation, hygiene, and wastewater; climate change and disaster risk reduction (DRR); governance and institutions; and financing.  

 In May 2022, AMCOW organised training workshops to strengthen Member State’s capacity to effectively report on their water, sanitation, and hygiene sector progress. This activity is a step toward enhancing Member State’s capacity and learning to adequately collect the required quality data for developing the 2022 Report on Africa’s Water and Sanitation Sector. For this purpose, AMCOW requires the technical assistance of a data analyst who will support the cleaning, analysis and visualization of the data being submitted by the Member States. The aim is to contribute to developing a high-quality WASSMO 2022 report that meets the required international reporting standards. 

The AMCOW Secretariat is seeking a Data Analyst and Visualisation Consultant (DAVC) to support analysis and visualisation and provide quality assurance checks on the data to produce the 2022 WASSMO report for high-level recommendations and decisions.

Tasks and Responsibilities

Through a consultative and participatory process, the consultant will work with the AMCOW Secretariat to perform the following activities:

1. Interpret data, analyse results using statistical techniques
2. Develop and implement databases, data collection systems, data analytics and other strategies that optimize statistical efficiency and quality.
3. Identify, analyse, and interpret trends or patterns in complex data sets
4. Filter and “clean” data by reviewing computer reports, printouts
5. Assist the team in improving and streamlining processes regarding data flow and data quality assurance checks to improve data accuracy, viability, and value.
6. Support the delivery of analytics and reporting solutions using BI/Data Visualization software or others.
7. Provide analysis presentation – Data analyst consultant will present finding of the WASSMO report to AMCOW Secretariat.

Deliverables

• WASSMO/AFRICASAN data exploration, analysis and modelling performed on the database, resulting in a clean data set to inform the 2022 WASSMO report narrative.  
• Any additional deliverables that are part of the WASSMO/AFRICASAN data analytics outputs (infographics, charts, etc.).

•         The brief report with highlight of the findings

Qualification and Experience

• Minimum master’s degree in management information systems, statistics, Business Intelligence, Computer Science, or Statistics is required.
• Relevant work experience as a data analyst or business data analyst and visualisation for both quantitative and qualitative data.
• Familiarity with water and sanitation sector landscape.
• Ability to write a concise and clear analytical research report on the results of the WASSMO and AFRICASAN Member States’ data.

• Excellent command of written and spoken English. French will be an advantage.

Skills and Abilities 

• Highly skilled in research and analysis: Very strong qualitative and analytic skills; keen attention to detail and data accuracy.
• Technical expertise regarding data models, database design development, data
• mining and segmentation techniques
• Knowledge of statistics and experience using statistical packages for analysing
• datasets (Excel, SPSS, SAS etc)
• Excellent communication skills: Strong knowledge of and experience with
• reporting packages (Business Objects etc), databases (SQL etc), and data
• visualization tools (Microsoft Power BI, Tableau, etc).
• Other: Demonstrated competence with using standard data software packages

(MS Excel, MS Access, etc).

How to Apply

Contract duration/ Level of Effort: The contract will be effective from the date of signing and will last for not more than 90 days.

Languages: English and French

Mode and logistics: Consultancy will be done remotely.

Mode of selection of Consultants: Individual Consultants will be selected based on their qualifications for the assignment. Interested candidates who meet the required qualifications and experience are invited to submit:

•  An updated CV
• Cover letter explaining their motivation and suitability for the assignment
• One copy of past work
•  Proposed Budget

AMCOW only accept applications sent via email – info@amcow-online.org Please forward the application in through the stated email no later than 31^st August 2022. For more information, kindly refer to https://www.amcow-online.org

Note: Female candidates with required qualifications are strongly encouraged to apply. Only shortlisted candidates will be contacted.