Financial Planning and Analysis Analyst-USA-CRP

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

About Diversified:

Diversified is a global leader in audiovisual and media technology. We design and build innovative spaces and experiences for clients across industries such as corporate, entertainment, sports, retail, and government. Our team partners with organizations around the world to create environments that connect people through technology.

What to Expect:

At Diversified, you'll work on exciting and complex projects with opportunities to grow your career. We offer a collaborative and flexible work environment, competitive pay and benefits, and a culture that values diversity, inclusion, and innovation. If you're ready to grow, create, and make an impact, Diversified is the place to do it.

Overview

We are seeking a detail-oriented Sales Commission Analyst to manage the monthly commission accrual and payout processes. This role is ideal for a professional who values accuracy, consistency, and long-term process ownership. The analyst will ensure the timely, accurate, and compliant execution of commission calculations and reporting while providing Finance and Sales leadership with reliable data and insights.

Key Responsibilities

Commission Accruals & Reporting

• Consolidate data from multiple systems to prepare accurate monthly commission accrual reports.
• Load, validate, and maintain commission accrual models in partnership with the Accounting team.
• Perform month-over-month variance analysis and identify key drivers, trends, and anomalies.
• Investigate discrepancies and coordinate with relevant stakeholders to resolve data or calculation issues.

Commission Payouts

• Calculate monthly sales commission payouts in accordance with established compensation plans and performance data.
• Review and validate commission calculations for accuracy, completeness, and compliance with company policies.
• Generate and distribute commission statements using automated tools and established processes.
• Maintain accurate records and supporting documentation for commission calculations and payouts.

Data Analysis & Business Support

• Provide ad hoc financial and operational analysis to Finance and Sales leadership.
• Support executive-level reporting, presentations, and analysis for the Executive Leadership Team (ELT) and Sales leadership.
• Maintain detailed process documentation, controls, and standard operating procedures.
• Monitor data integrity across systems, models, and reporting outputs.
• Identify opportunities to improve the efficiency, accuracy, and consistency of commission processes.

Skills & Qualifications

• Advanced Excel skills, including pivot tables, complex formulas, data analysis, and macro automation.
• Experience with Microsoft Dynamics 365, including Customer Engagement and Finance & Operations.
• Strong understanding of accrual accounting, financial reporting, and variance analysis.
• Exceptional attention to detail with strong data validation and problem-solving skills.
• Highly organized and able to manage recurring monthly deadlines with accuracy and consistency.
• Strong written and verbal communication skills, including the ability to clearly communicate and escalation issues.
• Ability to work with sensitive and confidential compensation and financial information with discretion.
• Self-motivated and analytical, with the ability to independently manage established processes and resolve issues.
• Comfortable working in a structured, process-driven environment with a focus on long-term process ownership.

Ideal Candidate Profile

The ideal candidate is dependable, analytical, and highly detail-oriented. They thrive in a structured environment, take pride in maintaining accurate and reliable processes, and are comfortable owning recurring monthly responsibilities. They value consistency, accountability, and building strong, sustainable processes while serving as a trusted resource to both Finance and Sales teams.

#LI-Remote

What We Offer:

We believe great people deserve great benefits. In addition to competitive compensation, we offer a comprehensive benefits package designed to support your health, financial wellbeing, and work-life balance:

• Multiple medical plan options to fit you and your family's needs
  
  • HSA & HRA company contributions
• Dental coverage, including orthodontic benefits, and vision plans
  Company-paid benefits
  
  • Basic Life, AD&D
  • Short-Term and Long-Term Disability insurance
  • Employee Assistance Program (EAP)
• Generous paid time off - 3 weeks PTO plus company holidays and floating holidays
• 401k with company match
• Paid maternity leave
• Healthcare and Dependent Care Flexible Spending Accounts (FSA)
• A wide range of voluntary benefits including Critical Illness, Hospital Indemnity, Accident Insurance, Pet Insurance, Homeowners and Auto Insurance, Supplemental Life and AD&D coverage, and Legal Services
• Commuter benefits
• And much more