ERP Pricing & Data Analyst — Prophet 21 Expert

S.J. Smith; Davenport (IA); On-site; USD 60,000 - 85,000; Full time

Benefits offered by this job

Medical, dental, and vision insurance

401(k) with company match

Paid time off

Ongoing training and professional dev.

Job summary

S.J. Smith Company in Davenport, IA is seeking a Pricing Systems Administrator to manage, update, and optimize the ERP price matrices, customer contract pricing, item and gas costs. You will ensure pricing accuracy across sales channels while protecting gross margins.

The role requires P21 experience, strong Excel and SQL skills, and the ability to collaborate across departments to uphold pricing procedures and drive continuous improvement.

Qualifications

• Minimum 2–4 years of Epicor Prophet 21 experience in distribution or manufacturing.
• Deep understanding of P21 modules: Price Matrix, Order Entry, Inventory, Purchasing.
• Advanced Excel skills for data manipulation (lookups, index/match, pivot tables).
• Experience with SQL or P21 Reports is desirable.
• Strong analytical, data entry accuracy, and cross-department communication.

Responsibilities

• Manage, update, and optimize price matrices in the ERP system.
• Handle customer contract pricing, item and gas costs.
• Ensure pricing accuracy across sales channels and maintain gross margin targets.
• Troubleshoot configuration or vendor data import issues.

Skills

P21 experience

Excel advanced

Analytical thinking

Communication skills

Pricing data analysis

Cross-department collaboration

Negotiation skills

Attention to detail

Education

High school diploma or equivalent

Tools

Epicor Prophet 21 (P21)

SQL

P21 Reports

Job description

S.J. Smith Company in Davenport, IA is seeking a Pricing Systems Administrator to manage, update, and optimize the ERP price matrices, customer contract pricing, item and gas costs. You will ensure pricing accuracy across sales channels while protecting gross margins.

The role requires P21 experience, strong Excel and SQL skills, and the ability to collaborate across departments to uphold pricing procedures and drive continuous improvement.