Continue with IGO Jobs

Sign in to continue.

Sign in

Advanced Search

Tailor the filters to find your right fit.

Experience Level

Trade ETL Engineer

Job details and profile match

ESCWA
Beirut, Lebanon30 Nov 2026Mid level · CON20 Nov 2026English

Report a problem

Trade ETL Engineer — ESCWA

What needs correcting?

Overview

Based in the Decision-Support and Data Science Division, the Trade ETL Engineer builds and maintains automated trade-data pipelines. The role extracts information from statistical sources and APIs, harmonizes commodity classifications and trade indicators, implements validation and reconciliation, and develops resilient ingestion processes with technical documentation to keep data platforms reliable.

Keywords:

  • International Trade
  • ETL/ELT
  • Data Pipelines
  • Data Validation
  • Data Transformation
  • REST APIs
  • Commodity classifications

Key details

Job ID
288739
Job type
Consultancy · Full-time
Contract duration
6 months
Function
Data, AI & Analytics
Sector
Trade, Investment & Private Sector, Industry, Standards & Statistics

Skills & Tools

Job Description

Trade ETL Engineer

Job Opening ID: 288739

Department/Office: Economic and Social Commission for Western Asia

Duty Station: BEIRUT

Job Level: CON

Category: Affiliate Personnel – Consultants/Individual Contractors

Recruitment Type: Individual Contractor

Posting Period Start: 2026-11-20T05:00:00.000Z

Posting Period End: 2026-11-30T04:59:59.000Z

Language: EN

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.

Refer & Earn!

A little shout-out goes a long way!