Public Data Sources Structuring and Automation for Public Health Intelligence
Support the design, automation, and improvement of data pipelines for public health information.
Overview
Support the design, automation, and improvement of data pipelines for public health information.
You have:
- Experience writing scripts to fetch, store, and update data from web sources or APIs using R.
- Experience structuring files/folders for reproducible, multi-source data work.
- Exposure to public health, surveillance, or open government data sources.
Contract
This is a UNV contract. More about UNV contracts.
The Online Volunteer will support the design, automation, and improvement of data pipelines and analytical workflows that enable more efficient access, management, and use of public health information. The volunteer will contribute to organizing diverse public data sources, developing automated processes for data retrieval and updates, and strengthening documentation practices to improve data consistency, traceability, and reproducibility. Through this support, the volunteer will help enhance WHO Egypt’s capacity to use reliable and up-to-date information for public health analysis, monitoring, and evidence-based decision-making.
Assignment description
The online volunteer will support the structuring and automated retrieval of public data sources used across public health intelligence workflows, working with the team to keep a defined set of sources organised and up to date.
Key tasks
Support design and upkeep of a clear folder/file structure for data from multiple public sources. Support development of R scripts to automatically download and update data from a defined source list. Support standardisation of file naming and versioning conventions. Support documentation of each data source.
Key deliverables
A defined, documented folder structure covering all sources on the agreed list. At least 2 working R scripts that automatically retrieve and update data from public sources. A source documentation sheet (update frequency, access method, known issues) for each source on the list. A file naming/versioning convention applied consistently across all stored data.
R Programming and Automation: experience writing scripts to fetch, store, and update data from web sources or APIs. Data organisation: experience structuring files/folders for reproducible, multi-source data work. Public health or open data familiarity: exposure to public health, surveillance, or open government data sources.
Potential interview questions
| Can you describe a project where you automated data retrieval using R? | This question assesses your practical experience with R and automation in data workflows. | Discuss a specific project, the challenges faced, the solutions you implemented, and the outcomes. |
| How do you approach structuring data sources for multi-source analysis? | The interviewer wants to understand your methodology for organizing data in a reproducible way. | Pro members can see the explanation. |
| What considerations do you keep in mind when working with public health data? | Pro members can see the explanation. | Pro members can see the explanation. |
| Describe your experience with R scripts or other programming languages related to data management. | Pro members can see the explanation. | Pro members can see the explanation. |
| Can you give an example of how you've documented data sources in the past? | Pro members can see the explanation. | Pro members can see the explanation. |
| How would you ensure that data is kept up-to-date in a dynamic data environment? | Pro members can see the explanation. | Pro members can see the explanation. |
| What challenges do you foresee in automating data workflows with public data sources? | Pro members can see the explanation. | Pro members can see the explanation. |
| In your opinion, what makes a successful data retrieval script? | Pro members can see the explanation. | Pro members can see the explanation. |