Data & Operations Specialist
About The Position
Constellation is seeking an operational and technically-minded Data & Operations Specialist to own day-to-day CRM operations and system integrations. This role involves ensuring data accuracy, maintaining active automations, and managing integrations across various systems. It's a hands-on, technical position with opportunities for collaboration across the organization. Daily tasks may include debugging automations, building HubSpot reports, importing data, or adding staging models to the data warehouse. The specialist will report to the data & systems lead and work closely with program managers, operations coordinators, and external contractors.
Requirements
- Experience with CRM administration (HubSpot preferred, but Salesforce or similar is relevant).
- Familiarity with Git and command-line workflows.
- Experience with or willingness to quickly learn: Hubspot CRM, Airtable, Slack Enterprise Grid, dbt, DuckDB/MotherDuck, Dagster.
- Experience using agentic AI to safely manage complex workflows and write code.
- Familiarity with APIs (You don't need to be a software engineer, but you should be comfortable reading API docs and troubleshooting with LLMs).
- Demonstrated interest working for mission-driven organizations or causes.
Nice To Haves
- Experience with data warehouse design or business intelligence tools.
- Experience administrating Slack Enterprise Grid, using SCIM and/or in a multi-workspace environment.
- Comfort writing SQL.
- Familiarity with API integrations, including REST APIs, webhooks, OAuth.
- A bachelor’s degree or higher in statistics, computer science, data science, economics, or a related field; or equivalent practical experience.
Responsibilities
- Collaborate with program managers and operations staff to solve their data needs in sustainable and scalable ways.
- Own day-to-day functioning of automations that add or remove people from software systems, ensuring timely on- and offboarding.
- Own data integrity: ensure records have data in required fields, ensure records that should exist do exist, and that overall CRM data is up-to-date.
- Own user identity management, giving people who interact with Constellation a consistent internal ID across all our systems; including designing better ways to deduplicate.
- Manage data imports, exports, and migrations to/from a variety of sources.
- Build new automations and integrations to save staff time and provide new capabilities to the team.
- Own integrations between Hubspot, Airtable, Envoy, Robin, Slack, and Brivo; debugging issues, keeping data in sync, making sure it's flowing correctly and in the right format.
- Administer the Constellation Slack, including using API integrations to save staff time on complex tasks.
- Own and maintain the business intelligence data pipeline. This includes adding data sources, debugging pipeline failures, and keeping data flowing from source systems into reports.
- Create and maintain dashboards and reports in HubSpot and/or BI tools for program managers and leadership.
- Maintain and segment mailing lists in Hubspot; support Program Managers in sending emails through sequences.
- Document our systems, processes, and integrations to create shared knowledge and protect business continuity.
Benefits
- Healthy lunches and dinners catered by our amazing kitchen team
- Unlimited snacks & drinks
- Generous vacation policy
- 401(k) with employer match
- Employer-paid commuter benefits
- High-quality health, dental, and vision insurance
- Friendly and supportive team
- Regular interaction with AI safety researchers and thought leaders
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Education Level
Associate degree
Number of Employees
1-10 employees
