Sales Compensation Operations Specialist

Brightwheel; United States; On-site; USD 80,000 - 110,000; Full time

Job summary

Brightwheel is seeking a Compensation Operations Specialist to own the monthly turnover for sales comp trackers, diagnose data-health alerts, and investigate Salesforce data issues, using AI and SQL to speed up digging. You will work remotely with teams across time zones and maintain self-serve tools like payout calculators and deal-status lookups.

The role emphasizes accurate data, end-to-end problem ownership, and continuous improvement in payout processes and policies.

Qualifications

• 2+ years in a recurring, accuracy-critical operations role: commissions, payroll, or revenue ops.
• Experience using AI tools (Claude, ChatGPT, Gemini, Copilot) as part of daily work.
• Hands-on in large, formula-heavy spreadsheets and debugging models.

Responsibilities

• Handle the comp question queue daily: diagnose missing deals, corrections, headcount and revenue discrepancies; resolve or route with evidence.
• Run monthly turnover for sales comp trackers: build month, refresh rosters, load targets, multipliers, and accelerator thresholds; QA formulas.
• Monitor daily data-health alerts, investigate warnings, verify fixes after refresh.
• Investigate Salesforce data issues that affect comp credit using AI and SQL; file and track tickets; log defect patterns.
• Apply mid-month roster changes per policy and double-check each one.
• Maintain rep self-serve tools (payout calculators, deal-status lookup, chatbot) and flag AI misanswers for fixes.

Skills

2+ years in ops role

AI tools in day-to-day work

SQL

Tools

SQL

Google Sheets

Excel

Job description

Our Mission and Opportunity

Early education is one of the most important determinants of childhood outcomes, a critical support for working families, and a $175B market that remains underserved by modern technology. Brightwheel is the largest, fastest growing, and most loved platform in early ed, trusted by millions of educators and families every day. We are a three-time Cloud 100 company, backed by top investors including Addition, Bessemer, Emerson Collective, Lowercase Capital, Notable Capital, and Mark Cuban.

Our Team

Our team is passionate, talented, and customer-focused. We embody our Leadership Principles in our work and culture. We are a distributed team with remote employees across every US time zone, as well as select offices in the US and internationally.

Who You Are

You'll thrive here if you...

• Like being in the work. A full queue of comp questions is something to clear, not something to delegate.

• Dig into the details until you understand exactly why a number is what it is. "The AI said so" and "it looks about right" don't satisfy you.

• Use AI across everything you do: formulas, data comparisons, record lookups, drafting replies. You know where it's reliable and where you need to check it yourself.

• Own problems end to end, from diagnosis and fix through verification and the message back to the person who raised it.

• Care about the people on the other side of the ticket. A rep's commission is their paycheck.

• Get better every month: you notice patterns in your work and raise them, so the same issue doesn't keep coming back.

What You'll Do

• Work the comp question queue hands-on every day. Diagnose missing deals, target corrections, and headcount and revenue discrepancies; resolve what you can directly; route the rest to Systems, Analytics, or Accounting with evidence; and close the loop. Our Claude-assisted triage speeds up diagnosis, but you own every answer.

• Run the monthly turnover for our sales comp trackers: build each new month, refresh rosters, load targets, multipliers, and accelerator thresholds, and QA formula and roll-up integrity before managers and reps see anything. Use AI for the build and the diffs, and check payout-affecting items yourself.

• Monitor automated daily data-health alerts, investigate every warning or failure to root cause, and verify the fix after the next refresh.

• Investigate the Salesforce data issues that break comp credit (duplicate records, wiped dates, miscoded fields), using AI and SQL to speed up the digging. File and track system tickets, and keep a log of defect patterns.

• Apply mid-month roster changes (prorated targets for exits, transfers, promotions, leave returns, and time off) according to our documented policies, and double-check each one.

• Keep our rep self-serve tools current, including the payout calculators and deal-status lookup and chatbot. Flag where the AI tools get answers wrong so we can fix them.

What You've Done

• Qualified candidates usually bring 2+ years in a recurring, accuracy-critical operations role: commissions or incentive ops, payroll, billing or revenue ops, finance ops, or similar reconciliation-heavy work.

• Owned a high-volume request queue or ticket intake with internal customers and a response-time expectation.

• Used AI tools (Claude, ChatGPT, Gemini, Copilot, or similar) as a regular part of day-to-day work: analysis, formulas, lookups, drafting. You don't need to have built automations.

• Worked hands-on in large, formula-heavy spreadsheets (Google Sheets or Excel) and debugged someone else's model.

• Reconciled data between a CRM or system of record (Salesforce, NetSuite, HubSpot, or similar) and a downstream report, and explained the gap.

• Worked remotely with teams in a different time zone, communicating primarily in writing.

What Sets You Apart

• Direct experience administering sales commissions or variable pay plans.

• You've built a simple AI workflow or automation (a custom GPT or Claude Project, or an Apps Script or Zapier flow) that cut down a repetitive task.

• SQL (or AI-assisted SQL) against a data warehouse.

• You've written or rewritten an SOP that other people now follow.

Technology

Claude (primary AI tool, including connectors to Salesforce, Redshift, Slack, and Google Drive), Google Sheets and Apps Script, Salesforce, SQL/Redshift, Sigma (BI), Slack, and Rippling.

Brightwheel is committed to creating a diverse and inclusive work environment and is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity, gender expression, sexual orientation, national origin, genetics, disability, age, or veteran status.