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.

Primary Duties and Responsibilities: 

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

QUALIFICATIONS:

• 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.
• Equal Opportunity Employer