Data Analyst
Save this job and keep your search organized
Create a free account to save jobs, create alerts and return to this listing from your dashboard.
By continuing, you agree to our Terms & Privacy Policy.
Job Description
We are seeking an experienced Data Analyst to support programme information management, data collection, analysis, visualization, and reporting. The successful candidate will be responsible for managing data collection systems, developing automated reports and dashboards, ensuring data quality, and providing analytical support for programme monitoring and donor reporting requirements.
Key Responsibilities
1. Data Collection and Management
Design, develop, and maintain KoBoToolbox/ODK data collection forms, including skip logic, validation rules, and repeat groups.
Manage data submissions, consolidation, cleaning, and validation to ensure data accuracy and completion.
Monitor data collection activities and coordinate with field teams to address missing, inconsistent, or incorrect information.
Maintain data collection protocols, form versions, user permissions, and documentation.
Support the integration of KoBoToolbox data exports with Excel and Power BI for reporting and analysis.
2. Data Analysis and Visualization
Develop and maintain advanced Excel workbooks, including Pivot Tables, Pivot Charts, XLOOKUP, VLOOKUP, INDEX-MATCH, Power Query, and automated dashboards.
Create, publish, and maintain interactive Power BI dashboards to monitor programme performance, project progress, procurement milestones, and key performance indicators.
Develop Power BI data models, DAX measures, and calculated columns to generate accurate analytical reports.
Consolidate and reconcile data from multiple sources to ensure consistency and accuracy of reports.
Prepare weekly, monthly, and quarterly reports, including data summaries, charts, and visual presentations.
Support GIS-based data analysis and mapping using Power BI map visuals, QGIS, or other related tools.
3. Programme Reporting and Monitoring
Consolidate, validate, and organize programme data for management and donor reporting requirements.
Maintain and regularly update master data registers and programme monitoring databases.
Support Monitoring and Evaluation (M&E) activities, including indicator tracking and results framework reporting.
Prepare data tables, analytical summaries, charts, and maps for programme reviews and donor progress reports.
Maintain proper documentation of data dictionaries, reporting templates, and system procedures.
4. Technical Support and Data Quality Assurance
Provide technical assistance and troubleshooting to field personnel and programme teams on KoBoToolbox, Excel, and Power BI.
Conduct data quality assessments to identify inconsistencies, errors, and missing information.
Develop user guides, standard operating procedures, and data management documentation.
Conduct training sessions for users on data collection procedures, reporting tools, and data quality standards.
Coordinate with relevant teams to resolve data-related issues and improve information management processes.
Qualifications and Requirements
Bachelor's Degree in Information Management, Statistics, Data Science, Computer Science, or any related field with at least 4 years of relevant professional experience; OR
High School Graduate with at least 6 years of relevant professional experience.
Hands-on experience in KoBoToolbox, ODK, or Kobo Collect, particularly in form development, data validation, and data management.
Advanced proficiency in Microsoft Excel, including Pivot Tables, VLOOKUP, XLOOKUP, INDEX-MATCH, Power Query, and dashboard creation.
Proven experience in developing and publishing Power BI dashboards and reports.
Knowledge of Power BI data modeling, DAX measures, calculated columns, and Power BI Service.
Strong background in data analysis, data cleaning, data validation, and data quality assurance.
Experience in Monitoring and Evaluation (M&E), programme reporting, or information management is an advantage.
Familiarity with infrastructure, WASH, humanitarian, or development programmes is highly preferred.
Knowledge of QGIS or other GIS tools is an advantage.
Proficiency in Microsoft SharePoint and OneDrive for document and data management.
Excellent analytical, organizational, and communication skills.
Proficiency in written and spoken English is required.
Knowledge of Arabic is an advantage.
Preferred Skills:
KoBoToolbox / ODK