• The range of responsibilities is based on the experience level of the associate.
• The Data Analyst acts as the main information and reporting resource and systems expert for the Product/Planning team.
• Demonstrates leadership in critical thinking skills and challenges the department to analyze the business in new ways and continually drive results.
• Viewed as an expert in the area of responsibility.
• Responsibilities include analyzing performance within the department, developing methodologies and functionalities to automate and streamline reporting tools and databases for the Product/Planning team, and providing training to incoming associates.

• Systems Administration.
• Represent the Product Group to evaluate data requirements and work with IT on the development of systems, file structures, and data elements (i.e., SGH data warehouse, Marketmax priming data, and JDA attributes).
• Act as a 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 group, monitor and communicate to IT/Supply Ops. Document all newly developed processes and automation tools for Product Group.
• Become a 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 practices to obtain information and develop a format to provide the information to management.
• Assist team with the 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 end-user.
• Prepare regular (weekly/monthly) reports utilizing the report-writing tools Business Objects, MS Query, and/or AS 400 queries, continually modifying to meet new business requirements.
• Data Analysis and Forecasting Provide the Planning Manager with historical sales and inventory information and make recommendations on product and inventory direction where necessary.
• Recap promotional activity and determine the impact on sales and recommend 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 departments/classifications. Evaluate inventory supply to support promotional events and communicate issues to marketing representatives/upper management.

• Working knowledge of Planning, Buying, and Merchandising principles.
• Proficient computer skills:

1. MS Ability/aptitude to learn/create complex spreadsheets using advanced formulas (V-lookups, IF statements; pivot tables; macros).
2. MS Word
3. Ability/aptitude to learn/create professional memos.