Consultant - Design CRII Performance Dashboard on Power BI at Catholic Relief Services (CRS)

Catholic Relief Services is the official international humanitarian agency of the Catholic community in the United States. CRS works to save, protect, and transform lives in need in more than 100 countries, without regard to race, religion or nationality. CRS’ relief and development work are accomplished through programs of emergency response, HIV, health, agriculture, education, microfinance and peacebuilding.

Applications are invited from suitable candidates for the position below:

Job Title: Consultant - Design CRII Performance Dashboard on Power BI

Location: Maiduguri, Borno
Employment Type: Contract
Assignment Duration: This is an output-based consultancy; however, 2 weeks duration is preferred

Objectives of the Consultancy

• To design the overall database architecture for service(interventions) across 4 sectors - WASH, Nutrition, Food Assistance and Agric
• To build sector specific dashboards that visualize prioritized Food Assistance, WASH, Nutrition and Agric sectors’ indicators on Power Bi, drawing from data from CommCare and RedRose
• To Train MEAL staff to refresh, rebuild and/or maintain the database and dashboards as part of the decommissioning process.

Main Tasks / Deliverables

• Hold an inception meeting with CRII MEAL and programs team to fully understand the Project's vision for the Database
• Design a general architecture of the project database (in conjunction with CRII partners) on CommCare to accommodate 4 sectors - Food Assistance, Agric, WASH, Nutrition and two cross cutting activities (FCRM and Protection mainstreaming).
• Digitize (on CommCare) the registration, service monitoring and follow up tracking forms across 4 sectors including Nutrition WASH, Food Assistance and Agric. These forms should be onboarded on the database in a case-management style, allowing for follow-up services to be tracked per beneficiary from registration to case closure/project close out.
• Design, set-up, test and deploy, in coordination with CRS MEAL Manager, ICT4D officer a comprehensive database for CRII on CommCare.
• Develop sector-specific dashboards and connect data from CommCare and RedRose on PBI dashboards for the 4 sectors (Nutrition, WASH, Food Assistance and Agric) in line with project information and reporting needs.
• Train, and support the CRII MEAL team for 1 week to operationalize, refresh, rebuild, review and/or maintain the database and dashboard as part of system hand-over processes. The training should cover the following:
  • Building interactive dashboards Power Bi
  • Using Power Query for data cleaning and merging datasets from similar and different data sources
  • Basic DAX Calculations
  • Other necessary contents needed for seamless operationalization of the database system

Requirements

• Candidates should possess a Bachelor's Degree in Computer Science, Engineering or equivalent experience in a related field (Desirable).
• Five or more years of experience in developing dashboard.
• At least three years of data modelling experience, and knowledge of Commcare, Red rose and other data warehousing modelling techniques.
• Experience with BI reporting tools (Power BI, Tableau etc.).
• Ability to communicate information clearly, concisely, and effectively both orally and in writing.
• Five or more years of experience with data analysis and data profiling using SQL and other tools.
• High-level experience in methodologies and processes for managing large-scale databases.
• Ability to analyze existing tools and databases and provide software solution and recommendations.

Mode of Reporting:

• The ICT4D Consultant will report to the Emergency Coordinator with support of the MEAL Manager CRII, and ICT4D Officer, Sector Leads and Program Manager.
• Overall coordination and technical oversight will be provided by the CRS Country Program MEAL Coordinator

Key Working Relationships:

• Emergency Coordinator, MEAL Coordinator, MEAL Manager, MEAL officers, ICT4D/CAT Officers and program leads.

Application Closing Date
21st July, 2023 by 5:00pm close of business (West Central Africa).

Method of Application
Interested and qualified bidders should submit a brief Approach paper (maximum of 3 pages) outlining how they understand the TOR and proposed methodology & their Profile / CV highlighting key areas of expertise and experience matching the required skills specified in these terms of reference to: [email protected] using "NG11983 Application Design CR II Performance Dashboard on Power Bi" as the subject of the mail.

Note: Indicative budgets should be prepared in line with the expected deliverables and should show all related costs including travel costs and anticipated overhead costs.