Commission Analyst

Description Welcome to Aventiv! Please watch this brief video to find out if this is the place you want to be! Aventiv Technologies – Where your future awaits - YouTube **Associate Referral Reward Eligible** Job Purpose: The Commissions Analyst ensures the Company’s commission expense is properly recorded in accordance with GAAP, all facility commission payments are calculated and processed accurately and timely, and all customer reporting/inquiries are addressed timely and professionally. Serves as a liaison with other departments related to customer commission matters, including but not limited to the Executive Team, Sales, and Legal. Essential Duties: Review, interpret and implement financial contractual terms to ensure commissions and other customer payments are accurately reflected in commissions system Reconcile revenue data per commissions system to the general ledger to ensure completeness and accuracy of data; work with Revenue Accounting and IT to research and resolve variances Calculate complex minimum annual payments per contractual terms and track all annual payments, flat payments, and future rate changes by contract Calculate complex commission payments and reporting for Praeses sites Process commission payments and contract incentive payments in accordance with contractual terms and record to general ledger; ensure all commission deductions are accurate and complete before commission payments are issued Analyze commission expense trends as a percentage of revenue to identify and explain variances; resolve issues identified Reconcile assigned general ledger accounts and research and resolve reconciling items on a timely basis; reconciliation monthly payments versus calculated commissions log and provide variance explanations Research and respond to internal and external customer inquiries Comply with SOX controls and departmental guidelines; update internal procedures as appropriate Prepare audit support schedules and work with auditors as needed Perform various ad hoc analyses as assigned Assist with special projects related to new product rollouts, system enhancements, implementing efficiencies and company initiatives Perform other duties as assigned Knowledge, Skills, and Abilities: Thorough understanding of the Company’s revenue streams, systems, and cross-functional processes in order to identify and resolve issues This position is challenged with a multitude of system issues arising from the various revenue platforms and system interfaces that can often go undetected until they reach the Accounting department. Ability to work closely with other departments to identify and research these issues in a timely manner and be able to account for the variances caused by system issues in time to meet the closing schedule and contractual deadlines for commission payments. Proficient in Microsoft office, general ledger, accounts payable and web-based software, with a strong emphasis on advanced Excel skills including VLOOK-up and formulas Strong analytical and problem solving skills Excellent written and verbal communication skills Strong interpersonal and communication skills Must be detail oriented and highly accurate Must be able to multi-task and prioritize workload to meet deadlines Self- sufficient, highly motivated with desire and ability to learn new skills Strong knowledge of GAAP Knowledge of Sarbanes-Oxley Act Minimum Qualifications: High School Diploma or GED 5+ years of business experience to include: Data analytics, commission/royalty calculations, or other related experience in a system-driven environment 2+ years of Accounting experience 1+ years of experience interpreting and implementing contractual terms that involve commissions/royalties or other payments requiring complex calculations Preferred Qualifications: Bachelor’s degree in Accounting, Accounting Analytics or other business-related field, or equivalent experience Experience with Microsoft Dynamics Great Plains SOX compliance experience Telecom experience Doc-link experience Physical Requirements: While performing the duties of this job, the employee is regularly required to: stand, sit, talk, hear, and use hands and fingers to operate a computer, telephone, and a variety of office equipment. Occasionally may need to reach, stoop, or kneel. Salary and Benefits: At Aventiv, our salary and benefits are designed to fit you as a whole person. We offer a salary range based on experience and qualifications to ensure your unique contributions are met with our most competitive offer. $77,315.00 - $85,905.00 per year Eligible for $255 to purchase company equipment (keyboard, monitor, headset, etc. Health Insurance 401(k) Disability Life Insurance Paid Time Off Voluntary Benefits Aventiv Privacy Policy: www.aventiv.com/privacy Equal Employment Policy: Aventiv is proud to be an equal opportunity employer. All decisions regarding recruiting, hiring, promotion, assignment, training, termination and other terms and conditions of employment will be made without regard to race, color, national origin, biological sex, sexual orientation, gender identity, gender expression, gender presentation, religion, age, pregnancy, disability, work-related injury, veteran status, genetic information, marital status, or any other factor that the law protects from employment