Tracking Volunteer Membership Through a Centralized Database

The International Transformation Foundation's mission is to help communities in Africa obtain access to reliable and affordable clean tap water while empowering young Americans through educational, cultural and social volunteering opportunities.

Project at a Glance:

Team:

Senior Data Analyst

Hours Engaged:

Skills & Stack:

Airtable

Problem

ITF provides youth leadership and entrepreneurship programs across the world with locations in Kenya, Rwanda, and the United States. The organization manages a large volunteer network to support their program initiatives. Previously, they tracked membership data in Excel, which limited their ability to scale and made it hard to keep information up to date with their remote team. Furthermore, prospective volunteer members applied via forms on their website, and ITF had to manually transfer this data into Excel, which was a time-consuming process.

Solution

Prometheus matched ITF with a senior data analyst who designed and set up an Airtable database to consolidate and centralize all volunteer member information in one place.
Existing application forms were transferred into web-based forms so that the information would flow directly into their database. This integration enabled the organization to facilitate their application review process and manage their members in one place.

“Working with Prometheus has been great. Prometheus showed a high level of expertise in project management and problem solving… The membership database project helped us tackle the problem of having to [make offline] update[s]. It also improved our recruiting process.” - Judith (Operations Director, ITF)