Pricing Systems Analyst

S J Smith Company; Davenport (IA); On-site; USD 65,000 - 95,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 ERP price matrices and contract pricing. You will ensure pricing accuracy across sales channels and help maintain gross margin targets.

The role requires 2–4 years with Epicor Prophet 21, strong Excel skills, and ability to collaborate across departments and suppliers. This full-time position offers ongoing training and professional development opportunities.

Qualifications

• 2–4 years of experience with Epicor Prophet 21 in a distribution or manufacturing environment.
• Deep understanding of P21 core modules: Price Matrix, Order Entry, Inventory Management, Purchasing.
• Advanced Excel skills (lookups, index/match, pivot tables); SQL or P21 Reports desirable.
• Strong analytical, mathematical aptitude and ability to analyze pricing and cost data.
• High level of accuracy in data entry and adherence to corporate pricing and approval procedures.
• Strong communication and negotiation abilities across departments and suppliers.

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.
• Collaborate with multiple departments, management levels, and suppliers.
• Adhere to corporate pricing and approval procedures.

Skills

Epicor Prophet 21 experience

P21 modules knowledge

Analytical thinking

Attention to detail

Communication and negotiation

Cross-department collaboration

Education

High school diploma or equivalent

Tools

Epicor Prophet 21 (P21)

SQL

Excel

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

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.