Dashboard Specialist - Nairobi, Kenya - Education Development Center

Description

Education Development Center (EDC) is a global nonprofit that advances lasting solutions to improve education, promote health, and expand economic opportunity.

Since 1958, we have been a leader in designing, implementing, and evaluating powerful and innovative programs in more than 80 countries around the world.

Summary

The Dashboard Specialist will play a crucial role in the USAID Kenya Primary Literacy Program (KPLP) by developing comprehensive data analytics, impact reports, and interactive dashboards in accordance with counterpart and EDC standards.

This individual will collaborate with multiple teams to ensure the effective presentation and analysis of project data, contributing significantly to the monitoring and evaluation of the program's impact.

This position requires a candidate who is collaborative, detail-oriented, analytical, and skilled in communicating complex data concepts in a clear and understandable manner.

The Dashboard Specialist will report to the MEL Specialist and will be based in Nairobi.
The Dashboard Specialist's responsibilities will include, but are not limited to:

Collaborate with government counterparts and various teams to design and implement data models, shared datasets, and interactive dashboards, primarily using Power BI, ensuring optimization for usability, performance, flexibility, and standardization.

Develop and maintain advanced Power BI reports and dashboards, incorporating best practices in data visualization and user experience design.

Write complex Data Analysis Expressions (DAX) and SQL scripts for detailed project reporting and analysis, enhancing the depth and accuracy of data insights.

Assist in the creation of data analytics and impact measures for ongoing performance monitoring, including the analysis of data to provide meaningful insights and real-time reporting.

Train and provide oversight to personnel in data modeling, analytics, reporting, and analysis; conduct workshops and training sessions to enhance team capabilities in these areas.

Facilitate meetings and coordinate collaborative efforts with internal and external teams, ensuring alignment and efficiency in data-related activities.

Mentor and guide new team members in best practices for dashboard creation and data utilization, fostering a culture of continuous learning and improvement.

Prepare data and information for project quarterly and annual reports, and other data as required.

Qualifications
The candidate for the position of Dashboard Specialist shall have at a minimum the following qualifications:


Education:
Bachelor's degree in computer science, Information Technology, or a related field. Advanced degree preferred.

Skills and Experience:

6 to 7 years of progressively responsible and directly relevant experience required.
Extensive experience in database management and SQL, with proficiency in writing complex queries and understanding relational database technologies.

Proven expertise in business intelligence and data visualization, with a strong background in the development, design, configuration, and implementation of solutions based on Power BI.

Advanced skills in data modeling, analytics, report and dashboard creation, including familiarity with data visualization tools and integration with external tools (Excel, SQL, R, Tabular Editor, DAX Studio).

Proficiency in Power Query in both Excel and Power BI.

Knowledge of monitoring, evaluation, and research data collection processes and tools, including experience with data reviews, data quality assessments (DQAs) and KPI performance measuring.

Familiarity with Power BI maps, GIS technologies, and geospatial data analysis.
A Power BI Data Analyst Certificate is preferred.
Prior experience working in a multicultural or international environment is preferred.


Language:
Fluency in English is required.


Other:
Applicants must be Kenyan nationals or hold current work authorization