Intern - Data Engineering
Organizational Context
The UN Secretariat's CEB secretariat, based in Geneva and New York, supports the UN System Chief Executives Board for Coordination and its High-level Committees. This internship is situated within the Geneva office, reporting to the Information Systems Assistant, and focuses on data engineering tasks.
Job Purpose
This internship aims to support the CEB secretariat in Geneva by developing and refining data transformation processes. The intern will be instrumental in assessing solution options, building a robust transformation engine for ingesting and processing agency data, and ensuring data quality and consistency. Key contributions include generating traceable outputs for validation and publication, reconciling data with existing web publications, and creating essential technical documentation and Standard Operating Procedures (SOPs). This role provides a practical, hands-on experience in data engineering within an international coordination body, contributing directly to the efficiency and accuracy of inter-agency data management.
Responsibilities
The Data Engineering Intern will be responsible for assessing and documenting solution options for data transformation. A primary duty involves developing the transformation engine, which includes ingesting and parsing agency source files, performing lookups against reference lists, converting currencies to USD, merging datasets, aligning schemas, and implementing validation checks. The intern will generate outputs for the validation team and for publication, ensuring traceability of each process run, including sources, reference versions, and anomalies. A key task is reconciling the outputs of the new data flow with the data currently published on the CEB website. Additionally, the intern will write technical documentation and SOPs for validation officers and facilitate knowledge transfer to the team, while also performing other related duties as required.
Work Experience
Professional work experience is not required for this UN Internship Programme. However, a field of study closely related to data engineering, such as Computer Science, Information Technology, or Data Management, is essential. Practical experience with data scripting, Linux environments, and web architectures is highly beneficial.
Skills
Proficiency in data scripting (Python, Node.js); Knowledge of Linux environments, file systems, and flat-file manipulation (CSV, TSV, XLSX); Understanding of web architectures (Node.js backend, REST APIs, token authentication); Strong English language skills.