Background

The UNDP Human Development Report Office (HDRO) produces an annual report and data on human development around the world. The HDRO website (hdr.undp.org) is one of the primary means of communicating this report and data and engaging with a large audience on human development issues.

This consultancy consists in fine-tuning the integration of the human development database into HDRO’s public website, creating an attractive interface in Drupal and providing simple visualization and download functionality. The consultant will be provided detailed requirements and support from HDRO and will be expected to report back on a weekly basis. The ideal candidate may have broad website programming skills but will be expected to be particularly strong in SQL Server and MySQL, PHP, Drupal 7 and JavaScript-based visualizations and libraries.

Duties and Responsibilities

  • Using Human Development data hosted on SQL Server, create the online version of the indicator and statistical datasets and data landing page in three languages (English, Spanish, French), publishing using Drupal Panels or similar Drupal integration. The tables will be structured in a similar way to the 2014 dataset (http://hdr.undp.org/en/data), but will include sparklines for each country. Each trends table will include the following features: download the data, sparklines, trends years;
  • Using these data, create country profiles and landing page in three languages, using Drupal Panels or similar Drupal integration. The Country Profiles will be structured in a similar way to 2014 (http://hdr.undp.org/en/countries), and will include the following features: country map, flag, country explanatory note, embed code, download data button, HDI value and rank, HDI Trends diagram with country pairings and components, latest available year;
  • Using these data, develop a new Build Your Own Tables interface allowing users to dynamically select data by indicator, year and country, see a visualization of the data, and download both the data in CSV and the visualization as an image;  
  • Create small widget or feature to highlight the above work on the website’s home page;
  • Working with the Online Communications Manager to develop a secure, reliable publishing flow for a new set of data published in November 2015, provide technical support on launch day and monitoring of above applications in following 48 hours.

Competencies

  • Ability to work under pressure and meet deadlines, while maintaining flexibility and a positive attitude;
  • Good organizational skills, sound judgment, initiative and effectiveness;
  • Tact and ability to deal with confidential matters in a discreet and reliable manner;
  • Displays cultural, gender, religion, race, nationality and age sensitivity and adaptability;
  • Highest standards of integrity, discretion and loyalty.

Required Skills and Experience

Education:

  •  Advanced university degree, or equivalent relevant certification and experience in computer science or software engineering.

Experience: 

  • Minimum 3 years of relevant work experience;
  • Expertise in the development of dynamic websites, particularly using Drupal 7, as well as MySQL, SQL Server, and PHP;
  • Knowledge of website architecture as well as database design and management;
  • Strong design skills using CSS and JavaScript, up-to-date knowledge of latest JS libraries and interest in innovation and interactive design.

Language:

  • Fluency in English is required;
  • Fluency in French and/or Spanish would be an asset.

Additional requirements:

  • Submission of cover letter describing aptitude for tasks;
  • Portfolio including visualization work and Drupal site building and module development.