Full Stack Developer

Result of Service The key result of the consultancy will be a fully functional database application that enhance the capacity of the CITES Secretariat to capture, manage and analyse the information on ivory stockpile inventories submitted by the Parties to Convention on International Trade in Endangered Species of wild fauna and flora (CITES).

Work Location Remote

Expected duration 3 Months

Duties and Responsibilities The United Nations Environment Programme (UN Environment) is the leading global environmental authority that sets the global environmental agenda, promotes the coherent implementation of the environmental dimension of sustainable development within the United Nations system and serves as an authoritative advocate for the global environment. The Convention on International Trade in Endangered Species of Wild Fauna and Flora (CITES) is an international agreement between States. Its aim is to ensure that international trade in specimens of wild animals and plants does not threaten the survival of the species in the wild (www.cites.org). The CITES Secretariat is administered by UN Environment and is located in Geneva duty station.

The Conference of the Parties to CITES have adopted Resolution Conf. 10.10 (Rev. CoP19) on Trade in elephant specimens urging certain Parties to maintain an inventory of government-held stockpiles of ivory and, where possible, of significant privately held stockpiles of ivory within their territory, and inform the Secretariat of the level of this stock each year before 28 February, indicating: - the number of pieces and their weight per type of ivory (raw or worked); - for relevant pieces, and if marked, their markings in accordance with the provisions of this Resolution; - the source of the ivory; and - the reasons for any significant changes in the stockpile compared to the preceding year.

Parties have been submitting inventories of ivory stockpiles since 2014. There has been a steady increase in the reporting and the Secretariat provides a model inventory that Parties can use to record and submit the information as required. The information currently kept by the Secretariat must be captured in a standardized manner to facilitate the extraction of information to be used in future analyses.

Under the day-to-day supervision of the Chief of the Governing Bodies Unit (GBU), the Consultant will:

1. Develop a database application taking into consideration the model inventory for the submission of ivory stockpiles and submissions by Parties. In consultation with the relevant units in the Secretariat: a. Propose best options relating to the programme to be used to record and manage the information to facilitate analysis, reporting and extraction of information for analysis; b. Prepare a standard template to capture the information submitted by Parties taking into consideration the model inventory of the Secretariat and submissions by Parties; c. Develop key functionalities including analysis, reporting and extraction of information for analysis; d. Consult with relevant stakeholders; e. Develop a database application for recording ivory stockpile information, including functionalities (analysis, reporting and extraction of information for analysis).

2. Record all information received from Parties since 2014 in the database and test functionality. In collaboration with the GBU: a. Develop a function to import all the information received from Parties on ivory stockpiles from 2014 to date; b. Ensure that information received from 2014 to date is imported through the function; c. Test all functionalities

3. Develop standard procedures and guidelines for the maintenance of the data and train selected staff members. This will involve the following: a. The development of a standard operating procedure (SoP) for the use and maintenance of the information and programme. b. Training provided to at least 4 staff members to use the system.

4. Assist the Secretariat in migrating the database application to a production server for hosting

Qualifications/special skills Required education qualifications: University degree in computer science or relevant field. At least 4 years of experience as a Full stack developer specialized in database development. Required field of work and where applicable, area of specialty: Database development and data management.

Languages Fluency in written and spoken English. Knowledge of French is desirable.

Additional Information- The Consultant is expected to commence this assignment as soon as possible. The total expected duration of the assignment will be 60 days spread over a period of 3 Months. Approximately from Beginning of 24 July to 23 October 2023.

- Payments will be made upon successful completion, review and quality assurance of the deliverables specified under Outputs/Work Assignment above. All deliverables must be submitted by the contractor to the respective direct supervisors and certified as being of adequate quality and meeting the terms of the deliverables before payments will be made.

Required competencies: i. Proven work experience in relational database design and development; (Postgrey and MYSQL databases) ii. Proven work experience in front end programming, design and development (Angular, Bootstrap, HTML, CSS and Express, Nodejs, Mongo DB, PHP and MySQL) iii. Experience in understanding data modelling and management, analysis and reporting including data visualization; iv. Experience in training people in the use of databases; v. Knowledge of software development and database programmes; vi. Analytical and organizational skills; vii. Ability to understand front-end user requirements and solving problems; viii. Excellent verbal and written communication skills.

Desired competencies: i. Certification in MEAN stack development ii. Certification in Azure or other cloud platforms iii. Experience with Drupal development and reporting/visualizations

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.