Job Summary
Scope of Advert: Local Advertised
Category (Eligible Applicants) External
Practice Area: Data Management & Analysis
Application Deadline: 22/04/ 2022
Type of Contract: Individual Contract/Professional Services
Post Type/ Level: Local
Languages Required: English
Starting Date: 03/05/2022
Expected Duration of Assignment: 3 Days
Background of the Organisation
FACT is a Christian-based national organisation working in and through partnerships to improve health and reduce poverty among people affected by HIV and related issues in Zimbabwe and beyond. FACT is receiving support from its partner in health programming to improve organizational data management systems.
Background to
CSOs/ CBOs and the communities are not fully integrated into ongoing data collection, data analysis, data generation and data sharing for evidence based and responsive interventions. Programmatic data generation and sharing is a critical factor in resource utilization and allocation. Where such is missing, it impacts negatively on effective local and GF resources allocation and utilization. CSOs health generated data is poorly managed to contribute to and reflect on demand and supply of Global Fund and other donors funded services. This affects utilization and CSOs capacity to respond community and national needs. Overall, poor and misaligned use of available data leads to poor health outcomes.
It is against this background that FACT is seeking a consultant to train staff on the use of data management and presentation technology specially focusing on Power BI and CommCare software, as options for data management and analysis platforms for some of its projects.
Duties And Responsibilities
Consultant/facilitator responsibilities
§ The Facilitator will be expected to train project Staff members on how to configure, upload the CommCare and Power BI software.
§ Train basic excel based data analysis and visualisations and its links with CommC are and Power BI platforms.
§ Train staff on how to import data from Ms. Excel to CommCare or Power BI
§ Train staff on how to clean, analyze, create dashboards and develop forms using Power BI and CommCare
§ Model data with Power BI desktop
§ Create data visualizations and dashboards reports in CommCare and Power BI
§ Create and share dashboards based on reports in Power BI desktop
§ Use demo data to create dashboards in Power BI and CommCare
Main Deliverable
§ A training program, manual, report and related training materials
§ Free- trial software links
Qualifications And Experience
Qualifications, Skills and Experience
§ Bachelor’s degree in any of the following fields: Biostatistics, Health Informatics, Data Science, Big Data Analytics, M&E, or related field. Master’s degree in a health-related field will be an added advantage.
§ At least 2 years Proven experience and knowledge in using CommCare and Power BI.
§ Strong quantitative data analysis skills, including conducting data cleaning, verification, and trend-analyses.
§ 2 years proven Experience in creating dashboards using Power BI or other business intelligence software is strongly preferred
Scope of Price Proposal and Schedule of Payments
The consultancy fee will be determined on a lump sum basis. The lump sum amount must be all-inclusive and the contract price must be fixed regardless of changes in the cost components. Payment will be made upon completion of all key deliverables. The expected duration of the training is at least 3 full days. This excludes training preparations and report writing.
Job Summary
More Information
- Job Application Details How to apply Consultants can submit their Expression of Interest (EoI) clearly marked in the subject EOI for Training of Staff on Power BI and CommCare softwares. All EoI must be submitted by to At least [email protected]. The subject matter should be clearly stated on the submission and email response stating the subject one is responding to. The EoI must include the following: Technical proposal: a cover letter and updated Curriculum Vitae (2 pages maximum); a technical proposal (max. 4 pages) summarizing the approach and the proposed manual/guide to be used. Work plan with the expected number of working days; and, List of evidence of similar work done and experience to undertake the assignment. Financial proposal: - asking rate (fees) in USD per workday (The maximum number of days is 3 days). Other logistical expenditures like transport, meals and accommodation during the training, will be catered by the Organisation using the standard rates as per the policy of the organization. Evaluation Criteria Candidates will be evaluated using a combined scoring method with the qualifications and methodology weighted at 85% and the price offer weighted at 15%. Only candidates obtaining a minimum of 55%+ (out of 85%) points on the technical qualifications part will be considered for the Financial Evaluation. Criteria for evaluation of qualifications, experience and methodology (80% points maximum): • Relevance of education to the consultancy (20 points) • Demonstrated Experience using Power BI (20 points) • Proven experience configuring and using CommCare (20 points) • Demonstrated experience facilitating a training on Power Bi or CommCare (25 points) Criteria for financial evaluation (15 points maximum)