Scheduling/Airtable/CRM Automation Engineer, Climate Lobby Day
Progressive Data Jobs
Position Summary
Rate: $1,200 – $2,000 flat rate, negotiable based on experience. This should be a simple project for an experienced developer.
The scope is primarily building tools (likely a mix of Airtable Automations supported by scripting / low-code workflows); specifically:
- Build a scheduling workflow to:
- Assist a scheduling team in scheduling meetings between ~800 lobby day attendees and ~250 legislators/staffers
- Identify availability conflicts as they arise in real-time, e.g.
- Student A is double-booked for a meeting with Legislator 1 and Legislator 2, OR
- Student A is originally booked to attend a meeting with Legislator 1, but
- Display custom itineraries for event attendees based on meetings scheduled track/solicit/update missing registration info (signed waivers/permission slips/etc).
- Update & optimize the Airtable database, using best practices, to:
- Automatically collect/update participants’ registration info
- Integrate with our CRM, which will be used to send scheduling emails to legislators’ offices
You will report to the Dangerously Persistent team, who liaises with the client.
Who Are You?
- Ideally, you are:
-
-
- An experienced developer (7–10 years)
- Active in one or more leftist organizing spaces
-
- Ideally, you understand:
-
-
- Airtable features (forms/interfaces/schemas)
- Airtable API
- General relational DB schemas
- Calendaring APIs (e.g. GCal)
- Scheduling/conflict management/handshake problem processes
- Basic email automation flow
- Zapier/Make.com no-code automation
- CRM workflows
-
- Ideally, you already have:
-
- A background in computer science
- Strong scripting skills (Javascript, Python)
- Participated in / organized a lobby day and understand the time-management stress faced by both attendees and organizers
- Designed a similar scheduling/handshake-problem system
- If you don’t meet some of these requirements but are still interested, please try your hand and apply! It’s great for us to know folks with similar skillsets for later on.
What Is The Timeline?
- Assuming senior-level development experience, the anticipated timeline is:
- ASAP: Hire/onboard
- February 1 – February 8: ~15 hours total of work
- February 8: V1 of scheduling workflow complete; begin using & testing
- February 8 – February 13: ~10 hours of scheduling workflow tweaks/debugging
- March 16 – 17: On call remotely to troubleshoot any last-minute issues during event
-
How To Apply:
Email [email protected].
In the SUBJECT of your email, please WRITE: [YDOA] Automation Contractor – YOUR NAME
In the BODY of your email, please WRITE:
- 3 examples of prior work relevant to this job, in no more than 2 paragraphs (AKA 10 sentences)
- 2-3 references, including email/phone contact info
- Which organizing groups you’re currently active with (volunteer or otherwise), if applicable
Please ATTACH only:
- A one-page résumé
How To Prepare for the 30-minute Interview (if selected):
- Be ready to screenshare and walk through non-confidential examples of prior work