The Role
Own day-to-day CRM operations, integrations, and data integrity across HubSpot, Airtable, Slack, and other systems. Build and debug automations, manage imports/exports, maintain the BI data pipeline, create reports and dashboards, and document systems. Collaborate with program managers and contractors to deliver scalable data solutions and identity management.
Summary Generated by Built In
About Constellation
Key responsibilities
Data operations
Systems
Reporting & Communications
Skills & experience
About You
Constellation is an independent research center that brings together people throughout the AI safety ecosystem to accelerate insight, research, and talent through better cooperation. Unlike a conference or summit, Constellation operates continuously, in the form of a physical workspace as well as conference-style talks, workshops, and training bootcamps. Continuous operation allows for relationships and conversations to develop over time, meaningfully fostering trust, collaboration, and shared insight. It also makes Constellation a natural field-building hub by rapidly inspiring, orienting, and connecting people who are newer to the field.
Based in Berkeley, CA, our shared workspace hosts over 200 people per week across dozens of AI safety organizations in nonprofits, academia, industry, and government. Hundreds of other researchers spend time at Constellation for shorter visits each year. We believe this is the strongest and highest-output network of AI safety researchers in the world; dozens of participants in past Constellation programs have gone on to safety-focused roles at companies such as METR, Redwood Research, Anthropic, Google DeepMind, OpenAI, and the US and UK Safety Institutes.
About the roleWe are seeking an operational and technically-minded Data & Operations Specialist to own day-to-day CRM operations and system integrations at Constellation. You’ll be the person who keeps our data accurate, our automations active, and our integrations running across a variety of systems.
This is a hands-on, technical role with lots of opportunities to collaborate with internal stakeholders across the org. On a typical day, you might debug a broken automation that's generating duplicate records, build a new HubSpot report for a program manager, import a batch of historical event data, or add a new staging model to our data warehouse. You'll report to our data & systems lead and work closely with program managers, operations coordinators, and external contractors.
Data operations
- 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.
Skills & experience
You might be a good fit if you have:
- 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 have:
- 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.
About You
You’re motivated to build infrastructure that helps people do important work. You take satisfaction in orderly data and reliable systems. When you see a manual, error-prone process, you want to automate it. You’re comfortable exploring a system you’ve never used before and seeing how it works and what it does. You can translate technical considerations into clear language. You can prioritize across a range of complex problems and stakeholder needs.
Compensation & BenefitsThe base pay range for this role is $109,000 – $130,000 per year.
Our benefits are hard to beat! They include:
- 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
This is a full time, on-site role. Our Berkeley office is a few steps from the nearest BART (metro) and bus stop. On-site parking is also available.
The ideal candidate for this role will have some combination of the skills and experiences described above. If you are not sure if you are qualified, we strongly encourage you to apply anyway. Beyond the qualifications outlined, our priority is building a team that will help humanity safely navigate the development of transformative AI. If you would be excited to do this work, we’d love to consider you.
We value diversity in all respects and base our hiring decisions on the needs of the organization and individual qualifications. We welcome applicants from all backgrounds, regardless of race, color, religion, sex, sexual orientation, gender identity or expression, national origin, age or disability.
Skills Required
- Experience with CRM administration (HubSpot preferred; Salesforce or similar 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 and reading API documentation; comfortable troubleshooting with LLMs
- Demonstrated interest working for mission-driven organizations or causes
- Experience with data warehouse design or business intelligence tools
- Experience administrating Slack Enterprise Grid, using SCIM and/or multi-workspace environments
- Comfort writing SQL
- Familiarity with API integrations including REST APIs, webhooks, OAuth
- Bachelor's degree in statistics, computer science, data science, economics, or related field, or equivalent practical experience
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Constellation Institute is a non-profit independent research center dedicated to ensuring transformative AI is developed, deployed, and governed safely. It accelerates progress in AI safety by fostering collaboration across the ecosystem, bringing together experts from nonprofits, academia, industry, and government. Through its Berkeley-based research center and curated programs, it provides the infrastructure and talent development needed to navigate advanced AI risks.
