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.
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.
Similar Jobs
eCommerce • Fashion • Retail • Sales • Wearables • Design
Provide warm, knowledgeable customer service and styling advice to drive sales. Maintain product knowledge, assist with purchases and checkout, organize stockroom/POS tasks, and support omni-channel selling. Must lift up to 50 lbs, work flexible retail hours, and collaborate with team to meet store goals.
eCommerce • Fashion • Retail • Sales • Wearables • Design
Provide personalized styling and sales support to customers, driving purchases through product knowledge, styling advice, and storytelling. Maintain store operations including POS transactions, stockroom organization, and flexible scheduling. Perform physical tasks like lifting merchandise and merchandising the sales floor while collaborating with team members and learning omni-channel selling techniques.
eCommerce • Fashion • Retail • Sales • Wearables • Design
Provide friendly, knowledgeable in-store customer service and styling advice to drive sales. Maintain product knowledge, assist customers with purchases and checkout, organize stockroom and POS transactions, lift and merchandise product, and support team goals during flexible retail hours including nights, weekends, and holidays.
What you need to know about the San Francisco Tech Scene
San Francisco and the surrounding Bay Area attracts more startup funding than any other region in the world. Home to Stanford University and UC Berkeley, leading VC firms and several of the world’s most valuable companies, the Bay Area is the place to go for anyone looking to make it big in the tech industry. That said, San Francisco has a lot to offer beyond technology thanks to a thriving art and music scene, excellent food and a short drive to several of the country’s most beautiful recreational areas.
Key Facts About San Francisco Tech
- Number of Tech Workers: 365,500; 13.9% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Google, Apple, Salesforce, Meta
- Key Industries: Artificial intelligence, cloud computing, fintech, consumer technology, software
- Funding Landscape: $50.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Sequoia Capital, Andreessen Horowitz, Bessemer Venture Partners, Greylock Partners, Khosla Ventures, Kleiner Perkins
- Research Centers and Universities: Stanford University; University of California, Berkeley; University of San Francisco; Santa Clara University; Ames Research Center; Center for AI Safety; California Institute for Regenerative Medicine
