Database support needed to build an application processing database.
Each year Found in Translation receives hundreds of applications for our Language Access Fellowship Program, which offers a free medical interpreter certificate training to low-income bilingual women. The key tool used in this process is our Selection Document Database System. Ideally, we are seeking someone to clone the system we used last year, while also making some minor adjustments for our new cycle.
In the past we have used a specially designed in-house CRM system, roughly equivalent to a Salesforce instance. This system uses Google Sheets, SQL, and Zapier, along with a branching, highly customized intake/application form using Jotform, and automatic data cleaning and logic checks to make sure that information entered into the forms was standardized and normalized. This was created within the constraints of our organization’s existing workflow/front end spreadsheet tool.
Essentially, we are looking for someone to help us replicate our previous system of intermediate sheets to try to separate data entry, automated data processing/calculations, and data viewing and entry so our selection process can run as smoothly as before.
Key elements: automatic points scoring based on raw data when applications are submitted, ability to use unique ID number to pull all of an applicant’s info to necessary locations across several tabs/spreadsheets, automatically generated PDFs, visually user friendly, minimal bugs.
We estimate to get between 200 and 300 applications over the course of 4-6 weeks, and hope to have the database live in the next month or so.
Please contact Kelly Lynch at email@example.com to express interest (please include a resume and rates) or to receive more information. Please note we are seeking to fill this position immediately.