Database Officer

VN Category (INT / EXT / EOI):

External

Application Deadline:

31-07-2024

Grade:

Grade 6

Job Category:

Professional

Contract Type:

Fixed-term

Annual Salary:

CHF89,334.00

This is an external vacancy notice open to external candidates and WTO staff. It is posted on the WTO internal as well as external career site. Eligible WTO staff on short-term, fixed-term or regular contracts and interns must apply through the Workday internal career site.

This is a Fixed-term contract funded through the regular budget. The duration will be two years with the possibility of extension, unless specified in the vacancy notice.

The recruitment policy of the WTO is to seek to attract and retain staff members offering the highest standards of competence, efficiency and integrity. As an Equal Opportunities Employer, the WTO gives full regard to merit and diversity.

.

The Secretariat of the WTO is seeking to fill a Database Officer position in the Trade and Environment Division (TED).

The Trade and Environment Division services the Agreement on Technical Barriers to Trade and, inter alia, all matters at the intersection of trade and environment at the WTO. This includes the Committee on Trade and Environment (CTE) and the TBT Committee in formal and informal sessions. 

This vacancy relates to the work of the Division on environment, specifically the Environmental Database (EDB) maintained by TED. The database collates the environment-related content from notifications across all WTO agreements and information from the Trade Policy Review reports of WTO members on an annual basis.    

GENERAL FUNCTIONS

Under the overall supervision of the Director and direct supervision of a senior official in the Division, the incumbent will perform the following duties:

• Contribute to the updates and maintenance of the WTO Environmental Database (EDB).  Data collection and entry of environment-related measures from WTO notifications (over 4000 on an annual basis) and the Trade Policy Review reports of WTO members.

• Draft and assist in the preparation of the annual EDB report with a thematic/topic specific focus to support the discussions of the Committee on Trade and Environment (CTE). 

• Presentation of the EDB and its topic-specific trade and environmental data to WTO bodies, including the Committee on Trade and Environment (CTE).

• Assist in the coding of legacy data to complete the transition of EDB reports (1997-2008) to the online EDB database format.

• Test, verification, fine-tuning of the EDB online dissemination and data entry platforms, working in collaboration with the IT Division/software developers.

• Respond to user feedback and queries from WTO members' and other stakeholders.  Develop online user manual(s) and video tutorial(s), social media posts or other outreach materials.

• Preparation of EDB training modules and accompanying training materials for Geneva-based, national and regional capacity building activities.

• Use EDB data to prepare briefing notes for senior management, charts and contribute to publications of the WTO and/or other partners (e.g. UNEP, OECD, World Bank etc.). 

• As needed, and within the range of knowledge and expertise expected from a database officer, help with any other duties or tasks of the Division.

REQUIRED QUALIFICATIONS

Education:

An advanced university degree, preferably in economics, international relations, law or a related field, preferably with courses on WTO, international trade and/or environment. Professional qualifications or certification gained in any of the following areas: computer programming, statistics, data science, or database management.

Knowledge and skills:

Technical knowledge and skills:

Good knowledge and understanding of the trade and environment relationship, WTO agreements and trade-related environmental measures would be a distinct advantage.

Experience working with Office 365 (with advanced Microsoft Excel, Word and PowerPoint skills).

Knowledge of STATA or Python, R, SQL, JavaScript or similar software, for use in data mining, data cleaning, statistical analysis, and data visualization would be an asset.

Experience working with databases and familiarity with analytical tools (including common data querying languages).

Knowledge of web-content management systems (such as Drupal; WordPress) and multi-directional workflows would be an advantage.

Behavioural sk