Utilizes Microsoft Excel, Access and Business system to maintain a high volume of customer sell pricing and vendor contracts at local, regional and corporate levels along with submitting and balancing vendor rebate claims.
Key Responsibilities include:
Analyzes vendor special pricing agreements (SPA) and sales request for special sell pricing and determines most accurate and efficient process for loading into the business system.
Works with sales team on set-up of new customer pricing matrices.
Works with vendors and sales personnel of upcoming SPA that are up for renewal.
Works with vendors on hierarchy and part number changes that affect contracts.
Identifies and resolves pricing and rebate inconsistencies associated with multiple types of pricing records.
Identifies and updates customer sell records that are impacted on part number supersedes.
Submits and balances high volume rebate claims with multiple vendors.
Provides Finance department with monthly rebate reconciliation.
Works with accounts payable, sales and vendors on rebate discrepancies.
Reviews and updates departmental procedures and instructions.
Supports the Quality initiatives of the Region.
Knowledge/Skills/Abilities to be successful include:
Associate’s degree in Business, Accounting or Finance required with at least two years of job-related experience in business administration, accounting, finance, pricing and/or rebates. Three to four years’ experience will be considered in lieu of an associate’s degree.
Demonstrated ability in creating, updating, and modify tables in Microsoft Access. Demonstrated ability in working with formulas, lookup tables, and pivot tables in Microsoft Excel.
Demonstrated overall knowledge of business processes and how it interrelates with a business system.
Must possess strong analytical, organizational and mathematical skills.
Ability to multitask and handle large volume of detailed work with accuracy.
Effectively balance priorities against work demands in both daily schedules and crisis situations.
Ability to work with minimum supervision: organizing, prioritizing and completing tasks at own initiative.
