Advanced Pricing Specialist

Job Details: Job Location: Madison Heights, MI - 1357 E. Lincoln Ave

• Madison Heights, MI, Position Type: Full Time, Salary Range: Undisclosed, Title: Advanced Pricing Specialist Department: Mc. Rey 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 Qualifications: