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.
