Commission & Incentive Analyst

SUMMARY

The Commission and Incentive Analyst is a detail-oriented and analytical professional responsible for managing the calculation, analysis, and reporting of commissions and incentive compensation for sales and customer-facing teams. This role ensures timely and accurate payouts, supports the development and administration of compensation plans, and delivers data-driven insights to help align performance with business goals.

ESSENTIAL DUTIES

Commission Calculation & Processing

· Calculate monthly, quarterly, and annual commissions and bonuses based on compensation plans.

· Ensure accuracy and compliance with company policies and compensation structures.

· Reconcile discrepancies and resolve commission-related inquiries from employees.

Data Management & Reporting

· Maintain and validate data from CRM systems (e.g., Salesforce), ERP systems, and payroll platforms.

· Generate regular and ad hoc reports on compensation metrics, performance, and trends.

· Provide dashboards and visualizations for leadership and finance teams.

Plan Design & Support

· Collaborate with HR, Finance, and Sales leadership to support the design and implementation of incentive plans.

· Model and forecast compensation scenarios to evaluate plan effectiveness.

· Document and communicate plan rules and updates to stakeholders.

Compliance & Audit

· Ensure adherence to internal controls and audit requirements.

· Maintain documentation for audit trails and compliance reviews.

Payroll Reconciliation

· Reconciliation of payroll and benefit amounts from the payroll register to the GL

· Reconciliation of actual payroll expenses vs. accruals

· Coordinate with Accounts Payables in ensuring payments for payroll suppliers are processed timely

· Coordinate with Payroll to ensure timely payments, accurate deductions (e.g., taxes, claw backs, etc.), and proper documentation of retroactive adjustments.

QUALIFICATIONS

· Education

o Bachelor’s Degree in Accounting, Finance, Business Administration, or related field

· Experience

o 2+ years of experience in compensation analysis, payroll, or financial operations

o Strong excel skills and experience with commission software (e.g., Xactly, Varicent) is a plus

o Familiarity with CRM and ERP systems (e.g., Salesforce, NetSuite)

o Excellent analytical, problem-solving, and communication skills

o High attention to detail and ability to manage multiple deadlines

· Licensure

o Valid Guam Driver’s License

KNOWLEDGE, SKILLS, AND ABILITIES

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions.

· Knowledge

o Knowledge of sales compensation structures and incentive plans

o Understanding of payroll processes and compliance requirements

o Familiarity with CRM systems (e.g., Salesforce) and ERP systems (e.g., NetSuite, SAP)

o Experience with commission software (e.g., Xactly, Varicent, CaptivateIQ)

o Basic understanding of SQL or data querying (a plus)

· Skills

o Advanced Excel proficiency (pivot tables, VLOOKUP/XLOOKUP, formulas, macros)

o Data analysis and reconciliation

o Strong documentation and reporting capabilities

o Ability to interpret and apply compensation plans accurately

· Abilities

o Strong analytical thinking and attention to detail

o Ability to identify discrepancies and trends

o Troubleshooting and resolving commission disputes

o Clear and concise communication across departments (sales, HR, finance)

o Explaining complex calculations in simple terms

o Managing multiple deadlines and priorities in a fast-paced environment

PHYSICAL DEMANDS

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

· The physical requirements of this position involve sedentary work, which involves sitting most of the time.

· Administrative work is required working on a PC system for 75% of the working day. The worker is required to have close visual acuity to perform activities such as preparing and analyzing data and figures, and viewing a computer terminal

WORK ENVIRONMENT

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

· In door office, air conditioning, well-lit office space

· This role routinely operates standard office equipment such as computers, phones, photocopiers, and filing cabinets

SUPERVISORY RESPONSIBILITY

This position has no direct supervisory responsibility

OTHER DUTIES

This job description is not designed to cover or contain a comprehensive listing of activities, duties, or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time, with or without notice.

Job Type: Full-time

Benefits:

• 401(k)
• 401(k) matching
• Dental insurance
• Employee assistance program
• Employee discount
• Flexible schedule
• Health insurance
• Life insurance
• Paid time off
• Referral program
• Tuition reimbursement
• Vision insurance

Work Location: In person