The primary purpose of this position is to oversee and manage the internal controls related to $1 billion in vendor allowance tracking of purchase allowances and cost deviations, as well as $100M in national account customer rebates. This role will be responsible for maintaining compliance for the components of allowance tracking program set up, performance of integrity evaluations on earnings, and ensuring compliance as it relates to Sarbanes-Oxley. In addition, the position will seek to provide the primary support to the local distribution centers in training, development, and communication. This position will also be responsible for Vendor allowance tracking related functions, vendor administration functions, national account customer set-up, as well as be responsible for assisting in the completion of calculations associated with national account customer rebates.
Execute purchase allowance and cost deviation earnings integrity evaluations for reasonableness at both a local and national level.
Oversee compliance of local and national vendor allowance non-trade receivables as it relates to auto deduction, reconciliation, deduction and repayments.
Conducts secondary reviews of the program set up audit checklists to ensure that programs are established accurately and are being input to the department standards.
Secures resolution on all outstanding issues as it relates to the set up of SIS programs or billing disputes.
Oversee the National SIS email folder for requests and reply accordingly.
Assist department management with process improvements and enhancements.
Performs research and resolution on billing disputes from vendors through the VSC Remedy system and prepares repayments to be made for items billed directly to the vendor.
Monitors workflow to assist in ensuring assignments are completed in the manner needed.
Works in conjunction with department management on special projects as assigned.
Maintain all necessary control logs and procedures to verify accuracy of data entry against source documents.
Ensure all departmental processes are Sarbanes Oxley compliant and update Sarbanes Oxley documentation on a consistent basis to be provided to department management.
Create and maintain databases relating to department functions and reporting needs.
Manage the process supporting Non-SIS tracked and Vendor Tracked allowance billings including maintaining and updating the monthly passback file.
Independently work on assigned special projects as designated by management team.
Reporting and analysis of supplier information across all systems to include Prism, Peoplesoft, Profits and Data Warehouse as needed by vendor and carrier administration, and various other department requirements.
Process requests to add and maintain the Carrier database within Prism, utilized to track all carriers for Bio Terrorism compliance.
Work in conjunction with Vendor Administrators, and Procurement to validate current and new information added to multiple systems through reporting processes.
Process check requests for pricing audit settlements submitted by National Account Contract Admin Department.
Work indepedently as a highly motivated and flexible self-starter.
Communicates effectively and uses strong organizations skills to work in a collaborative manner at all levels.
Responds professionally and works calmly under pressure.
Priortizes day to day functions and exhibits confidence in decision making.
Demonstrates attention to detail, ability to plan, multi-tasking, and consistent meeting of deadlines.
Bachelor's Degree OR 1+ years experience in a finance-related support function.
Experience using advanced Microsoft Excel skills to create pivot tables and v-lookups recently or in your current/last employment position(s).
Experience using advanced Microsoft Access skills to build databases recently or in your current/last employment position(s).
Bachelor's Degree in a finance-related major.
Prior experience as a Financial Analyst.
Prior systems experience with Peoplesoft.
Prior experience using a system for reporting and analysis of vendor/supplier information.
Exposure to Sarbanes Oxley compliance and documentation processes.
Prior exposure to customer rebates.
Prior exposure to vendor allowance financial tracking.
Prior experience resolving billing disputes with vendors
Prior exposure to reviewing/ensuring compliance with vendor contracts.
Monster - 2 years ago