Remote Sales Commission FP&A Analyst

Diversified; Kenilworth (NJ); Remote; USD 75,000 - 110,000; Full time

Benefits offered by this job

Medical plans

Dental & vision

3 weeks PTO

401k match

Paid maternity leave

FSA

Commuter benefits

Job summary

Diversified is seeking a detail-oriented Sales Commission Analyst in a remote-friendly role to manage monthly commission accruals and payouts. You will ensure accurate calculations and reporting, delivering reliable data to Finance and Sales leadership.

The position involves data consolidation, model validation, variance analysis, and maintenance of documentation while supporting executive-level reporting and ongoing process improvements.

Qualifications

• Advanced Excel skills with PivotTables, complex formulas and data analysis.
• Experience with Microsoft Dynamics 365, including CE and FO.
• Strong understanding of accrual accounting, financial reporting, and variance analysis.

Responsibilities

• Consolidate data from multiple systems to prepare monthly commission accrual reports.
• Load, validate, and maintain commission accrual models with Accounting.
• Perform month-over-month variance analysis and identify drivers, trends, and anomalies.
• Investigate discrepancies and coordinate across stakeholders to resolve issues.

Skills

Advanced Excel

Dynamics 365

Accrual accounting

Data validation

Variance analysis

Communication

Tools

Pivot tables

Macrol automation

Job description

Diversified is seeking a detail-oriented Sales Commission Analyst in a remote-friendly role to manage monthly commission accruals and payouts. You will ensure accurate calculations and reporting, delivering reliable data to Finance and Sales leadership.

The position involves data consolidation, model validation, variance analysis, and maintenance of documentation while supporting executive-level reporting and ongoing process improvements.