Pricing Systems Analyst

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

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

401(k) with company match

Paid time off

Ongoing training and professional dev.

Job summary

S.J. Smith Company seeks a Pricing Systems Administrator in Davenport, IA to manage ERP price matrices, contract pricing, item and gas costs. You will ensure pricing accuracy across channels and maintain gross margins while resolving data-import issues.

The role requires EPICOR Prophet 21 experience, advanced Excel, and strong analytical and communication skills. This is a full-time on-site position with ongoing training and development opportunities.

Qualifications

• Experience using Epicor Prophet 21 (P21) in distribution/manufacturing.
• Strong Excel skills (lookups, pivot tables) required.
• Ability to analyze pricing and costs data accurately.
• Adherence to pricing and approval procedures.

Responsibilities

• Manage, update, and optimize ERP price matrices and customer contract pricing.
• Ensure pricing accuracy across sales channels while maintaining gross margins.
• Troubleshoot configuration or vendor data import issues.

Skills

Analytical thinking

Detail orientation

Communication skills

Negotiation skills

Data interpretation

Education

High school diploma or equivalent

Tools

Epicor Prophet 21 (P21)

Microsoft Excel (advanced)

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

4 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.