Pricing and Rebate Specialist

Company: McNaughton McKay
Location: Columbus
Posted on: February 17, 2020

Job Description:

General Summary: 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: 1. 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. 2. Works with sales team on set-up of new customer pricing matrices. 3. Works with vendors and sales personnel of upcoming SPA that are up for renewal. 4. Works with vendors on hierarchy and part number changes that affect contracts. 5. Identifies and resolves pricing and rebate inconsistencies associated with multiple types of pricing records. 6. Identifies and updates customer sell records that are impacted on part number supersedes. 7. Submits and balances high volume rebate claims with multiple vendors. 8. Provides Finance department with monthly rebate reconciliation. 9. Works with accounts payable, sales and vendors on rebate discrepancies. 10. Reviews and updates departmental procedures and instructions. 11. Supports the Quality initiatives of the Region. Knowledge/Skills/Abilities: 1. Associates 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 associates degree. 2. 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. 3. Demonstrated overall knowledge of business processes and how it interrelates with a business system. 4. Must possess strong analytical, organizational and mathematical skills. 5. Ability to multitask and handle large volume of detailed work with accuracy. 6. Effectively balance priorities against work demands in both daily schedules and crisis situations. 7. Ability to work with minimum supervision: organizing, prioritizing and completing tasks at own initiative. Reporting Relationships: Reports to: Corporate Pricing and Rebate Manager Direct Reports: None Working Conditions: Normal office environment EEO/AA/M/F/Vet/Disability Employer

Keywords: McNaughton McKay, Columbus , Pricing and Rebate Specialist, Other , Columbus, Ohio