Data Operations Specialist

About the role

We are seeking an operational and technically-minded Data & Operations Specialist to own day-to-day CRM operations and system integrations ’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 Hub Spot 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.

• 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 s 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 Hub Spot, 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 Hub Spot and/or BI tools for program managers and leadership.
• Maintain and segment mailing lists in Hub Spot; support Program Managers in sending emails through sequences.
• Document our systems, processes, and integrations to create shared knowledge and protect business continuity.

You might be a good fit if you have:

• Experience with CRM administration (Hub Spot preferred, but Salesforce or similar is relevant).
• Familiarity with Git and command‑line workflows.
• Experience with or willingness to quickly learn:
  Hub Spot CRM, Airtable, Slack Enterprise Grid, dbt, DuckDB/Mother Duck, 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.

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.