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:
-
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:
-
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.
