[ref. p66742816] Cebu - Commissions Analyst | Hybrid

DiscoverYourMark and Be part of our highly dynamic team to enjoy the following benefits:

• HMO coverage from day 1 of employment for you and your dependents with Maternity coverage
• Expanded Medical Benefit
• Accident and life insurance
• Dental and optical reimbursements
• Free medical consultation with Lexmark’s in-house doctors
• Employee privilege access to lactating, gaming, music and sleeping room
• Health and wellness activities
• Work-life balance
• Semi flex schedule and alternative work arrangements
• Dress down Friday and Shift Allowance
• Company-sponsored team bonding activities
• Career advancement opportunities
• Unlimited access to online learning

***eligibility guidelines apply***

JOB PURPOSE/MISSION/SUMMARY:

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.

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