Trade ETL Engineer
Economic and Social Commission for Western Asia · Beirut
Job description
About the role
The Economic and Social Commission for Western Asia (ESCWA) is recruiting a Trade ETL Engineer as an individual contractor in its Decision-Support and Data Science Division, based in Beirut. The role develops, maintains and improves data engineering solutions, automated data collection and data pipelines supporting ESCWA's data platforms and digital initiatives, in line with UN standards and best practices. It is a hybrid position with an expected duration of 6 months.
Key responsibilities
- Develop and maintain automated data extraction mechanisms to retrieve trade statistics from UN Comtrade, national statistical offices, customs authorities, international organizations and other trade databases.
- Automate data ingestion through APIs, databases, structured files (CSV, Excel, JSON, XML), web scraping and other external data services.
- Implement data transformation and harmonization to standardize trade datasets, including country and partner codes, HS and SITC commodity classifications, reporting periods, trade flows, units of measurement and currency values.
- Build data validation, cleansing, reconciliation and quality assurance mechanisms to ensure accuracy, completeness and consistency of trade statistics.
- Support the processing and integration of trade indicators such as imports, exports, re-exports, trade balances and bilateral trade flows.
- Develop resilient, scalable data pipelines that can handle changes in source APIs, data formats, commodity classifications and historical data revisions.
- Prepare, maintain and update project technical documentation, user documentation and functional specifications.
Required profile
- Bachelor's degree in Information Systems, Information Technology, Computer Science, Statistics or a related field.
- At least 6 years of hands-on experience with international trade statistics, including imports, exports, trade flows, commodity classifications (HS/SITC) and trade indicators.
- Experience with international statistical databases such as UN Comtrade or datasets from national statistical offices and international organizations.
- Fluency in English; knowledge of Arabic is desirable.
- Legal right to live and work in Beirut.
Required skills
- 6 years of professional experience with R, Python and SQL for data extraction, processing and transformation.
- Understanding of relational databases, data modeling and ETL/ELT architectures.
- Familiarity with REST APIs, automated data retrieval and data integration.
- Ability to identify and resolve data quality issues, inconsistencies and integration errors.
Questions fréquentes
Why are you reporting this job?
Explore further
Salaries, guides and searches in Lebanon.
Salaries by job title
Apply in 30 seconds
Enter your email to apply. An account will be created automatically.
By continuing, you accept our terms of use.
Already have an account? Login
A question about this job?
Ask it here: you will get the full job summary by e-mail, right away.
Published 1 hour ago
Expires 1 month from now
6 views · 0 interested
Boost your chances
Upload your CV — we will match you with relevant openings.
Analyzing your CV...
Economic and Social Commission for Western Asia
Beirut
Related job offers
-
Consultant to Automate the Multidimensional Inequality Portal
Economic and Social Commission for Western Asia BEIRUT -
Digital Services Consultant – Ministry of Labour, Oman
Economic and Social Commission for Western Asia BEIRUT -
Consultant: Core Technical Requirements for Lebanon's Electronic Asset Declaration System
Economic and Social Commission for Western Asia BEIRUT -
Intern - Business Systems
Chedid Capital Group District de Baabda -
Ingénieur Infrastructure & Sécurité
Equadis Beyrouth