Data Analyst

The Data Analyst will support regional data, reporting and decision-making initiatives by gathering business requirements, extracting and manipulating data, developing data models, building dashboards, and ensuring data quality for the WFP Regional Office MENAEERO based in Cairo.

Responsibilities

• Gather, document and translate business requirements into clear analytical questions, KPIs and reporting specifications.
• Extract, clean and manipulate data from multiple sources (e.g., relational databases, files and APIs) to create analysis-ready datasets.
• Develop and maintain data models (logical and semantic layers) that enable consistent, trusted reporting and self-service analytics.
• Build, publish and optimize Tableau dashboards and reports, ensuring usability, performance and alignment with agreed KPIs.
• Write and optimize database queries (SQL) to support recurring reporting, ad-hoc analysis and automation of data pulls.
• Implement basic data quality checks and reconciliation routines; document data definitions, lineage and assumptions to improve transparency and reusability.
• Other tasks as required.

Requirements

• Two years of relevant experience plus a university degree in Computer Science, Information Systems, Statistics, Economics or a related field.
• Working knowledge of cloud platforms (e.g., AWS) is considered an advantage.
• Advanced Tableau skills (dashboard design, calculated fields, parameters, LOD expressions and performance optimization).
• Strong data manipulation skills using spreadsheets and/or scripting (e.g., Excel Power Query; Python/R as an advantage) to automate repeatable analysis.
• Strong database querying skills (SQL), including joins, aggregations, window functions and query optimization basics.
• Strong attention to data quality, validation and reconciliation; ability to identify anomalies and ensure metric consistency across reports.
• Solid understanding of data modelling concepts (star schema, dimensional modelling, metrics layers) and data manipulation techniques to prepare reliable datasets.
• Ability to communicate insights clearly through data storytelling, concise written reporting and stakeholder-ready presentations.
• Excellent interpersonal skills; ability to work inclusively and collaboratively with diverse stakeholders and translate needs into actionable analytics.
• Ability to create and maintain clear documentation (data dictionaries, KPI definitions, dashboard guides) and contribute to data governance practices.
• Ability to work and adapt professionally and effectively in a challenging environment; ability to work effectively in a multicultural team of international and national personnel.
• Self-motivated, ability to work on MVPs in an agile environment; ability to work with tight deadlines.
• Sound security awareness.
• Have affinity with or interest in leveraging data analytics in humanitarian domain as an enabler for durable development, and the UN System.
• Proficiency (read/ write/ speak) in English.

Skills

• Tableau Dashboard Design
• Tableau Calculated Fields
• Tableau Parameters
• Tableau LOD Expressions
• Tableau Performance Optimization
• Microsoft Power Query
• Python Scripting
• R Scripting
• SQL Query Development
• SQL Joins
• SQL Aggregations
• SQL Window Functions
• SQL Query Optimization
• Data Quality Validation
• Data reconciliation
• Data Modelling
• Star Schema Modelling
• Dimensional Modeling
• Data Storytelling
• Written Reporting
• Stakeholder Presentations
• Data Documentation
• Data Dictionaries
• KPI Design
• Dashboard Guides
• Data Governance
• Agile Methodologies
• Security Awareness
• Cloud Platforms AWS

Languages

English