Sr Supply Chain Decision Support Data Analyst

Summary

Develops statistical models to support ongoing replenishment programs. Includes US and Mexico, hub and feeder, DC, supply chain services and various business process re-engineering projects.

Responsibilities

• Determine the correct stocking levels for Supply Chain Services, USC, and other new initiatives.
• Assist other departments, particularly merchandising and finance, with inventory issues.
• Provide coaching and guidance for Supply Chain Decision Support Analysts and Supply Chain Analysts.
• Monitors existing replenishment systems and intervenes where necessary. Includes monitoring seasonal inventory programs, store replenishment system behavior and Hub and Feeder network results.
• Works with Replenishment Directors to plan and manage the inventory requirements for promotions.
• Assists in the decision of when to release the additional inventory.
• Analyze data to help define problems and identify possible solutions for any unusual issues that arise on an ad hoc basis.
• Provide suggestions for corrective actions when not achieving goals.
• Assists in the budgeting process. Develop and publish certain KPIs for Supply Chain, including inventory, turns, service level, and in-stock reports.
• Plans the seasonal inventory requirements.
• Develops models for transportation and other aspects of supply chain. Includes optimizing the delivery frequency to the stores and determining optimal replenishment source (DC, Hub, CDII, DSD).
• Train DSAs and other Supply Chain personnel to achieve stated objectives.
• Implements replenishment projects for US and Mexico stores and DCs. Includes Hub and Feeder networks and Mexico.
• Provide data and analysis to cross-functional teams (Beyond Flat, 4C).

Requirements

• 5+ years experience with Master's Degree or 7+ years experience with Bachelor's Degree Mathematics, statistics, computer science, MIS, engineering.
• Highly Proficient in Excel, SQL, SAS: Excel--Can write VBA macros. SQL--Can write advanced queries using outer joins, unions, and sub-queries. SAS--Understands advanced data steps and macro programming.
• Uses statistical functions, such as regression. Strong written and oral communications skills.
• Strong analytical and problem-solving abilities.
• Experience with applying statistical modeling to real-world problems and a thorough understanding of the Supply Chain Statistical analysis, financial analysis, programming and data modeling experience.
• Ability to identify problems, analyze alternative solutions, and develop implementation plans for the recommended solution.
• Ability to develop as a leader.