Inventory Optimization Analyst

Lincoln Motor Company; Hermosillo; On-site; MXN 350,000 - 550,000; Full time

Job summary

Lincoln Motor Company in Hermosillo, Sonora is seeking a skilled planner to optimize plant inventory, standardize planning parameters, and mitigate shortages. The role emphasizes data-driven decisions and collaboration with plants to smooth material flow.

You will use Lean DNA and BI dashboards to anticipate bottlenecks, lead PFEP activities, and drive continuous improvement through Kaizen and 8D problem solving. A technical degree and 3+ years in supply chain are required.

Qualifications

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

Responsibilities

• Analyze and monitor DOH/BOH and inventory turnover to meet targets.
• Identify slow-moving, excess, and obsolete stock; root-cause and action plans.
• Collaborate with Plants to move forward inventory optimization.
• Use analytics tools (Lean DNA, BI dashboards) to foresee shortages and bottlenecks.
• Work with Material Planners and Follow-up teams to act on data.
• Lead PFEP reviews: safety stock, min/max, order intervals, batch sizes.
• Apply Lean and FPS to reduce waste in material flow and track KPIs.
• Lead Kaizen and problem-solving (8D, 5-Why, Fishbone) for discrepancies.
• Champion digital inventory tools to enable data-driven decisions.
• Develop and publish KPI dashboards showing adherence and risk trends.

Skills

Inventory planning

MRP/ERP knowledge

Data analytics

English proficiency

Cross-functional collaboration

Problem-solving

Education

Bachelor's degree in Industrial engineering, Supply Chain Management, Logistics, Data analytics or related technical field

Tools

SAP

CMMS/SMART

DDL

Lean DNA

Power BI

Blue Yonder

ML/AI

SQL database querying

Python

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.