Pricing Systems Analyst

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

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

OFFICER Full-time Office Worker Davenport, IA, US 1 Attachments

2 days ago Requisition ID: 1263

About Us:The Company: S.J. Smith Company, is a third-generation family-owned company that has been in operation since 1950. At S.J. Smith, we help make our customers more successful through cutting-edge solutions and quality products.

We believe in investing in our people, supporting professional development, and maintaining a culture where employees are empowered to do their best work.

Position Summary: The Pricing Systems Administrator is responsible for managing, updating, and optimizing the ERP system's price matrices, customer contract pricing, item and gas costs. They ensure pricing accuracy across sales channels while maintaining gross margin targets and troubleshooting configuration or vendor data import issues.

Required Qualifications:

• High school diploma or equivalent
• System Experience: Minimum 2-4 years of experience using Epicor Prophet 21 (P21) in a distribution or manufacturing environment.
• ERP Competency: Deep understanding of P21 core modules, specifically Price Matrix, Order Entry, Inventory Management, and Purchasing.
• Technical Proficiency: Advanced Microsoft Excel skills (lookups, index/match, pivot tables) for data manipulation. Experience with SQL or P21 Reports is highly desirable.
• Analytical Skills: Strong critical thinking skills. Strong mathematical aptitude and ability to analyze large sets of pricing and cost data.
• Detail-Oriented: High level of accuracy in data entry and a strict adherence to corporate pricing and approval procedures.
• Communication: Strong communication, conflict resolution skills, and negotiation skills. Able to work with multiple departments, levels of management and suppliers.

Schedule: This is a full-time position typically scheduled 7:30am - 4:30pm Monday through Friday.

• Medical, dental, and vision insurance
• 401(k) with company match
• Paid time off
• Ongoing training and professional development

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, or national origin.