Data analyst

Overview

Support data migration and dissemination in FAODATA Explorer

You have:

• University degree in Statistics, Data Sciences, Computer Sciences, Data Management or related disciplines.
• At least three years of relevant experience in collecting, manipulating, analysing and disseminating significant amounts of statistical data with attention to detail and accuracy.
• Working knowledge (level C) of English and limited knowledge (level B) of another language (Arabic, Chinese, French, Russian, Spanish) are required. For PSA subscribers only working knowledge of English is required.

Organizational Setting

The Statistics Division (ESS) develops and advocates for the implementation of methodologies and standards for data collection, validation, processing and analysis of food and agriculture statistics. In these statistical domains, it also plays a vital role in the compilation, processing and dissemination of internationally comparable data, and provides essential capacity building support to member countries. In addition, the Division disseminates many publications, working papers and statistical yearbooks, which cover statistics relevant to agricultural and food security (including prices, production, trade and agri-environmental statistical data). The Statistics Division is involved in the management of a number of large-scale projects, aimed at improving statistical methodologies and establishing best practices for the collection, collation, processing, dissemination and use of data relevant to food security, agriculture and rural areas. ESS is also mandated to strengthen the coordination of FAO statistical activities, to monitor the implementation of statistical standards across the statistical units and to provide quality assurance to all FAO statistical processes and statistical outputs. Within this context, the SDW project on the modernization and integration of the FAO statistical system is funded by Capital expenditures Fund (CAPEX) and aims to achieve the (i) implementation of an integrated Statistical Data Warehouse (SDW) and (ii) setup a harmonized dissemination platform for FAO statistics FAODATA Explorer.

Reporting Lines

Consultants and PSA subscribers in ESS will work under the general supervision of the Chief Statistician and in close collaboration with the ESS statistician on dissemination and communication and the team leader of the SDW. They may be called upon to collaborate with other FAO Divisions and teams.

Technical Focus

Consultants and PSA subscribers will support the data migration from FAO databases and systems to the Statistical Data Warehouse for dissemination in the external platform FAODATA Explorer. They will use technical and analytical skills to analyze data and communicate their findings.

Tasks and responsibilities

Consultants and PSA subscribers will contribute to and/or take responsibility for one or more of the following tasks: • Engage in data cleaning and preparation for analyses and explore it for insights. • Build routines to manipulate and transform the SDW inputs and automatize the transfer of data inputs from various data sources and formats. • Create multiple modalities of the data analyses, in close consultation with the FAO data producers and the front-end development team. • Translate statistical datasets into information and knowledge using data visualizations and data analysis tools. • Utilize data analytics tools to draw insights and transform complex data into actionable narratives. • Conduct quality checks of disseminated data and metadata outputs in compliance with statistical standards and prepare reports on the quality. • Develop routines for automatic data reporting and exchange from the FAODATA Explorer to other platforms.

CANDIDATES WILL BE ASSESSED AGAINST THE FOLLOWING

Minimum Requirements

• University degree in Statistics, Data Sciences, Computer Sciences, Data Management or related disciplines. • At least three years of years of relevant experience in collecting, manipulating, analysing and disseminating significant amounts of statistical data with attention to detail and accuracy. • Working knowledge (level C) of English and limited knowledge (level B) of another of the languages (Arabic, Chinese, French, Russian, Spanish) are required. For PSA subscribers only working knowledge of English is required.

FAO Core Competencies

• Results Focus • Teamwork • Communication • Building Effective Relationships • Knowledge Sharing and Continuous Improvement

Technical/Functional Skills

• Extent of knowledge and relevant experience in the use of R and/or Python for data analysis. • Extent of knowledge and relevant experience in relational databases, database design and database systems like MySQL, PostgreSQL or MS SQL is desirable. • Extent of knowledge of and relevant experience in User Experience Design, with an emphasis in the design and implementation of user-oriented experience for digital products. • Extent of knowledge and relevant experience in data visualizations using Tableau and/or Power BI. • Knowledge of the Statistical Data and Metadata eXchange (SDMX) standard and compliant tools will be an asset. • Ability to deploy data-driven analyses and deploy systematic and logical approach to problem-solving. • Ability to work independently, with minimum supervision.

Apply now

Potential interview questions

Added 2 years ago - Updated 1 year ago - Source: fao.org