Supply Chain Statistical Analyst

Garrett Advancing Motion•Plymouth, MI

About The Position

As Supply Chain Statistical Analyst, you will be responsible and accountable for the design, development, and reporting of all supply chain measures enabling timely decision-making. You will drive operational excellence and provide a robust and fact-based 30-month rolling forecast. You will coordinate cross-functional research activities, reconcile significant variances for their reduction, and work on mitigation actions deployment and execution. You will ensure that weekly and monthly forecast submission deadlines and allied reports are respected. You will lead and drive product life cycle activities to ensure zero obsolescence.

Requirements

Post Graduate & / Bachelor’s degree on Business Administration, Engineering or related areas required
Minimum 10+ years of relevant experience in demand planning or customer service, sales and supply chain
English proficiency level
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
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
Work accurate and follow the weekly MOS
Team player

Nice To Haves

Spanish, Portuguese proficiency added advantage
Previous experience in the automotive industry preferred (OEM, Tier-I)
Six Sigma Green Belt Certification / equivalent certification

Responsibilities

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
Weekly check MAPE and BIAS at PN level
Discuss and align assumptions with CM at required & meaningful level
Follow defined standards and guidelines. Propose and implement improvements
Check and address with improvement top offenders
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