Commissions Payment Analyst

Details: Amazing opportunity to support a large customer in the Research Triangle Park Area.  We are seeking a candidate for the Commissions Payment Analyst role.   This person should love working with data. This person should have sharp analytical skills and be able to start, hitting the ground running.  Ideally this candidate will also be able to work with minimal instruction  and with expertise in Microsoft Excel, Outlook and Word.  Preferred knowledge in  Access, Macros and Queries .    Strong Excel skills are required including knowledge in:   Pivot tables Sums VLookups (with large data sets) Count   This position will provide transactional support as follows:   Process timely and accurate commission payments for areas of responsibility; meet internal deadlines and take steps to ensure accuracy of payments as per Terms and Conditions and Exception Approval Matrix Upload and Audit Manual Revenue files---Communicate correction required, complete upload templates and prepare reporting metrics to reflect accuracy Commissions Inquiries -- Perform 2nd level commissions inquiry responses within 24 hours of case creation; update each case within 7 calendar days; and resolve within 30 days.  Escalate level 3 inquiries to appropriate team member; build and maintain FAQ for commission inquiries Goal Sheet Audit and Authorization—in the schedule/deadlines defined by the Business Operations Manager, process pending goal sheets and communicate exceptions to appropriate team member.  Reporting and Other reports as needed Maintain Escalation template for cases that meet escalation criteria Upload and Audit Manual Revenue files---Complete upload templates and prepare reporting metrics to reflect accuracy Log activities associated with payroll processing and case handling These positions will also provide analytical and quality control support as follows:  Centralized payroll for consolidation and final reconciliation at Theatre and Country level as per Terms and Conditions and Exception Approval Matrix Manage payroll processing controls as independent oversight role to commission analysts Update documentation when needed for all pre payroll, payroll, and post payroll activities Manage term agent cases as prescribed by case management protocol Generate commissions payroll consolidation for submission to payroll Maintain “Transition Deck" and Payroll Lead Checklist as prescribed by the Business Operations Manager Produce metrics

View the original article here