Pricing and Rebate Specialist

Mcnaughton-mckay Electric Co; Madison Heights (MI); On-site; USD 52,000 - 68,000; Full time

Job summary

McNaughton McKay Group in Michigan is seeking a Pricing and Rebate Specialist to maintain pricing and vendor contracts using Excel, Access, and the business system. The role supports sales, vendors, and finance with rebate claims and monthly reconciliations.

The ideal candidate has an associate degree in business/finance and proven Excel Access skills, with strong analytical and organizational abilities to handle high volumes accurately.

Qualifications

• Associate’s degree in Business, Accounting or Finance required with at least two years of related experience.
• Experience creating, updating, and modifying tables in Microsoft Access.
• Proficiency with formulas, lookup tables, and pivot tables in Microsoft Excel.
• Strong analytical, organizational and mathematical skills.
• Ability to multitask and balance priorities against daily demands.

Responsibilities

• Analyze vendor SPAs and load pricing into the business system.
• Set up new customer pricing matrices with the sales team.
• Manage vendor pricing renewals and contract changes.
• Identify and resolve pricing and rebate inconsistencies.
• Submit and balance high-volume rebate claims.
• Provide monthly rebate reconciliations to Finance.
• Collaborate with Accounts Payable on rebate discrepancies.
• Support the region's Quality initiatives.

Skills

Pricing analysis

Excel

Access

Pivot tables

Rebate management

Vendor contracts

Education

Associate’s degree in Business, Accounting or Finance

Tools

Microsoft Access

Microsoft Excel

ERP system

Job description

McNaughton McKay GroupPricing and Rebate SpecialistGeneral 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: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.