Product Pricing Specialist

Description:

Essential Functions and Responsibilities:

Pricing Management and Analysis

• Process and analyze large manufacturers and distributor pricing files using Microsoft Excel.
• Compare pricing files against existing product records to identify cost changes, missing information, and discrepancies.
• Maintain accurate MSRP, MAP, dealer costs, selling prices, and promotional pricing.
• Analyze product costs, selling prices, and gross margins to identify potential pricing concerns.
• Conduct competitor pricing research and identify significant pricing differences.
• Monitor pricing for compliance with manufacturer MAP policies and internal requirements.
• Track pricing effective dates and complete updates within established deadlines.

Product Data Management

• Maintain accurate pricing and product information across internal systems, product catalogs, and eCommerce platforms.
• Identify new products, discontinued items, end-of-life products, and unavailable inventory.
• Match and reconcile manufacturer part numbers, SKUs, and product records across multiple data sources.
• Review manufacturer and distributor files to identify products requiring addition or updates to the master catalog.
• Perform and validate bulk product and pricing updates to maintain data accuracy and consistency.
• Investigate and resolve missing costs, incorrect pricing, outdated records, and product data inconsistencies.

Reporting and Process Improvement

• Prepare Excel reports to track pricing changes, discrepancies, competitive pricing, and product status updates.
• Identify opportunities to improve the efficiency and accuracy of recurring pricing processes.
• Maintain organized pricing records, source files, approvals, and effective dates.
• Communicate pricing and product data issues to purchasing, sales, and eCommerce teams.
• Coordinate with manufacturers and distributors to obtain updated pricing and product information.

Required Qualifications:

• Minimum 2 years of experience in pricing operations, purchasing, inventory analysis, product data management, or a related data-intensive role.
• Strong Microsoft Excel proficiency required, including:
• • XLOOKUP or VLOOKUP
  • Pivot tables
  • IF statements and common Excel formulas
  • Conditional formatting
  • Filtering, sorting, and data validation
  • Comparing and reconciling large datasets
• Experience working with large spreadsheets, structured product data, SKU records, or pricing files.
• Demonstrated ability to identify data discrepancies, investigate issues, and maintain a high level of accuracy.
• Understanding of product costs, selling prices, gross margins, or inventory data.
• Strong analytical, organizational, and problem-solving skills.
• Ability to independently manage multiple assignments and meet established deadlines.
• Strong communication skills and ability to work effectively with cross-functional teams.
• High school diploma or equivalent required.

Preferred Qualifications:

• Experience processing manufacturer or distributor price lists and cost updates.
• Knowledge of MSRP, MAP, dealer cost, and competitive pricing practices.
• Experience with ERP, PIM, inventory management, or eCommerce systems.
• Experience with Shopify, Plytix, or similar platforms.
• Familiarity with CSV files, bulk imports, and data validation processes.
• Experience with Excel Power Query or other data automation tools.
• Background in technology distribution, electronics, audiovisual equipment, or B2B product catalogs.

WHY YOU’LL LIKE WORKING HERE

• Medical benefits, including vision and dental
• Paid holidays and PTO
• Enjoyable and dynamic company culture
• Training and professional development opportunities

 

MORE ABOUT US

AVI-SPL is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, disability status, or membership in any other group protected by federal, state, or local law. AVI-SPL is an AA/Disabled/Veteran Protected Employer VEVRAA Federal Contractor.

 

AVI-SPL reserves the right to alter work hours and work location as necessary. Work hours may vary based on client requirements and may include travel to various locations in support of the account.