Data extraction from a technical platform is conducted, ensuring quality verification and analysis. This role encompasses analytical precision, professional Arabic writing, and understanding data requirements and reports, coordinating with the technical team to produce clear and actionable insights.
• Building a structured reporting framework for governmental and quasi-governmental entities in a creative manner.
- Identifying the reporting needs of the relevant stakeholders, documenting the indicators, filters, classifications, and required filters, and delivery timelines.
• Extracting, organizing, and linking data sources within established parameters, examining discrepancies, redundancies, and conflicts, and documenting their resolution while preserving original data.
• Analyzing surveys and performance results, satisfaction, and quality, calculating indicators based on established formulas and weights, and verifying their alignment with platform results and interpreting variances.
• Preparing periodic and ad-hoc reports, schedules, and visuals, formulating results and recommendations based on data, with clear definitions of the analysis scope and boundaries.
• Translating analytical needs into clear requirements for the technical team, covering fields, relationships, and accounting rules, ensuring that the generated outputs meet the requirements.
• Reviewing the consistency of figures in texts, schedules, and visuals, and producing reports based on 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 includes identifying the unit of record, key relationships between tables, and distinguishing between counts of responses and stakeholders, avoiding data duplication due to linkage or redundancy.
• Proficiency in Excel and Power Query for utilizing pivot tables, conducting searches, aggregating data, validating data, merging files, organizing them, and preparing steps for efficient report updates.
• Analyzing surveys and indicators involves calculating ratios, averages, and weights based on established methodologies, identifying each indicator's position, and appropriately handling missing values and selecting "not applicable," understanding the impact of sample size on result interpretation.
• Data quality control includes identifying outlier values, discrepancies, and conflicts, matching figures with sources, and documenting processing rules and exceptions without altering original data or concealing issues.
• Technical understanding and requirement analysis involves reading data structures, describing fields, formulas, and required filters accurately, preparing validation cases, and comparing expected results with actual outcomes, communicating with developers to address discrepancies.
• Arabic writing and report preparation involves drafting clear and concise executive summaries, explaining indicator definitions, distinguishing between observation and interpretation, and providing recommendations supported by evidence.
• Presentation of data and professional output includes selecting appropriate visuals without distortion, showcasing filters, units, and sources, mastering Word and PowerPoint, and formatting Arabic from right to left, producing clean PDF files.
• Accuracy, organization, and communication entails attention to detail, managing priorities and adherence to timelines, 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 verifying data; experience in ETL processes using Python or similar tools is preferred. Experience in survey data, satisfaction measurement, quality, and reports directed at official entities is also preferred.