Xerox

Job Description

We are looking for a Commissions Analyst with basic accounting knowledge and some related hands-on experience (no need to work as accountant, but work in roles that require accounting basic understanding) to manage region level Sales funnel/pipeline reviews and order tracking, on top of commission analysis, which includes accurate calculation, validation and reporting of incentive payouts. The role requires close collaboration with sales teams, deep understanding of commission structures and the ability to interpret sales attainment data to support business decisions. ​

PURPOSE/MISSION/SUMMARY:
The Global Commissions Analyst role is mandated to support the global business by providing timely and accurate computation and validation of commissions payment.  This is achieved by maximizing the use of enterprise tools and applications such as Power BI.  To be effective, the role is expected to work closely with the sales operations managers across the geographies and proactively provide advice and insights to better manage and present commissions-related data.  On top of this, the role is also a part of the core team based in Lexington, where global direction and design is crafted.

 
KEY ROLES & RESPONSIBILITIES / KEY JOB FUNCTIONS:

• Set-up, publish, troubleshoot and maintain the Global Commissions Power BI dashboard

• Proactively seek ways to build meaningful and relevant visualized data through Power BI.  This involves researching and reaching out to relevant resources and personnel to achieve the desired outcome.

• Set-up role-level security for different user types (admin, sales managers, sales rep, executive) to ensure confidentiality to data

• Provide access to all users according to role-level security

• Communicate report to authorized business contacts monthly

• Work to resolve issues around the use of the dashboard

• Train users on the usage of Power BI dashboard

• Answer questions from the sales team as well as from geo sales operations

• Perform audit to ensure accuracy of data

• Proactively provide insights/inputs/suggestions to the team’s existing processes with the objective of improving performance and quality

• Compute and validate global commissions payment

• Extract HR report from Workday to be used as reference for determination of payout

• Coordinate with NA Admin (based in Lexington) to confirm final payroll data

• Obtain commissions payroll approval from Global Commissions manager

• Transmit final computation to Payroll for payment

• Monitor and ensure that Sales personnel who are terminated will be provided with last settlement containing credit card balance, last commission date of payment and amount and forwarded to their sales manager for signature and information for (NA);

• Investigate and perform root cause analysis on observed variances and recommend corrective action.

• Proactively communicate best practices among the different geos. Having global visibility, this role is expected to share best practices so these can be leveraged globally.

• Prepare P&L reports for commissions payment, O2C, MPS contracts

• Extract SAP reports using AFO and assign attainment according to account ownership

• Submit reports to NA Admin and other contacts

• Prepare manual check as requested from time to time

• Perform other business-related activities that may be assigned from time to time

• Establishes and maintains relationships with key business contacts in HR, Finance, Sales Operations, etc.

• Proactively initiate continuous improvement projects.  This role is expected to actively seek out opportunities in the process that could be eliminated, shortened, or improved, especially through automation.

• Coordinate with the audit team and ensure needed information is provided in a timely manner.

COMPETENCIES, SKILLS, KNOWLEDGE & ABILITIES:

• Should have strong customer service background

• Should be proficient in Power BI

• Ability to effectively communicate in standard business English

• Should be proficient in Microsoft Excel, including data manipulation and the ability to create formulas and automation

• Should have strong skills in Microsoft PowerPoint, including ability to import charts and graphs

• Should be proficient of willing to learn Power Automate, PowerApps or Power Query

• Can apply critical thinking when the situation requires so

EDUCATION, EXPERIENCE & CERTIFICATIONS BASIC REQUIREMENTS:

• Bachelor’s degree holder

• At least 6 years relevant experience or been in a similar role

• Strong Accounting background to support Sales and Sales Operations.

• Deep understanding of commission structures and the ability to interpret financial data to support business decisions.