Inventory Analyst

Vertiv; Tijuana; On-site; MXN 360,000 - 600,000; Full time

Job summary

Vertiv in Mexico (Tijuana) seeks an Inventory Analyst to support the Materials and Inventory organization by delivering hands-on analysis, reporting, and data governance that improves supply chain performance. You will focus on visibility into DIO drivers, MRP parameter governance, and E&O reporting.

You will collaborate with Regional Materials, Purchasing, Planning, and Finance to ensure accurate data, identify shortages, and provide actionable dashboards for weekly and monthly reviews.

Qualifications

• Bachelor's degree or equivalent in Business, Supply Chain, Analytics, Finance, Engineering, or related field.
• 3+ years post-college analytics, supply chain, operations, or materials experience.
• Strong Excel skills (pivot tables, lookups, data structuring).
• Ability to analyze large, imperfect datasets.

Responsibilities

• Build new and repeatable inventory reports to create visibility into DIO drivers, fast-turning materials, shortages and stockouts, backlog/work order alignment, and delivery frequency.
• Pull, clean, and analyze large datasets to ensure data is usable and accurate despite imperfections.
• Prepare concise summaries and dashboards for weekly and monthly inventory reviews.
• Conduct first-pass analysis to validate trends or discrepancies before escalating to leadership.

Skills

Excel

Data analysis

Communication

Attention to detail

Education

Bachelor's degree in Business, Supply Chain, Analytics, Finance, Engineering, or related field

Tools

Power BI

Tableau

Smartsheet

Job description

Job Description
Inventory Analyst - Job Description Position Summary

The Inventory Analyst supports Vertiv's Materials and Inventory organization by providing hands-on analysis, reporting, and data governance that improves supply chain performance. The role focuses on the following core objectives: providing clear visibility into DIO drivers, managing MRP parameters related to inventory, improving our understanding of the connection between DIO performance and Promised Date Service Level (PDSL) OTD-P, and (3) strengthening Excess & Obsolete (E&O) reporting and alignment. The analyst partners with Regional Materials teams, Purchasing, Planning, and Finance to ensure accurate data, proactive shortage identification, and consistent, actionable reporting across sites.

Key Responsibilities Reporting, Data Preparation & Insights Development

• Build new and repeatable inventory reports to create visibility into DIO drivers, fast-turning materials, shortages and stockouts, backlog/work order alignment, and delivery frequency.
• Pull, clean, and analyze large datasets to ensure data is usable and accurate despite imperfections.
• Prepare concise summaries and dashboards for weekly and monthly inventory reviews.
• Conduct first-pass analysis to validate trends or discrepancies before escalating to leadership.

DIO Support & Visibility into DIO Drivers

• Analyze what drives DIO up or down each period, including slow movers, PO/WO misalignment, supplier performance, and demand variability.
• Build datasets that allow leadership to understand key DIO drivers.
• Track recurring patterns influencing DIO and document findings for cross-functional follow-up.
• Provide insights that help plant teams understand the impact of planning and purchasing on DIO performance.

MRP Parameter Governance & Optimization

• Review and analyze MRP planning parameters including safety stock, reorder points, fixed lead times, order modifiers, lot sizing, and sourcing attributes to identify opportunities for inventory optimization.
• Develop reporting that highlights parameter settings contributing to excess inventory, stockouts, shortages, or service level risk.
• Partner with Planning, Purchasing, and Materials teams to monitor parameter accuracy and recommend updates based on demand patterns, lead time performance, and inventory objectives.
• Support periodic parameter reviews to ensure planning settings remain aligned with current business conditions, supplier performance, and manufacturing requirements.
• Identify and elevate inconsistent or outdated MRP parameters across sites and drive standardization where appropriate.
• Analyze the impact of parameter changes on DIO, PDSL, inventory levels, and material availability, providing data-driven recommendations to leadership.
• Maintain governance processes and reporting to track parameter compliance, changes, and opportunities for continuous improvement.

PDSL Improvement & Shortage Prevention

• Develop reporting that identifies materials at risk of missing promised delivery dates.
• Monitor fast-turning materials to detect early signs of emerging shortages.

Excess & Obsolete (E&O) Reporting & Management

• Prepare and refresh E&O reports, consolidating plant and Finance data.
• Track plant-provided reasons and actions for E&O and identify inconsistencies.
• Support root-cause investigation for recurring E&O drivers.
• Create simple trackers and visuals to support leadership reviews.

Qualifications Required Qualifications

• Bachelor's degree in Business, Supply Chain, Analytics, Finance, Engineering, or related field.
• 3+ years of post-college experience in analytics, supply chain, operations, or materials.
• Strong Excel skills (pivot tables, lookups, data structuring).
• Ability to analyze large, imperfect datasets.
• Strong communication, organization, and follow-through.

Preferred Qualifications

• Experience with Power BI, Tableau, or Smartsheet.
• Exposure to manufacturing, materials planning, purchasing, or inventory management.
• Experience supporting inventory health metrics such as DIO or shortage analysis.

Competencies

• Detail-oriented with strong data validation discipline.
• Analytical and curious-asks 'why' behind trends.
• Comfortable working through ambiguity and incomplete data.
• Strong follow-through and accountability.
• Ability to partner effectively with plant and cross-functional teams.
• Fast learner with system and process adaptability.