Programmer/Database Coordinator (Half-time), Paris, France
Organization: Organisation for Economic Co-operation and Development (OECD)
City: Paris, France
Office: OECD Paris, France
Closing date: Sunday, 30 August 2020
Programmer/Database Coordinator (Half-time) ( Job Number: 13762 )
Application Closing Date: 30-08-2020, 9:59:00 PM
The OECD is a global economic forum working with 37 member countries and more than 100 emerging and developing economies to make better policies for better lives. Our mission is to promote policies that will improve the economic and social well-being of people around the world. The Organisation provides a unique forum in which governments work together to share experiences on what drives economic, social and environmental change, seeking solutions to common problems.
The Environment Directorate (ENV) supports governments in identifying and implementing the environmental policies needed to support a cleaner, more resource-efficient and low-carbon green growth path. The ENV team is made up of environmental specialists, economists and scientists who undertake cross-country analysis, review country performance, develop projections, facilitate work-sharing, collect data and indicators, and develop policy recommendations. The ENV meetings and conferences provide a forum for discussions amongst governments and with business and civil society partners on critical environmental challenges.
We are looking for a dynamic Programmer/Database Coordinator to work half-time with the Environment, Health and Safety(EHS) eChemPortal team in the maintenance and the improvement of the OECD Global Portal to Information on Chemical Substances (eChemPortal).
The eChemPortal application and web site (http://www.echemportal.org) is an internet gateway to information on the properties, hazards and risks of chemicals found in the environment, workplaces, and in products used daily. It is an integrated system that allows users to simultaneously search data from multiple databases prepared for government chemical review programmes around the world.
eChemPortal provides search functionality for substance names and identification numbers, for substance properties, and for chemical hazard classifications. This enables users to not only search for substances the identity of which they already know (at least partially), but also for substances that meet certain criteria in their properties (toxicity, ecotoxicity etc.). In addition, the eChemPortal application enables filtering the substance identity search results by type, i.e. property, exposure and use information, GHS classifications, and the user is able to filter the substance identity search to participating databases containing a specific type of information.
Maintain and update eChemPortal, a database with information on properties of chemicals.
Receive and clean data from data submitters, identifying and correcting potential errors and/or omissions, and test in a test environment before import in the production system.
Troubleshoot direct data submission by data submitters.
Propose and implement improvements to the data submission and update process, including update of guidance documents and/or development of data integration solutions in the context of the eChemPortal data feeding mechanism and established data format using numerous sources and targets (e.g. SQL, Excel, XML, APIs ).
Establish and maintain contacts with member countries and other key non-member economies, the European Commission as well as with other stakeholders, to facilitate data submission.
Engage in bilateral discussions with data submitters to maintain and update data.
Facilitate recruitment of new data sources within the scope of the database project.
Assist in the development activities of eChemPortal, in coordination with the eChemPortal Project Coordination Group and development contractor.
Assist in testing eChemPortal draft releases delivered by the development contractor.
Assist in maintenance of eChemPortal application business documentation, e.g. data feeding guidance, Use Cases, Test plans and test data.
Tags computer science data quality database management economist environmental chemistry green growth identification numbers python
Propose any improvements to eChemPortal (including look and feel, performance, reliability, application management in the long term).
Assist in the promotion of the eChemPortal application.
Produce statistical and analytical publications and reports.
Develop video tutorials and promotional pieces.
Manage the eChemPortal generic email account.
Promote eChemPortal at relevant meetings and conferences. [Tasks/Duties]
Ideal Candidate Profile
Degree in computer science or environmental chemistry
Minimum of 3 years of experience in database management or development.
Good knowledge of SQL, ACCESS, Excel, XML, Word. Proficiency in at least one scripting language. Skills in programming with Python, R, Scala or NodeJS would be an asset. Good knowledge of data quality development and ETL (Extract-Transform-Load)
Fluency in one of the two OECD official languages (English and French) and knowledge of the other, with a commitment to reach a good working level.
For this role, the following competencies would be particularly important: Achievement focus, Drafting skills, Flexible thinking, Diplomatic sensitivity, Strategic networking.
Please refer to the level 2 indicators of the OECD Core Competencies.
Two-year fixed term appointment, with the possibility of renewal.
What the OECD offers
Monthly base salary starting from 4 719.16 EUR (full time basis), plus allowances based on eligibility, exempt of French income tax.
For retained candidates, written tests/video-recorded interviews are foreseen 10-20 September 2020 and panel interviews are planned for early October 2020.
Please note that the appointment may be made at a lower grade based on the qualifications and professional experience of the selected applicant.
The OECD is an equal opportunity employer and welcomes the applications of all qualified candidates who are nationals of OECD member countries, irrespective of their racial or ethnic origin, opinions or beliefs, gender, sexual orientation, health or disabilities.
The OECD promotes an optimal use of resources in order to improve its efficiency and effectiveness. Staff members are encouraged to actively contribute to this goal.