Overview

We are seeking a highly skilled and motivated Data Systems & Visualization Specialist for an immediate, short-term project running through the end of January. The ideal candidate will have deep expertise in Airtable, Fillout, and Tableau to design a robust relational database, build a user-friendly data input interface, and create compelling data visualizations.

Key Project Goals & Deliverables

The consultant will be responsible for three core deliverables:

1. Relational Database Design (Airtable)

• Design and build a comprehensive relational database in Airtable that can efficiently house both survey data from two different versions of a survey (v1 has existing data, but will not be used in the future, v2 has no existing data and will be used going forward.. A draft data schema has already been developed.
• Implement formulas and automation to calculate performance scores based on defined logic.
• Structure and transform the data so it is clean, optimized, and ready for seamless ingestion into Tableau (BI tool).

2. Survey Input Tool Development (Fillout)

• Develop a user-friendly and reliable interface using Fillout for a survey with ~50 questions
• Ensure the tool is designed to allow authorized users to easily update and correct existing survey responses as needed.
• Integrate the Fillout tool directly with the Airtable database to automate data entry.

3. Data Visualizations (Tableau)

• Establish and manage the data connection between Airtable and Tableau using a middleware platform like Zapier or Make (Integromat).
• Develop dynamic, insightful dashboards in Tableau using the prepared data from the Airtable database.
• Connect Airtable with Tableau using Zapier or Make
• Create distinct visualizations that clearly depict:
  • Overall performance against the program's defined pillars.
  • Performance per individual pillar area (detailed breakdown).
  • Areas of Excellence (highlighting top performance).

Required Skills & Experience

• Expert-level proficiency in Airtable, including building complex relational structures, creating advanced formulas, and setting up automations.
• Mandatory experience connecting Airtable to BI tools (like Tableau) using middleware/integration platforms (e.g., Zapier, Make).
• Proven experience with Fillout (or similar advanced form builders like Jotform/Typeform with deep integrations) for creating data input tools.
• Strong expertise in Tableau for developing professional, data-driven dashboards and visualizations.
• A solid understanding of data modeling, ETL processes (Extract, Transform, Load), and best practices for preparing data for Business Intelligence tools.
• Ability to work independently, manage a tight timeline, and communicate technical concepts clearly.

Project Timeline

• Start Date: Immediately

End Date: End of January (approx. 8-9 weeks)

Email beth@managementofthegood.com a copy of your resume and a cover letter describing your fit for the project and your hourly rate, if you are interested.