Senior Sales Commission Analyst

This is a fully remote position, open to applicants in North Carolina.

📋 Description

• Calculate, process, and issue commission and incentive payments on a weekly to quarterly basis for brokers, agents, and internal sales teams.

• Process commissions for W-2 employees and 1099 independent agents, ensuring the correct treatment is applied.

• Conduct reasonableness reviews prior to payout release, addressing or correcting any outlier payouts.

• Execute a second-person review of weekly agent settlement files before uploading to the bank.

• Determine payouts in accordance with agent agreements, promissory notes, retractions, and addendums.

• Recalculate adjustments, incentives, and commission discrepancies, while communicating issues and resolutions.

• Reconcile sales activity, revenue, margins, and payouts, tracing variances back to their source calculations.

• Utilize Sigma or similar BI tools to validate and analyze commission data.

• Reconcile commission payouts and accruals with Sage Intacct or a similar general ledger system.

• Ensure consistency of employee, plan, and payout data across HRIS, BI, and GL systems.

• Assist with system updates, enhancements, testing, and improvements in payment processing.

• Act as the primary contact for inquiries related to commissions and escalated incentive issues.

• Explain commission calculations and plan mechanics to sales staff, agents, and non-financial stakeholders.

• Train new agents and employees on commission plans and payout calculations.

• Document exceptions and resolutions for reviews and discuss recurring issues with sales management.

• Maintain and enhance internal controls, documentation, and process standards.

• Prepare reconciliation files for month-end and year-end commission accruals.

• Develop and test commission and incentive plans, including modeling cost impacts.

• Prepare management summary reports and reports on attainment/productivity.

• Support sales compensation forecasting, accruals, budgeting, and identify trends for leadership.

• Collaborate with HR, Operations, and Finance on plan intake documentation.

• Document commission plans comprehensively from intake terms to GL treatment.

• Review plan assignments for new hires, promotions, and changes to plans.

• Draft updates to processes and policies for Director review.

• Lead process improvements and various commission-related projects.

⛳️ Requirements

• A minimum of 4 years of experience in sales commissions, incentive compensation, or a similar finance role, including at least 2 years directly administering commission plans.

• Proficiency in using a BI tool (such as Sigma or similar) and a general ledger (like Sage Intacct or similar); HRIS experience is an advantage.

• Advanced skills in Excel (including pivot tables, XLOOKUP/VLOOKUP, nested formulas, and large-data modeling).

• Proven capability to reconcile complex data sets and trace variances to their origins.

• Experience with month-end commission accruals and reconciliations.

• Background in reviewing or approving payment files prior to release.

• Strong written and verbal communication skills, particularly in explaining calculations to sales personnel, agents, and leadership.

• High integrity and discretion when handling confidential compensation data.

• Ability to manage competing deadlines in a dynamic, fast-paced environment.

• Preferred: experience in transportation, logistics, or 3PL environments, particularly with agent or broker-based commission structures.

• Preferred: experience in modeling or designing commission and incentive plans.

• Preferred: Bachelor's degree in Finance, Accounting, Business, or a related field.

• Preferred: experience in calculating commissions for both W-2 employees and 1099 independent contractors or agents.

• Preferred: familiarity with year-end 1099 reporting.

🏝️ Benefits

• Medical benefits

• Dental benefits

• Vision benefits

• Flexible spending account (FSA) benefits

• Health savings account (HSA) benefits

• Paid time off (PTO)

• Short-term disability

• Long-term disability

• 401(k) with up to a 3.5% match