Database and Website Developer

Background

Food fortification is one of the great success stories in global health. Using commonly eaten foods such as flour, salt, and rice to deliver much-needed vitamins and minerals has saved and improved the lives of billions of people worldwide. Despite this incredible impact to date, fortification can do even more to reach new populations with micronutrients. Making timely and trustworthy data available to policymakers, program implementers, and advocates is a key bottleneck in increasing the impact of fortification and exactly what the Global Fortification Data Exchange aims to do.

The Global Fortification Data Exchange (GFDx, FortificationData.org) is the definitive source of information on large-scale food fortification programs, focusing on commonly fortified staple foods and condiments (maize flour, oil, rice, salt, and wheat flour). GFDx standardizes the collection of national data on the status of fortification legislation, standards, food availability/intake, quality, and coverage of these fortified staple foods and condiments throughout the world. These data are presented on the GFDx website through country dashboards, foundational documents, program performance, and fortification opportunities. GFDx is increasingly becoming a global resource because it is focused on areas that are not adequately addressed by other tools, specifically being focused on fortification, and seeking to increase access to data.

GFDx is currently rebuilding the infrastructure and front end of the website using a serviceoriented architecture approach, moving from proprietary software to open-source and industry-leading providers. This transition involves migrating to a new database, recreating visualizations in Tableau, and implementing a new UI/UX through WordPress.

Scope of Work

The project shall result in a new database and front end for GFDx, with a cutover from the existing site to a new site later in 2023.

The contractor shall:

1. Update the transition plan, including making recommendations on the timeline, order, and database.

2. Migrate data from the current database (RedCap) to the new database

3. Build the front-end based on recently completed wireframes, including migrating static content, implementing Tableau visualizations, and complying with best practices of usability and front-end development.

Additional duties include liaising with the current website host, offering regular updates on progress, and making recommendations for the longer-term future of GFDx.

Deliverables

1. Workplan including timeline, level of effort, and tactical recommendations

2. Implementation of a new database

3. Implementation of new UI/UX

• Creation of all pages included in the sitemap
• Visualizations using Tableau
• Static content migrated
• Dynamic content pulled from the database using an API

4. Weekly updates to the GFDx Project Manager & IT Ops

Time Frame

• Approximately five weeks (26 May – 30 June)

Qualifications

• 5+ years of experience with database management
• 5+ years of experience with website development (WordPress preferred)
• Experience creating visualizations in Tableau

Reference Material

• Website: FortificationData.org
• New Sitemap: https://www.dropbox.com/s/rf6lk8mcdk09jh0/GFDx%20User%20Experience%20Survey%20Ana lysis.pptx?dl=0