Inventory Optimization Analyst

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

• 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
 

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