Revenue Operations Analyst
Rainbow
IT, Operations
United States
USD 90k-120k / year + Equity
ABOUT RAINBOW
Rainbow is reimagining commercial insurance for a new generation of independent agents. As a tech-enabled specialty underwriter, we empower agents with smarter tools, dynamic underwriting, and industry-specific programs that make it easier to protect the businesses they serve.
ABOUT THE ROLE
We are hiring a Revenue Operations Analyst to be the technical backbone of our go-to-market motion.
This person will own the data, CRM, and reporting infrastructure that our sales, marketing, and partnership teams run on every day. You will be the first person we turn to when we need to know what is happening in the business, and the person executive leadership relies on for trustworthy numbers.
This role exists because we are doubling down on operating with data. Our previous RevOps lead built a strong foundation across HubSpot, Hex, and our forecasting stack. Your job is to take what works, harden it, and push it forward technically: better models, cleaner data, faster answers, and more automation.
WHAT YOU WILL OWN
HubSpot Administration & GTM Systems
You will:
- Be the HubSpot power user across workflows, custom properties, lifecycle stages, lead routing, territory assignment logic, segmentation, and account/contact-level data hygiene.
- Run the integration stack across HubSpot, Instantly, Zapier, Formcrafts, and Tremendous.
- Own admin access across Tremendous, Instantly, Zapier, and Formcrafts.
- Keep our system of record clean, organized, and auditable.
Reporting, Dashboards & BI
You will:
- Build and maintain dashboards in Hex and HubSpot covering team activity, onboarding and appointment requests, weekly pipeline, partner production, and the metrics our leadership team uses daily.
- Set and maintain GTM targets alongside leadership, not just the dashboards that report on them.
- Be the production-data answer machine. When leadership asks, “How many submissions did Houston, TX have last week?” you have the answer in minutes, not days.
- Support ad hoc analytical workstreams, including Top 20 agency aggregator tracking, Florida agent prioritization, and real-time data for cross-functional projects.
Forecasting & Financial Modeling
You will:
- Maintain our state-level production forecast across admitted and non-admitted/E&S, premium adjustments, and growth-rate calibration.
- Run renewal and retention modeling using cohort premium data and our retention tracker.
- Partner with leadership on forecast governance by flagging rigidity in formulas, proposing where to tighten or loosen assumptions, and translating model output into real-world targets.
Lead Operations
You will:
- Own lead import and distribution, including SOP execution, edge-case troubleshooting, and continuous improvement.
- Maintain sales team territory assignment logic and refine it as we add states, agents, and reps.
- Build audiences for outbound campaigns in close partnership with the Lifecycle Marketing Manager.
Commissions & Partner Operations
You will:
- Run sales team commission calculations and payouts each cycle using our SOP and payout file.
- Support variable compensation components for roles like inbox and marketing coordination.
- Maintain the Partnership Directory and partnership reporting dashboards in Hex, including default and payable partners and program-splice views.
WHAT WE ARE LOOKING FOR
- 3–5 years in Revenue Operations, Sales Operations, Business Intelligence, or a closely related analytical role at a B2B or B2B2C company.
- Strong SQL skills and experience with at least one modern BI tool. We use Hex, but experience with Looker, Mode, Sigma, Tableau, or similar tools is great.
- HubSpot power-user experience. You have built workflows, custom objects, complex reports, and integrations, not just used the UI.
- Comfort building forecasting and financial models in Excel or Google Sheets, with an instinct for when to push logic into a database versus a spreadsheet.
- High judgment around data quality. You catch your own mistakes before leadership does. You know the difference between a number that is technically correct and a number that is actually right.
- Fast, direct communication. You can answer a leadership question in two sentences and a chart, not a 12-slide deck.
BONUS POINTS
- You have helped an organization shift its ICP up-market and understand the operational implications.
- You have experience in insurance, fintech, or another regulated, multi-state distribution business.
- You have Python or other scripting experience for automation.
- You are comfortable with dbt or modern data stacks.
- You have used AI tooling like Claude, Cursor, or similar tools to compress operational work.
COMPENSATION & LOGISTICS
- Base salary: $90,000–$120,000, depending on experience.
- Quarterly Bonus eligible
- Meaningful equity in a fast-growing company.
- Comprehensive medical, dental, and vision coverage.
- Remote-friendly within the U.S.
HOW TO APPLY
Send a resume and a short note to brennen@userainbow.com.
If there is a project or model you are particularly proud of, include a link or a description. We will read it.