# Inventory Optimization Analyst

**Company**: Ford Motor Company
**Location**: Hermosillo, SON
**Work arrangement**: hybrid
**Experience**: senior
**Job type**: full-time
**Category**: Logistics & Supply Chain
**Industry**: Automotive
**Wikidata**: https://www.wikidata.org/wiki/Q44294

**Apply**: https://efds.fa.em5.oraclecloud.com/hcmUI/CandidateExperience/en/sites/CX_1/job/72890?utm_source=yubhub.co&utm_medium=jobs_feed&utm_campaign=apply
**Canonical**: https://yubhub.co/jobs/job_52fb63d6-490

## Description

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

## Responsibilities

- 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 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 data-driven decision-making.

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

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

## 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).

## Skills

### Required
- MRP/ERP
- Supply Chain Planning
- Microsoft Office
- Communication
- Problem-solving
- English

### Nice to have
- Data Analytics
- Data Visualization
- Python
- Power BI
- QlikSense
- SQL
- Lean DNA
- Blue Yonder
- ML/AI

---

Source: [Apply at efds.fa.em5.oraclecloud.com](https://efds.fa.em5.oraclecloud.com/hcmUI/CandidateExperience/en/sites/CX_1/job/72890?utm_source=yubhub.co&utm_medium=jobs_feed&utm_campaign=apply)