Job Description
TeachWell (TW) is a Project funded by LEGO and Grundfos foundations has just commenced its second year of implementation. Geographically, the project covers Turkana and Garissa Counties constituting host communities and refugee camps of Kakuma and Dadaab. TW commenced in September 2023 with a five-year duration that extends to August 2028. The goal of the project is to improve holistic learning and well -being of children in the two refugee hosting counties of Kenya. The two counties have documented disparities in education outcomes and lag comparatively behind other parts of the country largely due to challenges of contextual descent.
The project targets all teachers and learners in both the Host Community and Refugee schools in Turkana and Garissa Counties. Overall, the project targets all (100%) Primary and Junior school teachers in the refugee camps and host communities with Teacher continuous Capacity development (TCCD) package, 89 schools with Water Sanitation and Hygiene (WASH) interventions and eligible schools and learners with crisis modifier support in times of emergencies. Apart from MHPSS case management that is the centered in the camps, the entire package will be delivered to all teachers.
TeachWell Project PowerBi Dashboard
TW has a MEAL plan to track performance indicators through projects toward results and other elements of visibility will be assessed from time to time. For consortium level use and commitment to the donors TW intends to develop a dashboard that meets the expectations of various users as a monitoring platform to track progress and inform management action.
To achieve the above requirements, TW intends to have a PowerBi dashboard that seamlessly integrates data integration, transformation and a user-friendly system for tracking progress. The TeachWell Dashboard (TWD) design and operationalization intends to offer a structured solution from data capture, analysis and visualization of progress in key performance indicators.
There will be one Project PowerBi dashboard with differentiated grant level components and drill down functionalities for ease of use. Apart from this, the tool will be designed with inbuilt flexibility for expansion and upgrading in line with project needs and reporting requirements. The process will culminate into stepwise automation of data capture, analysis through use CommCare and Power BI leading to minimal manual input in performance monitoring. By transforming raw data into strategic information, the dashboard will empower TW consortium and donors to visualize results in a simple way that stimulates tracking and learning for management action.
Scope of work
The purpose of the assignment is to develop a functional TW PowerBi dashboard that meets both technical and user requirements. The consultant will work with the MEAL team to design, develop, test and commission dashboards that fully automate MEAL capture analysis and visualization along with pertinent project information.
The dashboard consolidates key performance indicators (KPIs) from multiple data sources to enable program teams, donors and stakeholders to make evidence-based decision-making, streamline reporting and improve program accountability. By integrating data, TW ensures a consistent and transparent approach to tracking progress, identifying challenges and optimizing program impact.
The specific objectives of the task include the following.
Enhance Data-Driven Decision-Making
Standardized Performance Monitoring
Improve Grant Management and Oversight
Facilitate Effective Reporting
Increase Accountability and Transparency
Support Continuous Learning and Adaptation
The assignment will be confined to the TeachWell Project, where relevant differentiated by two grants. The Grundfos Grant covers outcome 3 which delivers WASH interventions in schools. The other outcomes are funded by LEGO Foundation, thus the respective indicators separately before consolidation. The dashboard will encompass key performance indicators and others tracked in the life of the project. The role will encompass the design and integration of the system with source data, visualization and access management. The summary activities encompass the following.
Deliverables
The development will culminate in several tangible products. to meet the purpose and objectives outlined in the foregoing section. The key deliverables include the following.
Inception Report and Work Plan
Power BI Dashboard Prototype with TeachWell Standard branding complete and approved
Data Source Integration and Management Framework
User Access and Security Configuration
Performance Monitoring and Indicator Tracking System Completed and Tested
Differentiated Grant (LEGO and Grundfos) and Site-Level Reporting (Turkana and Garissa)
Incremental Testing and Quality Assurance
Workspace Setup, User Acceptance Testing (UAT) and Deployment
Capacity Building Report (Users Trained and Supported to Proficiency Level)
Final System Testing and Validation
Technical Documentation and Reporting
Maintenance, Knowledge Transfer and Handover
Qualifications
Education and Professional Background
A University Degree in Computer Science, Data Science, Information Systems, Statistics or a related technical field.
Working Experience in data visualization tools such as Power BI and data management with evidence of complete projects initiated and completed.
Professional Training in either Power apps and Power BI and Management Information Systems is highly desirable.
Technical Experience
At least 5 years of professional experience in dashboard development, data integration, and visualization.
Proven experience in:
Microsoft Power BI development (required).
CommCare integration or similar mobile data collection tools.
Implementing data validation frameworks, role-based access control and automated reporting systems.
Strong understanding of MEAL systems and familiarity with performance monitoring in development or humanitarian projects.
Project Management & Delivery
Demonstrated ability to work independently and deliver results within fixed timelines and budget.
Experience working with multi-stakeholder teams, including MEAL teams, program managers and donor representatives.
Prior experience in designing user-friendly interfaces with intuitive navigation and interactive visual elements.
Demonstrated track record of delivering requirements gathering, capacity-building sessions, technical documentation and structured handovers.
Contextual Understanding
Experience working within the education or development sector or in humanitarian/refugee contexts is an asset.
Skills and Competencies
Strong analytical and problem-solving skills.
Excellent written and verbal communication skills in English.
Technology skills transfer through proficiency-based training to users.
Ability to translate complex data into accessible, visual information for diverse user groups.
Highly organized, detail-oriented, and committed to quality and accuracy.
Mandatory Documents to Attach
Brief Capability Statement demonstrating Technical Capacity of the applicant in a similar role
Technical Proposal detailing the methodological approach to the delivery of the advertised task with a separate page indicating financial quotation for the assignment
Portfolio/ Visual proof of at least 2 similar pieces of work conducted in other previous engagement(s) with other organizations
