Senior Sales Commission Analyst
Armstrongtransportgroup · Remote · 2-3 years · Full-time
Key skills
- Performance Management
- General Ledger
- Reconciliation
- Accounting
- Budgeting
- Logistics
- Hris
Job description
About Armstrong Transport Group
Armstrong Transport Group is a third-party logistics provider headquartered in Charlotte's South End, with additional locations in Boise, ID, and Schaumburg, IL. We use innovative technology to create seamless connections between shippers and carriers. More than 150 independent agent offices rely on us to grow their businesses, supported by a corporate team of over 230 employees. Armstrong is recognized as a US Best Managed Company and a Top Workplace.
Role Summary
The Senior Sales Commission Analyst owns the accuracy of commission and incentive payments for ATG's brokers, agents, and internal sales teams, covering both W-2 employees and 1099 independent agents on cadences ranging from weekly to quarterly. This role builds and tests commission plans, performs a reasonableness review before every payout release, and is the primary point of contact for commission inquiries. The Senior Analyst works in Sigma (or a similar BI tool) and Sage Intacct (or a similar general ledger), and partners with HR, Operations, and Finance so plan terms arrive complete and every plan is documented end-to-end. The role reports to the Director, Treasury and Finance Operations and has no direct reports.
Responsibilities
Commission Processing and Accuracy
Calculate, process, and release commission and incentive payments on multiple cadences, ranging from weekly to quarterly, for brokers, agents, and internal sales personnel
Process commissions for both W-2 employees and 1099 independent agents, applying the correct treatment for each
Perform a reasonableness review of each commission run before payout release, and hold or correct payouts that fall outside expected ranges
Perform second-person review of the weekly agent settlement file before bank upload
Calculate and process payouts tied to agent agreements, promissory notes, retractions, and addendums
Recalculate adjustments, incentives, or errors arising from commission calculations, and communicate the source of each issue and its resolution to all affected parties
Validate commission data by reconciling sales activity, revenue, margins, and payouts, and trace variances back to the original calculation
Systems and Data Integrity
Use Sigma (or a similar BI tool) to pull, validate, and analyze commission data
Reconcile commission payouts and accruals to Sage Intacct (or a similar general ledger)
Keep employee, plan, and payout data consistent across the HRIS, BI, and GL systems
Support system updates, enhancements, and testing, and recommend payment-processing improvements
Stakeholder Support and Training
Act as the primary point of contact for commission inquiries from employees and agents, and handle escalated questions on complex commission or incentive issues
Explain commission calculations and plan mechanics clearly to sales staff, agents, and non-finance stakeholders
Train new agents and employees on their commission plans and how payouts are calculated
Reviews, Controls, and Reconciliations
Document reasonableness-review exceptions and resolutions, and review recurring issues with sales management
Maintain and strengthen internal controls, documentation, and process standards
Prepare commission accrual reconciliation files for month-end and year-end
Reporting, Analysis, and Plan Design
Build and test new commission and incentive plans before launch, including modeling their cost impact
Prepare commission and incentive summary reports for management
Build attainment and productivity reports for performance management and cost analysis
Support forecasting, accruals, and budgeting related to sales compensation, and flag trends for leadership
Process and Policy
Partner with HR, Operations, and Finance on the plan intake template so all plan terms arrive in one document
Document each commission plan end-to-end, from intake terms through calculation logic, payout, and GL treatment
Review plan assignments for accuracy, including new hires, promotions, and plan changes entered by the settlements team
Draft process and policy updates for review by the Director, Treasury and Finance Operations
Identify and lead process improvement initiatives and other commission projects as assigned
Requirements
4+ years of experience in sales commissions, incentive compensation, or a related finance role, with at least 2 years administering commission plans directly
Experience with a BI tool (Sigma or similar) and a general ledger (Sage Intacct or similar); HRIS experience a plus
Advanced Excel skills (pivot tables, XLOOKUP/VLOOKUP, nested formulas, large-data modeling)
Demonstrated ability to reconcile complex data sets and trace variances back to their source
Experience with month-end commission accruals and reconciliations
Experience reviewing or approving payment files before release
Strong written and verbal communication, including explaining calculations to sales staff, agents, and leadership
High level of integrity and discretion with confidential compensation data
Ability to manage competing deadlines in a fast-paced environment
Preferred Qualifications
Experience in transportation, logistics, or 3PL environments, especially agent- or broker-based commission models
Experience modeling or designing commission and incentive plans
Bachelor's degree in Finance, Accounting, Business, or a related field
Experience calculating commissions for both W-2 employees and 1099 independent contractors or agents
Exposure to year-end 1099 reporting
Benefits
ATG offers medical, dental, vision, flexible spending, and HSA benefits on the first of the month following the date of hire. Additional benefits include PTO, short- and long-term disability, and a 401(k) with up to a 3.5% match.
Equal Opportunity
Armstrong Transport Group, LLC is an equal opportunity employer. We do not discriminate in any aspect of employment based upon race, religion, color, national origin, gender (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, gender expression, age, status as a protected veteran, status as an individual with a disability, or other applicable legally protected characteristics.
Apply on the official Armstrongtransportgroup careers page
Check your resume match score for this job free on Job Scanner