Responsibilities :
The Commissions Analyst role is mandated to support the global business by providing timely and accurate computation and validation of commissions payment including performing manual matching under the click and claim process. This is achieved by maximizing the use of enterprise tools and applications such as PowerBI. 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
How to Apply ?
Are you an innovator? Here is your chance to make your mark with a global technology leader. Apply now!
Global Privacy Notice
Lexmark is committed to appropriately protecting and managing any personal information you share with us. Click to view Lexmark's Privacy Notice.
Lexmark
The Commissions Analyst role is mandated to support the global business by providing timely and accurate computation and validation of commissions payment including performing manual matching under the click and claim process. This is achieved by maximizing the use of enterprise tools and applications such as PowerBI. 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
How to Apply ?
Are you an innovator? Here is your chance to make your mark with a global technology leader. Apply now!
Global Privacy Notice
Lexmark is committed to appropriately protecting and managing any personal information you share with us. Click to view Lexmark's Privacy Notice.
Lexmark
Other Info
Cebu
Permanent
Full-time
Permanent
Full-time
Submit profile
Lexmark
About the company
Lexmark jobs
Cebu City, Central Visayas
Position commissions Analyst recruited by the company Lexmark at Cebu, Cebu, Joboko automatically collects the salary of , finds more jobs on Commissions Analyst or Lexmark company in the links above