Job Description
The Supply Chain Analyst will be a member of Supply Chain SnOP & Capacity Planning team. The main goal of this position is to optimize the data pipelines, create data workstreams/dashboards for evolving business markers and play a pivotal role in the long term capacity planning for the network - while baselining with global benchamarks/tools. This position will work with other team members in Supply Chain organization
This position will be responsible for:
- Coordinate with retail & other colleagues in SC to publish weekly S&OP report in order to ops making labor planning and operation decisions
- Participate weekly S&OP meeting with both retail and ops to coordinate all the related affairs as a bridge, such as holiday arrangement; FC moving; New FC launch
- Tracking forecast accuracy, analyzing variance reasons by taking the history, backlog, seasonality and business strategy into consideration and conducting continuous improvement
- Provide support on capacity management and OP plan and 3 yr topology planning
- Support complex ad-hoc supply chain analysis and project as requested
- Support management team in metrics execution
- regular removal business analysis support
- 3+ years of complex Excel VBA macros writing experience
- Bachelor's degree or equivalent
- Experience defining requirements and using data and metrics to draw business insights
- Experience with SQL or ETL
- Knowledge of Microsoft Excel at an advanced level, including: pivot tables, macros, index/match, vlookup, VBA, data links, etc.
- Knowledge of data visualization tools such as Quick Sight, Tableau, Power BI or other BI packages
- a. Ability to break-up business asks/goals into analytics problems and independently anchor solutions.
- b. Front-line queries/callouts from partners on data/topology.
- c. Collaborate with Business Analyst peers within Supply Chain and contribute in programs for the overall Org.
- Experience working with Tableau
- Experience using very large datasets
- Experience demonstrating problem solving and root cause analysis
