Inventory Control & Shipping Clerk – Data & Reporting

Colonial Group; Seguin (TX); Hybrid; USD 32,000 - 45,000; Full time

Benefits offered by this job

Job summary

Colonial Group is seeking a Shipping/Receiving Clerk B in Texas to maintain accurate inventory records and monitor material movements across facilities. You will investigate discrepancies, reconcile variances, and manage data in AS400, IBS, and Excel to support production and purchasing.

You will generate monthly and quarterly reports, assist with receiving and cycle counts, and collaborate with multiple departments to improve inventory accuracy and safety compliance in a fast-paced

Qualifications

• High school diploma or equivalent.
• Associate degree in Business Administration, Supply Chain Management, Logistics, Accounting, or related field preferred.
• Experience with inventory reconciliation, cycle counting, physical inventories, and variance analysis.
• Experience working with purchasing, shipping, receiving, and production departments preferred.
• Experience supporting month-end closing activities and operational reporting is preferred.
• Proficient in Microsoft Excel, including formulas, pivot tables, data analysis, and reporting.
• Experience with AS400, IBS, ERP systems, or other inventory management software.
• Strong data entry and database management skills with a high degree of accuracy.
• Ability to generate, maintain, and analyze inventory and operational reports.
• Familiarity with inventory control processes, material transactions, and inventory tracking systems.
• Strong analytical and problem-solving skills with the ability to investigate and resolve inventory discrepancies.
• Excellent attention to detail and accuracy when handling inventory records and reports.
• Ability to prioritize multiple tasks and meet deadlines in a fast-paced manufacturing environment.
• Strong organizational skills and ability to maintain accurate documentation.
• Effective verbal and written communication skills.
• Ability to work independently and collaboratively across multiple departments and facilities.
• Ability to make recommendations based on inventory analyses and variance investigations.
• Demonstrated ability to maintain confidentiality of inventory, operational, and financial information
• Ensure consistent, dependable attendance and demonstrate a willingness to accommodate non-standard work hours as necessary
• Capable of effectively managing job-related stress and fostering productive workplace interaction

Responsibilities

• Review and investigate all discrepancies and report as necessary.
• Track inventory and request purchase of consumable materials.
• Verify& receive packaging material into AS400 database.
• Assist with discrepancy reports and disposition packaging.
• Verify pallet labels and count on shipment paperwork.
• Inventory cycle counts, manual counts, and physical counts and record the data.
• Provide support for operational daily, weekly, and monthly reporting.
• Verify inventory for production planning purposes as needed.
• Assist and enter monthly inventories in AS400.
• Perform month end close process. Review downtime and verify that all production is entered correctly in the month.
• Assist and or coordinate monthly inventories, reconcile variances and write recommendation reports to post.
• Coordinate cycle counts in multiple plants and assists in reconciliation.
• Work closely with material handlers to monitor inventory transactions.
• Work closely with shipping and receiving to monitor and reconcile inventory issues
• Report creation and inventory monitoring for item transactions
• Perform special projects as assigned
• Perform other tasks as assigned by management
• SOC Reports
• IBS Monthly Reports
• Assist Purchasing Officer with vendor lead times and all other process with purchasing and receiving
• Improve Inventory Accuracy and Minimize Discrepancies
• Drive the safety culture as a team
• Receive in inventory daily in AS400
• Track inventory and request purchases of materials.
• Gather, organize and enter data into Excel, IBS and AS400 for reporting, and quarterly corporate and customer reviews.
• Create and update Inventory spreadsheets detailing latest information regarding product and quality.

Skills

Excel

AS400

Inventory reconciliation

Cycle counting

Data entry

Variance analysis

Attention to detail

Cross-functional

Communication skills

Multi-department collaboration

Education

Associate degree in Business

High school diploma

Tools

AS400

IBS

Excel

Job description

Colonial Group is seeking a Shipping/Receiving Clerk B in Texas to maintain accurate inventory records and monitor material movements across facilities. You will investigate discrepancies, reconcile variances, and manage data in AS400, IBS, and Excel to support production and purchasing.

You will generate monthly and quarterly reports, assist with receiving and cycle counts, and collaborate with multiple departments to improve inventory accuracy and safety compliance in a fast-paced