Commission Analyst

Asure Software • Austin, TX

2d • Onsite

About The Position

The Commissions Analyst is responsible for calculating, tracking, and reporting sales commissions using Excel-based models and Salesforce CRM data. This role requires exceptional attention to detail, strong organizational skills, and the ability to consistently meet deadlines in a fast-paced environment. The ideal candidate is a collaborative team player who can build effective working relationships across all departments and levels — from individual sales reps to senior leadership.

Requirements

• Bachelor's degree in Finance, Accounting, Business, or related field
• Over 8 years of experience in sales compensation, finance, or analytical role
• Demonstrated track record of high accuracy and attention to detail, particularly under deadline pressure
• Strong organizational skills with the ability to manage multiple priorities and deliver consistently on time
• Proven ability to work effectively and build trust across departments and all levels of an organization, from reps to executives
• Advanced Excel skills: pivot tables, XLOOKUP/VLOOKUP, SUMIFS/COUNTIFS, IF/nested IF, data validation; Power Query a plus
• Hands-on experience running reports and dashboards in Salesforce CRM; comfortable navigating opportunities, accounts, and custom objects
• Excellent written and verbal communication skills, with the ability to explain calculations clearly to non-finance stakeholders
• Discretion and professionalism handling confidential compensation data

Nice To Haves

• SQL basics for pulling data from a data warehouse
• Prior experience in HCM/SaaS/B2B sales organizations
• Exposure to commission plan design or sales compensation modeling
• Salesforce Administrator certification or hands-on config experience a plus (not required)

Responsibilities

• Pull and validate sales, bookings, and opportunity data directly from Salesforce CRM for use in commission calculations
• Build and maintain complex Excel commission models (VLOOKUP/XLOOKUP, SUMIFS, pivot tables, nested IF statements) to calculate monthly/quarterly payouts, including tiers, accelerators, and draws
• Reconcile Salesforce CRM opportunity/closed-won data against signed contracts and finance bookings to confirm commissionable revenue, with a meticulous eye for discrepancies
• Maintain a master commission tracker in Excel, keeping rep quotas, territories, and deal splits current and accurate
• Investigate and resolve commission disputes and data discrepancies quickly and accurately, escalating and communicating status proactively
• Prepare and deliver individual commission statements and leadership reports on a strict, recurring schedule — ensuring accuracy and timeliness every cycle
• Partner closely with Sales, Sales Ops, Finance, Payroll and HR to maintain clean data and resolve issues collaboratively, regardless of department or seniority level
• Support commission plan modeling and "what-if" scenario analysis in Excel for new or revised comp plans
• Maintain organized, audit-ready documentation and calculation trails for SOX/compliance purposes
• Manage multiple concurrent deadlines during month-end/quarter-end close without sacrificing accuracy
• Identify opportunities to streamline and automate manual Excel processes (e.g., Power Query, macros, Salesforce report automation)

Benefits

• Medical, Dental, Vision, HSA, FSA- All effective on day 1!
• Company paid Basic Life Insurance, A+D, Long-Term Disability, and Short-Term Disability
• 401K Program with 3% safe harbor contribution
• Employee Stock Purchase Program
• Fitness Reimbursement Program
• Self-Managed PTO

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level