Product Pricing Specialist

The Product Pricing Specialist is responsible for analyzing, maintaining, and updating product pricing and related catalog data across multiple internal systems and sales platforms. This is a data-intensive, operational role requiring strong Microsoft Excel proficiency, analytical thinking, exceptional attention to detail, and the ability to work independently with large volumes of product information.

Primary responsibilities include processing manufacturer and distributor pricing files, analyzing cost and selling price changes, identifying and resolving pricing discrepancies, monitoring competitive pricing, maintaining compliance with manufacturer MAP policies, and identifying new and discontinued products.

The ideal candidate has hands-on experience in pricing operations, purchasing, inventory analysis, or product data management. This position requires someone comfortable working extensively with spreadsheets, reconciling information from multiple sources, and ensuring pricing accuracy across large product catalogs.

This is an analytical and data management position, not a marketing or campaign management role.

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.