In this role, you will extract data from technical platforms, validate its quality, and analyze it to convert it into clear indicators and formal reports that support performance monitoring and decision-making. The role combines analytical precision with professional Arabic writing skills, and understanding data requirements and coordinating with the technical team.
• Build a structure for official reports for governmental and quasi-governmental entities creatively.
- Identify the needs of the beneficiary entity from the reports, document the indicators, filters, classifications, and required filters, and delivery timelines.
• Extract, organize data, and link its sources within the approved frameworks, and examine discrepancies, repetitions, conflicts, and document their treatment while preserving the original data.
• Analyze surveys and performance results, satisfaction, and quality, calculate indicators based on established formulas, and verify their alignment with platform results while interpreting discrepancies.
• Prepare periodic and ad-hoc reports, schedules, and graphs, and formulate results and recommendations based on the data, clarifying the scope of analysis and its limits.
• Transform analytical needs into clear requirements for the technical team, including fields, relationships, accounting rules, and verification that the generated outputs meet the requirements.
• Review the consistency of figures in texts, schedules, and graphs, and produce reports according to established templates, organizing analysis files and outputs to facilitate reviewing results and re-producing them.
Skills
• Experience in preparing reports for governmental and quasi-governmental entities.
• Data analysis and understanding its structure, identifying record units, and the relationship between tables, distinguishing between the number of responses and beneficiaries, and avoiding result duplication due to linking or repetition.
• Proficiency in Excel and Power Query, utilizing advanced tables, and validating data, merging files, organizing them, and preparing steps for efficient report updates.
• Analyzing surveys and indicators, calculating ratios, averages, and weights according to established methodologies, identifying the position of each indicator, and correctly handling missing values and choosing "not applicable," understanding the impact of sample size on interpreting results.
• Ensuring data quality by identifying outlier values, discrepancies, and conflicts, and comparing figures with the source, documenting treatment rules and exclusions without altering the original data or concealing issues.
• Technical understanding and analyzing requirements by reading data structures, describing fields, formulas, and required filters accurately, preparing validation cases, and comparing expected results with actual ones, and communicating with developers to address discrepancies.
• Arabic writing and preparing reports, formulating clear and concise executive summaries, explaining indicator meanings, distinguishing between observation and interpretation, and evaluating recommendations supported by evidence.
• Presenting data and professional outputs by selecting appropriate visuals without misleading, showcasing filters, units, and sources, mastering Word and PowerPoint, and formatting Arabic from right to left, and producing clean PDF files.
• Precision, organization, and communication by paying attention to details, managing priorities and adhering to deadlines, documenting workflows and outputs, and explaining results to non-specialists while maintaining data confidentiality and access controls.
- Proficiency in Power BI for building dashboards and data models, SQL for data retrieval and linking, and experience in data processing using Python or similar tools. Experience in survey data, satisfaction measurement, quality, and reports directed at official entities is preferred.