DATA ADMINISTRATOR

Thompson Pump & Manufacturing Company; Town of Florida (NY); On-site; USD 45,000 - 70,000; Full time

Job summary

Thompson Pump & Manufacturing Co., Inc. seeks an Inventory/Procurement Specialist to manage cycle counts, part numbers, pricing, and data integrity across ERP systems to support production and R&D needs.

You will collaborate with Engineering, Purchasing, and Production to keep pull kits current and maintain NAV database data. Responsibilities include establishing new part numbers, maintaining cross-reference tables, setting safety stock, processing pricing adjustments, and generating monthly

Qualifications

• High School Diploma or GED equivalent.
• Associate’s degree or equivalent from two-year college, tech/trade school; or 2–3 years related experience.
• Detail oriented and accurate.
• Computer literate, including word processing and spreadsheets (Microsoft Works preferred).
• 3–5 years as a top-level office administrator.
• General office practices and procedures.
• Knowledge of ISO procedures and documentation.

Responsibilities

• Coordinate with Engineering, Purchasing, and Production to keep pull kits 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 engineering changes to BOMs.
• Coordinate IT issues to ensure database reliability and performance.
• Create all Precision Pump orders and maintain data.
• Establish new part numbers in the database with Engineering.
• Maintain/cleanup cross-reference table.
• Enter HS codes and COO and maintain NAV database.
• Create item cards and maintain existing cards.
• Set and adjust safety stock and reorder multiples.
• Adjust unit pricing.
• Support inventory accuracy based on reports, cycle counts, and spot checks.
• Assign locations for new parts in the warehouse.
• General cleanup of part numbers and descriptions.
• Escalate supply issues to Inventory/Planning Supervisor and interact with Purchasing to ensure supply meets production needs.
• Provide back ordered/low stock updates to management weekly.
• Process monthly valuation reports.
• Support end-of-month counting of serial-numbered inventories.
• Assist Purchasing in keeping data accurate in the parts database.
• Audit Purchasing to ensure returns are shipped timely and accurately.

Skills

Detail oriented

Accuracy

Office procedures

ISO procedures

Top-level office administrator

Problem solving

Education

High School Diploma or GED

Associate degree or equivalent

Tools

Microsoft Works

Job description

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.


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


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