Inventory Control Analyst

Paycom; Flowood, Northern (MS, KY); Hybrid; USD 65,000 - 90,000; Full time

Job summary

Paycom is seeking an Inventory Control Analyst in Flowood, MS to oversee corporate-wide inventory control for OEM and allied parts. You will optimize stock levels, monitor cycle turns, and ensure inventory integrity across branch locations, partnering with Service and Sales teams.

Key responsibilities include data analysis, reporting, and vendor coordination, with heavy emphasis on Excel, SQL, and Power BI to drive actionable insights and process improvements.

Qualifications

• Bachelor's degree preferred in MIS, data analytics, statistics, logistics, or business administration.
• Expert level Excel required, including complex formulas, PivotTables, and VBA basics.
• Experience with inventory control measures, supply chain systems, or DBS/AS400 is a plus.
• Familiarity with SQL, database structures, and basic programming logic.
• Power BI or comparable analytics tools strongly desired.

Responsibilities

• Analyze, monitor, and optimize Caterpillar parts inventory to maximize availability for parts counter sales and service operations across branches.
• Maintain and generate inventory reports to identify trends and demand.
• Set and adjust inventory parameters; manage surplus, non-moving, and non-returnable items.

Skills

Excel advanced

Pivot Tables

VBA scripting

SQL literacy

Power BI

Data analytics

Cross-functional collaboration

Organization

Problem solving

Education

Bachelor's degree in MIS / data analytics / statistics / logistics / business administration

Tools

SQL

Power BI

Excel

AS/400 or DBS familiarity

Job description

# Inventory Control AnalystFlowood, MS 39232## OverviewPosition TypeFull TimeEducation Level2 Year Degree## DescriptionThe Inventory Control Analyst is responsible to provide corporate-wide oversight and administration of inventory control activities related to all OEM and allied parts, to ensure that appropriate stocking levels are consistently maintained, inventory cycle turns are optimized, and inventory integrity is maintained at all times.Essential Functions, Duties, and Responsibilities:* Analyze, monitor, and anticipate/requisition Caterpillar parts inventory to maximize availability for parts counter sales as well as service department repair operations occurring at all branch locations. Maintain and prepare a wide array of parts availability reports to remain current on trends that may influence inventory demand.* Establish/maintain inventory system parameters. Determine dispositions for surplus, non-moving and /or non-returnable inventory. Coordinate all bulk purchases and surplus returns. Add non-stock items to inventory according to established ordering policies. Monitor/oversee consigned inventory.* Assist the Technical Services department in determining parts inventory needs for new product introductions, major product recalls, and major service letter directives from Caterpillar. Provide parts inventory subject matter expertise support to branch personnel as needed.* Manage and maintain vendor relationships with the company’s logistics vendor utilized for intracompany parts shipping. Monitor OEM parts supplier performance (completeness, timeliness, accuracy, cost, and quality)* Lead in various administrative tasks, such as company-wide annual physical parts inventory facilitation, periodic surplus returns, vendor invoice processing, and Caterpillar metric reporting (both incoming and outgoing). Track ongoing completion progress and compile after-action review reporting as designated by senior management.* Perform basic data analysis and interpretation to develop business insights for the company’s product support operations.* Maintain positive working relationships and effective communication with all internal and external customers and Caterpillar personnel.## Qualifications* Bachelor’s degree from an accredited institution in a management information systems, data analytics, statistics, logistics, or business administration discipline preferred. Associate’s degree or equivalent with significant, relevant experience will be considered.* Expert level experience with Microsoft Office Excel required, to include quantifiable skill in working with complicated formulas, Pivot Tables, and basic VBA manipulation.* Experience with inventory control measures, supply chain, dealer management information systems (DBS), and/or legacy AS400 systems preferred, but not required.* Familiarity with reading/modifying SQL, database structure, and basic programming language logic comprehension, Power BI or comparable systems highly desired.* Ability to collaborate effectively with all levels of staff and management.* Refined interpersonal communication skills (e.g., written, verbal, analytical, negotiation and cross-departmental).* Ability to organize, multi-task, prioritize workload, and rapidly change focus and direction in a fast-paced, deadline-oriented environment.* Superior problem-solving skills, proactive mindset, and ability to work with an impeccable level of accuracy.