Inventory Optimization Analyst

Ford, Inc; Chihuahua, Hermosillo; On-site; MXN 350,000 - 550,000; Full time

Job summary

Ford Mexico is seeking a skilled Inventory & Planning Specialist to optimize plant inventory levels and standardize planning parameters across systems. You will use PFEP, KPIs, and digital tools to prevent shortages and drive data-driven decisions.

The role collaborates with Plants and MP&L teams to eliminate waste, implement corrective actions, and enhance supply chain performance using Lean and advanced analytics.

Qualifications

• Bachelor's degree in a related field is required.
• 3+ years in supply chain, material planning, inventory control or logistics analysis.
• Knowledge of MRP/ERP logic and planning modules (SAP, CMMS/SMART, DDL).
• Strong command of Microsoft Office and data tools.

Responsibilities

• Analyze and monitor DOH/BOH, inventory turnover to meet targets.
• Identify slow-moving and obsolete stock; define corrective actions.
• Collaborate with plants to optimize inventory and risk mitigation.
• Use Lean DNA, BI dashboards to spot shortages before line disruptions.
• Lead PFEP reviews: safety stock, min/max, order intervals, batch sizes.
• Apply Lean and FPS to reduce waste in material flow and track KPIs.
• Drive Kaizen and 8D problem-solving for inventory issues.
• Promote digital inventory tools and data-driven decision making.
• Develop, automate and publish KPI dashboards on shortage risk trends.

Skills

Supply chain

Inventory planning

Data analytics

Excel & Office

Power BI

SQL

Python

Education

Bachelor's in Industrial engineering

Supply chain management

Logistics

Data analytics

Tools

SAP

CMMS/SMART

DDL

Job description

In this role, you will be responsible for optimizing plant inventory levels, standardizing parameters across planning systems, mitigating material shortage risks.

• Analyze and monitor Days of Inventory on Hand (DOH/BOH), inventory turnover to achieve corporate and plant targets.

• Identify slow-moving, non-productive, excess, and obsolete inventory identify root-cause, define and implement action plans.

• Support and partner with Plants to move forward with the activities to optimize inventory.

• Utilize advanced analytics platforms (e.g., Lean DNA, BI dashboards) to proactively identify critical shortages and bottleneck suppliers before line disruptions occur.

• Collaborate with Material Planners, Follow-up teams to take actions based on data.

• Lead continuous review and dynamic adjustment of the Plan for Every Part (PFEP), including safety stock levels, minimum/maximum parameters, order intervals, and batch lot sizes.

• Apply Lean and FPS principles to eliminate waste in material flow and inventory, tracking KPI’s in our control centers.

• Participate in and lead Kaizen and structured problem-solving initiatives (8D, 5-Why, Fishbone) to address inventory discrepancies, record accuracy issues, defining, implementing, and following up on corrective action plans.

• Champion the adoption of digital inventory tools across the MP&L organization to foster in data-driven decision-making.

• Develop, automate, and publish standard visual management reports (KPI dashboards) tracking parameter adherence and shortage risk trends.

• Bachelor’s degree in Industrial engineering, Supply Chain Management, Logistics, Data analytics or related technical field.
• 3+ years of experience in supply chain, material planning, inventory control, or logistics analysis.
• Knowledge of MRP/ERP logic and supply chain planning modules (SAP, CMMS/SMART, DDL, or equivalent).
• Advanced proficiency in Microsoft Office / Microsoft 365.
• Cross-functional collaboration and communication skills with a team-oriented mindset.
• Excellent structured problem-solving mindset.
• Strong verbal and written communication skills in English.

Preferred Qualifications:

• Advanced proficiency in data analytics and data visualization tools (Microsoft Excel: Power Query/Pivot Tables; Power BI, QlikSense, SQL database querying, Python).
• Advanced Digital Tools: Direct hands‑on experience with modern inventory optimization platforms and prescriptive supply chain software (e.g., Lean DNA, Blue Yonder, ML/AI).

#FordMexico
#LI-HC1