Supply Chain Statistical Analyst

Description Garrett; Plymouth (MI); On-site; USD 90,000 - 130,000; Full time

Job summary

Description Garrett is seeking a Supply Chain Statistical Analyst to design, develop and report measures enabling timely decision making. You will drive operational excellence and provide a robust 30 months rolling forecast while coordinating cross-functional research and reconciling variances for mitigation actions.

You will ensure weekly and monthly forecast deadlines are met and support lifecycle activities to prevent obsolescence.

Qualifications

• Post Graduate & / Bachelor’s degree in Business Administration, Engineering or related areas required.
• 10+ years of relevant experience in demand planning or customer service, sales and supply chain.
• Experience in automotive industry preferred (OEM, Tier-I) is a plus.

Responsibilities

• Design, develop and report supply chain measures to enable timely decision making.
• Drive operational excellence and provide a robust 30 months rolling forecast.
• Coordinate cross-functional research activities and reconcile significant variances for mitigation actions.

Skills

Statistics

Forecasting

Demand planning

Analytical skills

Power BI

Excel

SAP

O9

Presentation skills

Six Sigma Green Belt

English

Education

Post Graduate or Bachelor's degree in Business Administration or Engineering

Tools

o9

SAP

Power BI

PowerPoint

Excel

MS Office

Job description

As Supply Chain Statistical Analyst, you will be responsible and accountable for design, development and reporting of all supply chain measures enabling timely decision making.

You will drive operational excellence & provide a robust and fact-based 30 months rolling forecast.

You will coordinate cross-functional research activities and reconcile significant variances for its reduction and work on mitigation actions deployment and execution. You will ensure that the weekly & monthly forecast submission deadlines and allied reports are respected. You will lead and drive product life cycle activities ensure zero obsolescence.

Key Responsibilities

Demand Management

• Responsible for weekly update of arbitrated demand using specific tool (e.g. o9 - Demand Planning)
• Statistical Analyst & Reporting's through o9, PowerBi, PowerPoint presentations
• Analyze demand, ask questions, investigate, challenge demand forecast based on historical data, seasonality, market trends, external events, etc
• Manage and prepare statistical forecasts: gather, analyze and validate data
• Apply error analysis techniques to improve forecasting
• Check weekly demand vs sold capacity, demand variation vs tolerance and **escalate deviations**
• Take actions if incorrect EDI/demand (e.g. EDI/demand received for obsolete PNs)
• Work with Customer Desk Specialist and Sales Manager to validate EDI/Demand in case deviations are identified
• Analyze gap and seek convergence of short term / long term forecast
• Propose demand arbitrated volumes and validate them with Sales Team and Global Demand Planning
• Proactively monitor the demand and raise the flag in case of risks (demand variations)
• Use MAPE and BIAS for demand analysis and take actions to improve forecast accuracy

Demand Accuracy

• Weekly check MAPE and BIAS at PN level
• One Team: Discuss and align assumptions with CM at required & meaningful level
• Continuous Improvements: Follow defined standards and guidelines. Propose and implement improvements
• Check and address with improvement top offenders

Internal Alignment and Collaboration

• GEM deployment and its substance for business process excellence
• Drive annual SDP process and coordinate and lead key project through six sigma principles
• Collaborate with Supply Chain, Customer Desk Specials, Sales Team to align on demand forecast
• Ensure adherence to standard demand planning, PIPO, NPI process for meet assigned functional KPIs viz. MAPE, BIAS, Inventory, E&O, Premium Freight
• Actively participates in weekly demand planning, SIOP meetings with ensuring successful completion of assigned deliverables
• Lead, support & report statistical analysis on demand forecast and related KPIs
• Follow-up and adjust arbitrated demand in case change of references (dash change; phase in/phase out) to avoid excess and obsolete

Education / Qualifications

• Post Graduate & / Bachelor’s degree on Business Administration, Engineering or related areas required

Experience

• Minimum 10+ years of relevant experience in demand planning or customer service, sales and supply chain
• Previous experience in the automotive industry preferred (OEM, Tier-I)

Key Skills and Knowledge

Technical Skills

• English proficiency level; Spanish, Portuguese proficiency added advantage
• Proficiency in statistics, forecasting and forecasting methods with an understanding of their financial and operational impacts
• Strong analytical skills
• ERP tools viz o9, SAP skills required and other software related to demand planning preferred
• Experienced with MS Office (Excel advanced, PowerPoint, PowerBi etc.)
• Presentation and communication skills
• Preferred - Six Sigma Green Belt Certification / equivalent certification

Behaviors

• Customer focus – understand and follow customer specific requirements
• Analyze and challenge forecast data, investigate variations
• Spot risks of forecast deviations and communicate internally, share information, collaborate and validate findings
• Self-learning, seek for continuous improvement
• Well organized to manage multiple competing priorities in parallel