Pricing Data Specialist — P21 & Excel Master

Paylocity; Brownsburg (IN); On-site; USD 60,000 - 90,000; Full time

Job summary

Paylocity in Brownsburg, IN seeks a detail oriented Pricing Specialist with ERP experience, preferably Epicor Prophet 21 (P21). The role focuses on maintaining pricing libraries, data integrity, and accurate invoicing to support sales operations.

The ideal candidate will master Excel, navigate P21 pricing structures, and collaborate with Accounts Receivable, Sales, and Customer Service to resolve pricing discrepancies while ensuring timely data updates.

Qualifications

• 2+ years of hands-on experience navigating Epicor Prophet 21 (P21), specifically within inventory, purchasing, and pricing modules.
• Advanced Excel skills including VLOOKUP/XLOOKUP, PivotTables, and text formulas for large data manipulation to prepare P21 imports.
• Background in data entry, data management, or pricing administration in wholesale distribution or industrial supply.
• Mathematical acumen with percentages, gross margins, markups, and multi-tiered discount structures.
• High alphanumeric data entry speed with strong attention to detail.

Responsibilities

• P21 Price Maintenance: Maintain and audit P21 price libraries and contracts, including customer pricing matrices and vendor cost contracts.
• Bulk Data Management: Use Excel and P21 import tools to prepare, format, and execute pricing data uploads.
• System Auditing & Cleanup: Run variance reports or SQL queries to detect and correct data issues, expired contracts, or negative margins.
• Discrepancy Resolution: Collaborate with AR, Sales, and Customer Service to resolve invoice pricing discrepancies and order blocks.
• Unit of Measure Accuracy: Ensure vendor cost changes align with P21 UOM conversions (per piece, box, pallet).

Skills

P21 pricing

Advanced Excel

Data integrity

Attention to detail

Fast data entry

Tools

Epicor Prophet 21

SQL

Job description

Paylocity in Brownsburg, IN seeks a detail oriented Pricing Specialist with ERP experience, preferably Epicor Prophet 21 (P21). The role focuses on maintaining pricing libraries, data integrity, and accurate invoicing to support sales operations.

The ideal candidate will master Excel, navigate P21 pricing structures, and collaborate with Accounts Receivable, Sales, and Customer Service to resolve pricing discrepancies while ensuring timely data updates.