HubSpot RevOps Systems & Analytics Analyst (Ongoing, US Pacific Hours)

We are an enterprise cybersecurity company (API, bot and AI security) looking for a RevOps Systems & Analytics Analyst to join our revenue operations team on an ongoing basis. This is a hands-on execution role. We own the architecture and the decisions; you build, clean, reconcile and report. You will report to our Director of Revenue Operations and work from a single ticket queue, so priorities are always clear. WHAT YOU WILL DO - Build and maintain HubSpot properties across Companies, Contacts, Deals, Line Items and Quotes, with documentation - Build workflows in draft for us to review and activate - Execute data cleanup: dedupe worklists, value normalisation, backfills and association repairs, always with a dry run first - Monitor our CRM integrations and raise a ticket with evidence when a sync breaks - Build core reports and dashboards in the HubSpot custom report builder, and tell us whether a number moved because of the business or because of the data - Write and fix SQL behind our warehouse reporting and reconcile it back to the CRM - Prepare the monthly commission reporting inputs: pull the closed-won extract, reconcile revenue and term fields, and flag defects WHERE WE DRAW THE LINE You produce the worklist and the evidence; we make the call. Schema and architecture decisions, workflow activation, record deletion and merges, and commission sign-off stay with us. WHAT WE ARE LOOKING FOR - 4+ years in revenue operations, CRM administration or business systems analysis - 2+ years hands-on HubSpot administration, including the custom report builder - HubSpot Academy certification in Revenue Operations or Reporting (please be ready to share as requested) - Working SQL: joins, aggregations, CTEs, and debugging a query you did not write - Strong spreadsheets: pivot tables, XLOOKUP, Power Query or equivalent - You check counts and sample records before you write anything - Professional written and spoken English - Consistent availability during 9am-5pm US Pacific - Your own reliable computer, a backup internet connection and a quiet workspace NICE TO HAVE - Salesforce administration or SOQL - BigQuery or another cloud data warehouse - HubSpot API or CLI - Experience supporting a sales commission process HOW WE HIRE 1. Short application, including the screening questions 2. A paid written exercise, about one hour. We send a spreadsheet of roughly 200 anonymised deals; you send back the integrity defects you found with counts, the SQL or formulas you used, what you would fix first and why, and what you would ask us before touching any of it. No access to our systems required. 3. A 45-minute call where you screen-share a report or dashboard you built in a portal you already work in HOW WE WORK Weekly meetings to review our sprint board. Every request is a ticket. You post a short end-of-shift update: what you finished, what you are blocked on and who owns the unblock, and what is next. Escalating a question stops the clock; guessing does not. Structural and destructive changes are reviewed by us before they go live. This is a long-term engagement and we would like to eventually bring the right person in-house.