Senior Sales Commission Analyst

Wwshemi; Charlotte (NC); Hybrid; USD 85,000 - 110,000; Full time

Benefits offered by this job

Medical/Dental/Vision

HSA

401(k) with employer match

PTO and Disability benefits

Job summary

Armstrong Transport Group, a leading 3PL based in Charlotte, NC, seeks a Senior Sales Commission Analyst to own accuracy of commission and incentive payments for brokers, agents, and internal sales teams across weekly to quarterly cadences. You will build and test commission plans, perform reasonableness reviews, and serve as the primary point of contact for commission inquiries.

You will collaborate with HR, Operations, and Finance, using Sigma BI and Sage Intacct to ensure plans are documented

Qualifications

• 4+ years in sales commissions or incentive compensation or related finance role.
• Experience with BI tools and general ledger systems (Sigma and Sage Intacct or equivalents).
• Advanced Excel skills including pivot tables, XLOOKUP/VLOOKUP, nested formulas for large datasets.

Responsibilities

• Calculate, process, and release commissions for multiple cadences (weekly to quarterly) for brokers, agents, and internal sales staff.
• Reconcile commissions with the GL and HRIS, ensuring accuracy across systems.
• Support system updates, testing, and improvements to commission processing.
• Explain calculations to sales staff and leadership; train new staff on plans and payouts.
• Prepare commission accruals and variance analyses for month-end and year-end.

Skills

Sigma

Excel advanced

Data reconciliation

Communication

Analytical thinking

Education

Bachelor's degree in Finance/Accounting

Tools

Sage Intacct

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.