Result of Service

The Data Engineer will be responsible for developing, enhancing, and maintaining data engineering solutions, automated data collection processes, and data pipelines supporting ESCWA’s data platforms and digital initiatives, in accordance with established UN standards and best practices for software development, data management, IT technologies, programming languages, and tools. The individual contractor will also prepare, maintain, and update relevant project-based technical documentation, user documentation, and functional specifications to support the effective implementation, operation, and sustainability of the developed solutions.

Work Location

Hybrid

Expected duration

6 months

Duties and Responsibilities

Background: This position is located in the Decision-Support and Data Science Division. The Decision-Support and Data Science Division is part of ESCWA’s broader modernization and innovation efforts, providing advanced analytics and decision-support services within ESCWA, other UN entities, and Member States. Aligned with the UN 2.0 agenda and grounded in strategic foresight, DSDSD leverages data-driven insights, emerging technologies, and scenario-based planning to anticipate trends and proactively inform policymaking and operations. Its core functions include data integration and management; data quality assurance; advanced analytics and modeling; machine learning and artificial intelligence solutions; real-time dashboards and performance reporting; and data visualization and business intelligence and the design and development of specialized digital decision-support tools. Through these capabilities, DSDSD empowers evidence-based decision-making, fosters organizational efficiency, and catalyzes strategic innovation across the region, supporting sustainable development outcomes regionally and globally. Duties and responsibilities: The individual contractor will perform the following tasks: • Develop and maintain automated data extraction mechanisms to retrieve trade statistics from sources such as UN Comtrade, national statistical offices, customs authorities, international organizations, and other relevant trade databases. • Automate data ingestion through APIs, databases, structured files (CSV, Excel, JSON, XML), web scraping, and other external data services, ensuring consistency and interoperability across sources. • Implement data transformation and harmonization processes to standardize trade datasets, including country and partner codes, commodity classifications (HS and SITC), reporting periods, trade flows, units of measurement, and currency values. • Develop and implement data validation, cleansing, reconciliation, and quality assurance mechanisms to ensure the accuracy, completeness, consistency, and reliability of trade statistics, including the identification of missing values, duplicates, discrepancies, and reporting anomalies. • Support the processing and integration of trade indicators, including imports, exports, re-exports, re-imports, trade balances, and bilateral trade flows, in accordance with established international statistical methodologies. • Develop resilient and scalable data pipelines capable of handling changes in source APIs, data formats, commodity classifications, reporting structures, and historical data revisions.

Qualifications/special skills

A Bachelor's degree in Information Systems, Information Technology, Computer Science, Statistics or related area is required. All candidates must submit a copy of the required educational degree. Incomplete applications will not be reviewed. A minimum of 6 years of professional hands-on experience with international trade statistics, including imports, exports, trade flows, commodity classifications (HS/SITC), and trade indicators is required. Experience working with international statistical databases, such as UN Comtrade, or datasets published by national statistical offices and international organizations is required. Knowledge of data validation, cleansing, transformation, harmonization, and quality assurance techniques is required. Extracting, parsing, and processing data from diverse structured and unstructured websites and web-based sources, is required. Understanding of data validation, transformation, quality assurance, monitoring, and troubleshooting of automated data pipelines is required. 6 years of professional experience with R, Python and SQL for data extraction, processing, and transformation is required. Understanding of relational databases, data modeling, and ETL/ELT architectures is required. Familiarity with REST APIs, automated data retrieval, and data integration techniques is required. Ability to identify and resolve data quality issues, inconsistencies, and integration errors is required.

Languages

English and French are the working languages of the United Nations Secretariat; and Arabic is a working language of ESCWA. For this position, fluency in English is required and knowledge of Arabic is desirable. Note: “Fluency” equals a rating of ‘fluent’ in all four areas (speak, read, write, and understand) and “Knowledge of” equals a rating of ‘confident’ in two of the four areas.

Additional Information

Recruitment for this position is on a local basis. The incumbent is required to have the legal right to live and work in the specified working location.

No Fee

THE UNITED NATIONS DOES NOT CHARGE A FEE AT ANY STAGE OF THE RECRUITMENT PROCESS (APPLICATION, INTERVIEW MEETING, PROCESSING, OR TRAINING). THE UNITED NATIONS DOES NOT CONCERN ITSELF WITH INFORMATION ON APPLICANTS’ BANK ACCOUNTS.


At Impactpool we do our best to provide you the most accurate info, but closing dates may be wrong on our site. Please check on the recruiting organization's page for the exact info. Candidates are responsible for complying with deadlines and are encouraged to submit applications well ahead.
Before applying, please make sure that you have read the requirements for the position and that you qualify. Applications from non-qualifying applicants will most likely be discarded by the recruiting manager.