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 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. Key responsibilities 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. Systems 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. Reporting & Communications 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. #J-18808-Ljbffr