Pricing Specialist
Required skills
- P21
- Epicor Prophet 21
- Pricing Modules
- Excel
- VLOOKUP
- XLOOKUP
- Pivot Tables
- Text Formulas
- Data Manipulation
- SQL
Nice to have
- ERP Systems
- High Volume Pricing Modules
- Data Structures
- Seamless Invoicing
- Sales Operations
- Job Contracts
Role summary
We are looking for a detail-oriented and tech-savvy Pricing Specialist with experience in ERP systems, particularly Epicor Prophet 21 (P21), and its high-volume pricing modules. The role involves maintaining P21 price libraries, job contracts, and customer pricing matrices, preparing and executing bulk data uploads using Excel and P21 tools, and auditing system data for errors and exceptions. This position requires strong Excel proficiency, mathematical acumen for pricing calculations, and the ability to resolve invoice discrepancies by collaborating with AR, Sales, and Customer Service teams. A background in data entry or pricing administration within wholesale distribution is preferred.
Description
Job Summary
We are seeking a detail oriented and tech savvy Pricing Specialist with experience working with ERP systems (Epicor Prophet 21 (P21) preferred) including high volume pricing modules and data structures. The ideal candidate thrives on data integrity, masters Excel, and understands how to navigate P21’s unique pricing libraries, matrices, and customer structures to ensure seamless invoicing and sales operations.
Key Responsibilities
- P21 Price Maintenance: Maintain, update, and audit P21 Price Libraries and Job Contracts including Customer Pricing Matrices and Vendor Cost Contracts subject to expiration timelines
- Bulk Data Management: Use Excel and P21 import tools to prepare, format, and execute pricing data uploads
- System Auditing & Cleanup: Run routine P21 variance reports or SQL-based queries to detect and correct data entry errors, expired contracts, missing costs, or negative margin exceptions.
- Discrepancy Resolution: Collaborate with Accounts Receivable, Sales, and Customer Service teams to investigate and resolve P21-generated invoice pricing discrepancies and order entry blockages.
- Unit of Measure Accuracy: Ensure baseline vendor cost changes are correctly tied to P21 unit of measure (UOM) conversions (e.g., pricing per piece vs. box vs. pallet).
Qualifications & Skills
- Preferred P21 Experience: 2+ years of hands-on experience navigating Epicor Prophet 21 (P21), specifically within the inventory, purchasing, and pricing modules
- Advanced Excel Skills: Must be highly proficient with functions necessary for large-scale data manipulation, including VLOOKUP/XLOOKUP, pivot tables, and text formulas (Concatenate, Text to Columns, etc.) to prepare files for P21 import.
- Background: Prior experience in data entry, data management, or pricing administration within a wholesale distribution or industrial supply environment.
- Mathematical Acumen: Comfortable working with percentages, gross margins, markups, and complex, multi-tiered wholesale discount structures.
- Speed & Precision: High alphanumeric data entry speed paired with an uncompromising eye for detail
· Highly organized and able to manage multiple priorities with minimal supervision
Similar roles
- Service Center TechnicianAcorn Distributors · Columbus, OH · Onsite
- Pricing Specialist (Bilingual English/Korean)FNS, Inc. · Ridgefield Park, NJ · Onsite
Pricing SpecialistMettler-Toledo International, Inc · Columbus, OH · Onsite- Pricing Specialist FTFresco y Mas · Hialeah, FL · Onsite
Pricing SpecialistHewlett Packard Enterprise · Berkeley Heights, NJ · Hybrid- Pricing Specialist - Consignment StoreStuff Etc · Cedar Rapids, IA · Onsite
