Advanced Pricing Specialist

Mcnaughton Mckay Group; Madison Heights, Suwanee (MI, GA); On-site; USD 65,000 - 90,000; Full time

Job summary

Mcnaughton Mckay Group in Madison Heights, MI seeks an Advanced Pricing Specialist to analyze, create, and maintain high volumes of customer sell pricing and vendor contracts using Excel, Access, and the SXe business system.

You will design pricing strategies and infrastructures, develop tools to increase department efficiency, train new pricing analysts, and support quarterly updates and process improvements. Evening/weekend testing may be required.

Qualifications

• Bachelor’s degree in Business, Finance, or Computer Science or related field; 5+ years in pricing, analytics, or related area.

Responsibilities

• Analyzes vendor SPAs and sales requests for special pricing and loads them into the business system efficiently.
• Analyzes cost change impact of renewed SPAs and collaborates with account managers and vendors.
• Sets up new customer pricing matrices with the sales team and negotiates upcoming SPAs for renewal.
• Works with vendors on pricing hierarchy and part-number changes affecting SPA contracts.
• Identifies and resolves pricing and rebate inconsistencies across pricing records; updates affected sell records as needed.
• Develops and updates departmental procedures and pricing strategies; creates Excel/Access tools to boost efficiency.
• Participates in SXe update testing, including occasional evening/weekend work; provides training for new pricing analysts.

Skills

Pricing analytics

Analytical thinking

Communication skills

Problem solving

Education

Bachelor’s degree in Business, Finance, or Computer Science

Tools

Microsoft Excel

Microsoft Access

SharePoint

SXe (business system)

Job description

Job Details: Job Location: Madison Heights, MI - 1357 E. Lincoln Ave - Madison Heights, MI 48071, Position Type: Full Time, Title: Advanced Pricing Specialist
Department: McRey Shared Services – Business Process Management

General Summary:

Uses Microsoft Excel, Access, and the business system to analyze, create, and maintain a high volume of customer sell pricing and vendor contracts at local, regional, and corporate levels. Drives process improvement by developing tools and procedures. Designs pricing strategies and infrastructures based on vendor and customer requirements.

Key Responsibilities:

• Analyzes vendor special pricing agreements (SPAs) and sales requests for special sell pricing, and determines the most accurate and efficient process for loading them into the business system.
• Analyzes the cost change impact of renewed SPAs and works with account managers and vendors.
• Works with the sales team on setting up new customer pricing matrices.
• Works with vendors and sales personnel on upcoming SPAs that are up for renewal.
• Works with vendors on hierarchy and part number changes that affect SPA contracts.
• Identifies and resolves pricing and rebate inconsistencies associated with multiple types of pricing records.
• Identifies and updates customer sell records that are affected by part number supersedes.
• Develops, reviews, and updates departmental procedures and instructions.
• Develops and implements pricing strategies and infrastructures.
• Develops tools in Microsoft Excel and Access databases to increase department efficiency.
• Participates in business system (SXe) update testing, which requires evening and weekend work.
• Provides training for new Pricing Analysts on proper pricing and costing techniques, department policy, and procedures.
• Supports the Quality initiatives of the Region, follows all safety policies and procedures, and completes the provided training.

Knowledge/Skills/Abilities:

• Bachelor’s degree in Business, Finance, or Computer Science required, with at least five years of job-related experience in business administration, accounting, finance, pricing, or data analytics. Eight to ten years of experience will be considered in lieu of a degree.
• Demonstrated advanced relational database skills, including writing queries and performing joins on tables with tools such as Microsoft Access or Excel. Intermediate ability with complex formulas, lookup tables, pivot tables, and macros in Microsoft Excel. Experience with SharePoint is beneficial.
• Strong analytical, problem-solving, organizational, and mathematical skills, along with sound decision‑making, critical thinking, professional communication, and excellent customer service skills.
• Demonstrated overall knowledge of business processes and how they interrelate with a business system; advanced understanding of business system pricing logic.
• Ability to multitask and handle a large volume of detailed work with accuracy.
• Ability to effectively balance priorities against work demands in both daily schedules and crisis situations.
• Ability to work with minimal supervision, organizing, prioritizing, and completing tasks on own initiative.

Reporting Relationships:

• Reports to: Director, Pricing & Rebates
• Direct reports: None

Working Conditions:

Normal office environment; occasional evenings and weekends.

EEO/AA/M/F/Vet/Disability Employer