Overview
This consultancy aims to provide surge capacity to the Supply Chain Orchestration and Analytics (SCOA) function by supporting the day-to-day operation and continuous improvement of the SCOA Control Tower, including data preparation, KPI monitoring, and analytical reporting.
Key Responsibilities
- Support collection, consolidation, validation, and preparation of supply chain data.
- Perform routine data validation and quality checks.
- Support/monitor ETL processes feeding the Control Tower analytical layer.
- Support preparation of analytical datasets and monitoring of early-warning/alert indicators.
- Contribute to identification of trends, variances, and exceptions.
- Support routine and ad-hoc reports, briefing notes, and presentation materials.
- Develop charts, tables, and visual summaries.
- Support testing/validation of reporting outputs.
- Support GFPVAN-related data processes.
- Assist in maintaining GFPVAN analytical datasets/extracts and related reporting outputs.
- Coordinate routine data submissions from Regional and Country Offices.
- Support communication between SCOA, ITSO, Regional Offices and Country teams on data-related matters.
- Support onboarding/user support, documentation updates, and continuous improvement of data quality, reporting efficiency, dashboard usability, and analytics processes.
Required Experience
- A minimum of 6 years of progressively responsible experience in data analysis, business intelligence, analytical reporting, systems/data support functions, or related areas is required. The minimum years of relevant experience is reduced to 3 years for candidates who possess a relevant first-level or advanced university degree.
- Demonstrated experience supporting data preparation, validation, and quality assurance across multiple sources (ERP, country reporting tools, logistics platforms, partner datasets).
- Hands-on experience with structured datasets and databases, including use of SQL for extraction, transformation, validation, reconciliation.
- Experience supporting/monitoring ETL processes and coordinating with IT/data teams on refreshes and issue resolution.
- Practical experience with BI/data visualization tools, preferably Microsoft Power BI (dashboard maintenance, KPI monitoring, data models/relationships).
- Strong Excel skills (formulas, PivotTables, conditional formatting).
- Experience with supply chain, procurement, logistics, inventory, or shipment data in an international or public-sector context is an asset.
Qualifications
- Completed secondary level education (high school or equivalent) is required.
- A first-level or advanced degree in Information Technology, Data Analytics, Supply Chain Management, Statistics, Computer Science, or related field is desirable.
