Supply Chain Business Analyst, IN AMXL Supply Chain

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

BASIC QUALIFICATIONS

- 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.

PREFERRED QUALIFICATIONS

- Experience working with Tableau

- Experience using very large datasets

- Experience demonstrating problem solving and root cause analysis