ARC Innovator – Database Consultant

  • Volunteer
  • Anywhere
  • Posted 1 week ago


ARC Innovator Title:

Database Consultant

Who is the nonprofit partner? 

In 1993, Richard J. Medalie, a successful Washington lawyer, wrote to his fellow Harvard Law School classmates to solicit their involvement in “an exciting development” that had occurred during their 35th Reunion. “Members of our Class,” he reported, “voted to establish a Class of 1958 sponsored and funded foundation to help organize, establish, and guide state centers for law in the public interest throughout the country.”

Thus was launched an entity stemming from discussions that had been germinating for several years amongst Medalie and a group of fellow Harvard-trained lawyers who sought a new approach to pro bono legal organizations. Their strategy was to focus on broad systemic social initiatives, rather than the traditional model of providing legal services to individuals.

Appleseed has now been in operation for more than twenty years and support a nonprofit Network of 18 Centers across the U.S. and Mexico that are dedicated to advancing local solutions to chronic poverty and injustice.

Major programs at the binational level are immigration (providing resources to help immigrant families protect their children and assets; advocating to improve the immigration court system; advocacy to protect the due process rights of immigrants) and financial access issues (advocating for and protecting consumer financial protection regulations). Through engagement with our pro bono partners, Appleseed works to ensure that government advances the public interest, corporations treat consumers fairly, and all can exercise rights and enjoy real opportunities.

What skills or interests do I need to do the project?

The Innovators should have experience with the Salesforce database, database training and instruction, as well as database design and development. It is necessary for the Innovator to be able to analyze data needs and structure the database to fit those needs. Some knowledge of nonprofit donor development would be beneficial.

What’s the project all about?

Appleseed has used salesforce as a database/CRM the last several years. However, usage of this database is sporadic and ineffective. A previous staff person set up the system and it seems both overly complex, but also not sufficient for what the organization needs it for. Appleseed needs to be able to track their donors, pro bono partners, various Appleseed Center activities, and efficiently event plan using this information.

This organization needs assistance evaluating current status of the database, determining whether it is the right platform/system to use. If it is the best platform for Appleseed to use, then it must be reformatted to meet the organization’s needs. Data clean up will be necessary, as well as moving the data to a new system if Appleseed’s current system is insufficient.

What are the project objectives and deliverables?

  • Review/evaluate current status of Appleseed’s database
  • Based on the organization’s needs, determine whether it is the right platform/system for them to use
  • If it is, reformat it to meet the organization’s needs, assisting them in data cleanup, train staff on using it
  • If it is not, move the data to a new system, assist in data cleanup, train staff on using it

Who from the organization will provide me with support?

Elisa Ortiz, Director of Network Collaboration, will provide support on the project.

How long will the project take?

It is anticipated that the project will take 10-12 weeks.

Where will I complete the project?

The work can be done remotely or onsite.


Author: alumnicorps

Share This Post On