Job Description:

Pay Range 30.48hr - $34.48hr

Responsibilities:

Systems Administration.

Represent the Product Group to evaluate data requirements and work with IT on development of systems, file structures and data elements (i.e., SGH data warehouse, Marketmax priming data and JDA attributes).

Act as consultant on systems projects to maximize efficiencies and resources.

Participate in user acceptance testing of new systems or enhancements/modifications.

Troubleshoot issues encountered by user groups, monitor and communicate to IT/Supply Ops.

Document all newly developed processes and automation tools for Product Group.

Become system expert and transfer knowledge through formal training classes and informal 1-on-1 assistance. Ensure integrity of data structure, processes and related tools (i.e., Universal Product Codes or Multi-Sourced Items) and communicate details to other parties like counterparts in Italy.

Report Creation, Generation and Automation:

Play a key role in the startup of all projects requiring data analysis.

Identify best practice to obtain information and develop a format to provide the information to management.

Assist team with development of complex Excel spreadsheets, automation formulas, and custom formatting of reports.

Manipulate data (merging or importing/exporting) between databases to provide more useful information.

Streamline processes to minimize time and ensure the highest level of accuracy, including validation before delivery to the end-user.

Prepare regular (weekly/monthly) reports utilizing the report-writing tools Business Objects, MS Query and AS 400 query, continually modifying to meet new business requirements.

Data Analysis and Forecasting Provide Planning Manager with historical sales and inventory information and make recommendations on product and inventory direction where necessary.

Recap promotional activity and determine impact on sales and recommended adjustments to future forecasts for related items.

Evaluate performance at a style/SKU level and forecast sales/replenishments based on style cannibalization, stock position, and expansion plans within the assortment.

Translate analysis/findings into information to guide Planning or Product Managers on assortment decisions.

Supply upper management with analysis of key performance indicators within department/classifications.

Evaluate inventory supply to support promotional events and communicate issues to marketing representatives/upper management.

Knowledge and Skills:

Working knowledge of Planning, Buying and Merchandising principles.

Computer Skills:

MS Excel-ability/aptitude to learn/create complex spreadsheets using advanced formulas (V-lookups, IF statements; pivot tables; macros).

MS Word ability/aptitude to learn/create professional memos.

Education:

Undergrad, 2+ years of experience.

#J-18808-Ljbffr