Master Data Associate

Assists the Master Data Team Lead with all related data functions within the Department by performing the following duties in appropriate ERP system. Duties listed below are required of the department and can be assigned to each Associate.

Essential Job Duties

Management of Master System Data Hierarchies – Route, Account Manager and Customer

Reconciles daily error reports on a daily basis

Pricing Data

• Responsible for all DSD pricing. Validates accuracy of all related DSD pricing.
• Responsible for all direct pricing. Validates accuracy of all related direct pricing.
• Responsible for POS Pricing.
• Maintenance of DSD item master and costing.
• Entry and maintenance of all promotional activity.
• Weekly correspondence with Account Managers and reconciliation of their pricing and promotion to limit deductions. Requires publication of Quarterly findings.

Customer Data

• Efficient set up and maintenance of the Customer Master files relating to customer attributes.
• Adheres to Snyder’s-Lance policies to ensure accuracy and completeness of customer master information.
• Review credit applications for completeness.
• Follow up on required documentation, including sales tax exemption certificates and W-9.
• Pull Dun and Bradstreet reports and analyze results for approval of customer set up per procedures. These reports are pulled daily and once per customer set up request.
• Run Experian reports on central bill distributors for approval of customer set up per procedures. These reports are pulled daily and once per customer set up request.
• Run references from credit application for new charge customer requests.
• Approve or decline credit applications based on above reports. Convey decision to requestor.
• Updates customer maintenance fields, as needed, in Oracle/JDE/ SAP ERP systems.
• Run daily reports to confirm all customer data was correctly added to the system.
• Add all rental properties to the customer master which includes in putting expiration date.

Route Data

• Works with Route re-engineering team to ensure completeness of customer master data.
• Run daily reports to confirm all route data was correctly added to the system.
• Assist in acquisitions and transitions by helping with the cleanup of company data that will be added to the external customer conversion program.
• Processes all route maintenance on a weekly basis. Validation of required documentation verified prior to set up or any ERP system changes
• Maintenance of accurate warehouse authorization lists assigned to DSD routes.
• Coordinates the flow of information between Sales Accounting Team leaders and Reps concerning all route maintenance.
• Weekly processing for the new IBO Program. Maintenance of inventory with vendor for new IBO program.
• Responsible for compiling and processing route re-engineering and communication to Sales Accounting Team Leader’s and reps.
• Ensures accurate period end reporting relating to key route attributes.
• Works with Corporate Counsel regarding Equity route sales and conversions to ensure compliance with requirements.
• Maintenance and settlement of Open routes financed by MAW.
• As of inventory reconciliation for DSD warehouses, In-Transit and CO routes.
• Audits warehouse transactions on a daily basis.
• POS – coordination with Bill and Hold locations and warehouses.
• POS- work closely with Business Development team on sourcing of POS.
• Audits POS transactions on a weekly basis.
• Maintenance of Warehouse Support Manual.

Supplier Data

• Ensures adherence to SOX Control #PUR4 – proper approval for Supplier Master record addition and/or changes to non-standard terms.

Scope of Responsibility
(Authority to act, number of employees supervised, sales volume $, projected budget $, level of decision making or impact of decisions made to the organization
)

Responsible for the approval, addition and accuracy/maintenance of all pricing related files, Download files to HHD for DSD, Supplier Master Records, Route Maintenance records for Snyder’s-Lance in two ERP systems – JDE/Oracle, until fully transitioned to Oracle.

Supervisory Responsibility
(List Title(s) of Jobs Supervised. An organization chart should be included with job description when submitted)

There are no supervisory responsibilities associated with this position.

Knowledge and Skill Requirements
(Knowledge, skills, and abilities normally required for competent performance in the job – writing skills, communication skills, analytical skills, attention to detail, license, specific technical skills, etc. List licenses or professional certifications required for the job.)

• Strong interpersonal, problem solving and conflict management skills
• Strong verbal and written communication skills
• Demonstrate a positive customer service orientation with both internal and external clients
• Detail oriented with a focus on quality and continuous improvement
• Self-motivated and have a desire to continually learn as they go
• Strong focus on data accuracy and ability to self-review their own work
• Managerial and organizational skills, as well as computer literacy and knowledge of word processing and spreadsheet applications

Education and Experience
(Minimum and preferred educational requirements, years of experience needed to successfully perform the job – High School or GED, High School plus specialized vocation or technical education, college degree)

A minimum of two-year college or technical school; or 6+ months related experience and/or training; or equivalent combination of education and experience.

Experience in any ERP systems ( Oracle is preferred ), is required.

Travel Required
(Indicate type of travel and % of time travel is required)

No travel required for this position.

Job
–
Finance

Primary Location
–
United States-Pennsylvania-Hanover

Organization
–
Distribution Company_Master Data(L92350)

Schedule
–
Full-time

EEO Disclosure
–
Snyder’s-Lance is an Equal Opportunity Employer