Consultancy: Python/SQL Developer

Job no: 536263 Position type: Consultancy Location: United States Division/Equivalent: Programme School/Unit: Office of Emergency Operations Department/Office: Off of Emergency Prog, NY Categories: Emergency Programme, Consultancy
UNICEF works in some of the world’s toughest places, to reach the world’s most disadvantaged children. To save their lives. To defend their rights. To help them fulfill their potential. Across 190 countries and territories, we work for every child, everywhere, every day, to build a better world for everyone. And we never give up. For every child, Hope The EMOPS Risk Assessment and Analysis Section (RAPS) has a mandate to improve risk analysis and forecasting related to contextual risks, at HQ, RO and CO levels. This includes developing methods and tools to support these activities. Being able to identify slow and sudden changes in the volume of reporting of online media regarding events connected to potential natural and human-induced events will help UNICEF Country Offices (CO), Regional Offices (RO) and Headquarters (HQ) – including RAPS – identify places where anomalies may indicate growing risk. A system that can automatically point out these situations can act as an efficient searchlight to pinpoint where human analysts need to pay more attention. Trend data can also act as an analytical input. CATS will directly support existing UNICEF tools and processes such as the Horizon Scan and the Emergency Preparedness Package (EPP), as well as UNICEF’s contributions to inter-agency contextual risk analysis fora. How can you make a difference?
UNICEF’s Office of Emergency Programmes is seeking a Python/SQL Developer Consultant to support UNICEF’s contextual risk analysis and emergency preparedness efforts. The Consultant will develop the back and front end of a system to analyse trends and identify sudden spikes in online country-level media reports about specific types of events. This system will leverage existing natural language processing capabilities (e.g. the Global Database of Event, Language and Tone (GDELT)) and concentrate on querying API, managing data returned from these queries, running calculations on these data, and displaying the results in an interactive interface. In short, the Context Alert and Trend System CATS will identify real-time points and trend conditions where current country/event reporting (as well as article tone scores, and Goldstein score that rate event significance) exceeds long term averages by defined thresholds. The Consultant will work closely with the EMOPS Risk Analysis and Preparedness Section. This is a remote / home-based consultancy. The contract starts on 15 January 2021 and ends on 30 April 2021.
Work Assignment Overview
Tasks/Milestone: Deliverables/Outputs:

Due before

  • Technical Project Plan
  • Technical revision/update of CATS project document to define project elements in technical terms, including a sustainability plan

29 January 2021

  • Data mining
  • API queries covering data requirements as defined in the Technical Project Plan, feeding the SQL database, including necessary support code

12 February 2021

  • Database creation and data population
  • SQL database capable of managing data/queries as specified in the Technical Project Plan, including necessary support code

26 February 2021

  • Data Manipulation
  • Code to perform statistical calculations on data in the database as defined in the Technical Project Document

12 March 2021

  • Data visualization
  • Interactive visual web interface with displays and user controls as defined in the Technical Project Plan

26 March 2021

  • User Acceptance Testing (UAT)
  • Design and implement UAT programme, including necessary revisions to system components

30 April 2021

  • Technical Documentation
  • Produce detailed documentation sufficient to allow a new developer to easily start work with no additional information

07 May 2021

                                              To qualify as an advocate for every child you will have…
  • At least two years of Python and SQL project development experience
  • Strong Python skills (experience with libraries such as NumPy and Panda are an asset)
  • Experience in SQL database development and management
  • Experience integrating RESTful APIs with interfaces
  • Experience with data analytics (Databricks preferred)
  • Experience with data visualization tools such as PowerBI
  • Working knowledge of front-end tools such as JavaScript frameworks like React, HTML5/CSS3 is an asset
  • Working knowledge of Leaflet for interactive maps is an asset
  • Experience with scripting, shell environments, and version control systems is an asset
  • Spoken and written fluency in English
For every Child, you demonstrate… UNICEF's values of Care, Respect, Integrity, Trust, and Accountability (CRITA) and core competencies in Communication, Working with People and Drive for Results. View our competency framework at Instructions for Applicants
  • Submit a CV and cover letter outlining how the candidate meets the consultancy requirements
  • Include 3 references with accurate phone and email contact information
  • Include a financial proposal following the template above, with daily rate covering all expenses. Applications without a financial proposal will not be considered. Rates shall be all-inclusive and include all cost components required to perform the deliverables identified in the TOR.
  • Payment schedule is according to deliverable acceptance.
Remarks: Only shortlisted candidates will be contacted and advance to the next stage of the selection process. Individuals engaged under a consultancy or individual contract will not be considered “staff members” under the Staff Regulations and Rules of the United Nations and UNICEF’s policies and procedures, and will not be entitled to benefits provided therein (such as leave entitlements and medical insurance coverage). Their conditions of service will be governed by their contract and the General Conditions of Contracts for the Services of Consultants and Individual Contractors. Consultants and individual contractors are responsible for determining their tax liabilities and for the payment of any taxes and/or duties, in accordance with local or other applicable laws. UNICEF is committed to diversity and inclusion within its workforce, and encourages all candidates, irrespective of gender, nationality, religious and ethnic backgrounds, including persons living with disabilities, to apply to become a part of the organization. UNICEF has a zero-tolerance policy on conduct that is incompatible with the aims and objectives of the United Nations and UNICEF, including sexual exploitation and abuse, sexual harassment, abuse of authority and discrimination. UNICEF also adheres to strict child safeguarding principles. All selected candidates will be expected to adhere to these standards and principles and will therefore undergo rigorous reference and background checks. Background checks will include the verification of academic credential(s) and employment history. Selected candidates may be required to provide additional information to conduct a background check.
Advertised: Nov 17 2020 Eastern Standard Time Application close: Nov 27 2020 Eastern Standard Time Location: Home-based, United States Application link:   Candidates have to confirm having received the recruitment information through the recruiting channel NGO Recruitment in the application letter for this position Du lịch nhật bản, hướng dẫn du lịch Nhật và đánh giá địa điểm Nhật Bản Japan travel news, japan travel guides, japan holiday destinations and japan reviews

Recent Job

Communications Manager

Deadline: 01/06/2021

Finance Manager

Deadline: 01/06/2021


Deadline: 24/05/2021

Consultancy Services

Deadline: 23/05/2021

Project Assistant

Hai Phong
Deadline: 15/06/2021

Political Assistant

Ho Chi Minh city, Vietnam
Deadline: 18/05/2021

Development worker

Bac Ninh, Vietnam
Deadline: 16/06/2021

Network Coordinator

Bangkok, Thailand
Deadline: 21/05/2021

IT Company to Design

Ha Noi
Deadline: All year round

Sales Director

Deadline: 29/06/2021

Division Manager (Life Science)

Hồ Chí Minh
Deadline: 06/07/2021

Apparel Production Manager

Hồ Chí Minh
Deadline: 27/06/2021

Sales Manager

Hà Nội
Deadline: 20/06/2021

Customs Specialist

Bắc Ninh
Deadline: 05/06/2021

Accounting & HR Manager

Hà Nội
Deadline: 05/06/2021

Project Management Consultant

Bắc Ninh
Deadline: 05/06/2021

Điều phối viên tỉnh

các tỉnh miền đông Nam bộ và miền Trung
Deadline: 31/05/2021


Deadline: 11/05/2021