View Jobs at Catholic Relief Services (CRS) |
Contract |
Posted 1 year ago |
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.
HOW TO APPLY
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.
Deadline: July 21, 2023
Job Features
Job Category | Consultant |