Financial Planning and Analysis Analyst CRP

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.

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.

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.

• 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.

• 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.

• 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.

• 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.

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

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…