JOB PURPOSE or JOB SUMMARY:
The Commercial Data Administrator is responsible for maintaining the integrity of commercial master data within the ERP system to support accurate pricing, procurement, quoting, customer agreements, forecasting, and business reporting.
This position serves as the primary administrator for customer contract pricing, supplier cost records, purchasing and sales discount structures, Special Pricing Agreements (SPAs), and other commercial master data. Working closely with Sales, Customer Service, Purchasing, Product Management, Finance, and Operations, the Commercial Data Administrator ensures commercial information is accurate, timely, and compliant with established business policies.
In addition to master data administration, this position provides administrative support across Commercial Operations by assisting with pricing administration, customer forecast validation, transaction auditing, procurement support, and customer service support activities.
ESSENTIAL DUTIES and RESPONSIBILITIES:
Commercial Master Data Management
- Maintain customer contract pricing, sales discount schedules, supplier cost records, purchasing discount structures, and other commercial pricing records within the ERP system.
- Create, update, and maintain Special Pricing Agreements (SPAs), customer contracts, supplier pricing programs, and other commercial master data.
- Maintain the integrity of commercial master data, including customer, vendor, product, inventory, and ERP system records and parameters.
- Develop and execute a routine audit schedule to identify and correct data variances, discrepancies, and system errors.
Pricing Administration
- Coordinate pricing updates resulting from supplier cost changes, customer agreements, and commercial initiatives.
- Support the Sales team with contract pricing setup, maintenance, renewals, and implementation.
- Validate pricing changes prior to implementation and resolve pricing discrepancies.
- Maintain supporting documentation for customer pricing agreements, supplier pricing programs, and contract renewals.
Commercial Data Validation
- Review customer forecasts for completeness, accuracy, and data consistency prior to ERP updates.
- Audit sales and purchasing transactions to identify pricing inconsistencies, margin exceptions, cost errors, and other data discrepancies.
- Identify recurring data quality issues, recommend corrective actions, and validate system updates following ERP uploads and pricing changes.
Commercial Operations Support
- Provide administrative support to the Customer Service and Purchasing teams based on business priorities.
- Support customer pricing administration, contract maintenance, sales order accuracy, and procurement-related administrative activities.
- Assist with internal audits, documentation requests, reporting, and other commercial operations initiatives.
Cross-Functional Collaboration
- Partner with Sales to maintain customer pricing, commercial agreements, and forecast data.
- Collaborate with Purchasing on supplier pricing, purchasing discounts, and supplier programs.
- Work with Customer Service to ensure accurate pricing execution and contract compliance.
- Support Product Management with pricing initiatives and supplier program administration.
- Coordinate with Finance to resolve pricing discrepancies and support commercial reporting.
Continuous Improvement
- Develop and maintain standardized procedures for commercial master data management.
- Identify opportunities to improve pricing accuracy, data integrity, and process efficiency.
- Support ERP enhancements, pricing automation, and commercial process improvements.
- Develop and monitor KPIs related to pricing accuracy, master data integrity, and commercial performance.
COMPETENCIES:
- Commercial Master Data Management
- ERP Systems (Infor M3 preferred)
- Pricing Administration
- Data Accuracy & Attention to Detail
- Business Process Documentation
- Microsoft Excel (Advanced)
- Analytical Thinking
- Organization & Time Management
- Cross-Functional Collaboration
- Customer Service
- Problem Solving
- Continuous Improvement
PHYSICAL AND MENTAL DEMANDS:
- Frequently required to sit at a desk or
/workstation for long periods of time - Ability to work at a computer terminal for extended periods of time
The mental and physical requirements described here are representative of those that must be met by an individual to successfully perform the essential functions of this position, with or without reasonable accommodation.
WORKING ENVIRONMENT:
- Work hours average 40 per week with typical hours of operation being Monday through Friday 8am-5pm; may require additional hours, including evenings and weekends, depending on business needs.
- Work typically performed in an office environment, on-site.
- Work may be performed in a manufacturing/factory environment.
Tools and Equipment Used
- Personal computer, copier, fax/scanner, phone, and other typical office equipment
Travel
- Up to 15% of the time
The work environment characteristics described here are representative of those an individual may encounter while performing the essential functions of this position, with or without accommodation.
Required
- 2+ years of experience in purchasing, pricing administration, customer service, ERP administration, or related business operations.
- Experience working with ERP systems.
- Strong Excel skills, including data validation, lookups, and spreadsheet management.
- Excellent organizational skills with exceptional attention to detail.
Preferred
- Experience with Infor M3.
- Experience within industrial distribution, manufacturing, or engineered products.
- Experience with customer contract pricing, supplier pricing, or commercial master data administration.
- Knowledge of ERP master data governance and commercial pricing processes.