Project Dashboard Consultant

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

Minimum 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