Pricing and Rebate Specialist

Mcnaughton Mckay Group; Madison Heights (MI); On-site; USD 55,000 - 75,000; Full time

Job summary

McNaughton McKay Group in Madison Heights, MI is seeking a Pricing and Rebate Specialist to manage high volumes of vendor contracts and customer pricing using Excel, Access and our business system.

You will analyze SPAs, load pricing matrices with sales, coordinate renewals with vendors, and balance rebates with multiple partners. Strong analytical skills and accuracy are essential.

Qualifications

• Associate's degree in Business, Accounting or Finance required.
• Two+ years in pricing, rebates, or finance admin.
• Strong Excel (formulas, lookups, PivotTables) and Access skills.

Responsibilities

• Analyze vendor SPAs and load pricing into the system.
• Set up pricing matrices with sales team.
• Coordinate SPA renewals with vendors and sales.
• Manage vendor contract changes affecting parts.
• Identify and resolve pricing and rebate discrepancies.
• Balance monthly rebate claims with multiple vendors.
• Provide monthly rebate reconciliation to Finance.
• Assist accounts payable with rebate issues.
• Review and update departmental procedures.
• Support regional quality initiatives.

Skills

Excel

Access

Pivot Tables

Formulas

Analytical skills

Multitasking

Education

Assoc. degree in Business/Finance

Tools

Microsoft Access

Job description

Pricing and Rebate Specialist

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

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

Job DetailsJob Location: Madison Heights, MI - 1357 E. Lincoln Ave - Madison Heights, MI 48071Position Type: Full TimeMcNaughton McKay Group