Data Administrator

Summary: Support all inventory-related functions to support Thompson Pump & Manufacturing Co., Inc.’s production schedule, service and spare parts needs, R&D requirements, and maintenance of adequate and correct inventory levels., + Assist in coordinating with the Engineering, Purchasing, and Production Departments to ensure that all Production and R&D pull kits are accurate and up to date.

• Produce Cycle Counts for Warehouse Team based on Cycle Count Process

• Cycle count Bins Daily to ensure inventory Accuracy

• React to all engineering changes to BOM’s.

• Coordinate all computer issues with the IT Department to ensure the reliability and stability of the database and correct performance of all required operations.

• Create all Precision Pump orders and maintain data.

• Establish new part numbers in the database working with Engineering.

• Maintain/cleanup of the cross-reference table.

• Enter HS codes and COO and maintain NAV database.

• Update vendor changes, price changes, and new vendor item numbers.

• Create item cards and check/maintain cards that others have set.

• Set and adjust safety stock and re-order multiples.

• Adjust Unit pricing.

• Support accuracy of all inventory parts by adjusting based on various inventory reports, cycle counts, random spot checks, and other methods as determined by the ERP System.

• Responsible for assigning locations for new parts in the warehouse.

• General cleanup of part numbers and descriptions.

• Escalate supply issues to the Inventory/Planning Supervisor and interact with the Purchasing Team to ensure that adequate supply is taking place to meet production order requirements.

• Provide and escalate back ordered and low stock concerns to management on weekly basis.

• Process monthly valuation reports.

• Support end of month counting of all serial numbered inventories, as identified by the ERP system.

• Assist the Purchasing Department in maintaining the accuracy of the data in the parts database.

• Audit the Purchasing Department to ensure all parts needing to be returned to a vendor are shipped in a timely manner, correctly and accurately.

• Generate all documents required to ensure proper credit of all returned parts. Make adjustments to inventory as required to ensure returned parts are deleted correctly.

• Run current applicable reports and communicate discrepancies based on approved counts to the SIOP Manager

• Study sales numbers and forecasts to suggest future inventory needs with consideration to obsolete inventory.

• Responsible for following all safety regulations at all work areas and job sites.

• Maintain clean and neat workstation

• Research ways to improve and promote quality and efficiency. Generates or implements suggestions for improving processes.

• Problem Solving by identifying and resolving problems in a timely manner.

• High School Diploma or GED equivalent.

• Associate’s degree or equivalent from two-year College, technical school, trade school; or two-three years related experience and/or training; or equivalent combination of education and experience.

• Effective verbal communication

• Basic math, spelling & grammar skills

• Detail oriented and accuracy a must

• Computer literate, including use of word processing and spreadsheet programs, preferably Microsoft Works.

• Three to five years as a top-level office administrator

• General office practices and procedures

• Knowledge of ISO procedures and documentation.