The range of responsibility 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 for the area of responsibility. Responsibilities include analyzing performance within the department, develop methodologies and functionalities to automate and streamline reporting tools and databases for the Product/Planning team, and provide training to incoming associates.MAJOR DUTIES & RESPONSIBILITIES
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.
Trouble shoot issues encountered by user group, 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 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 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
Track seasonal indices by classification for planning and comparison to factory forecasts.
Work hours: 8:30 - 5:00 Brand:
Shared Services - Other (Call Center)
Start date: IMMEDIATELY Length of assignment: 6 months
Location: (Remote/Onsite) Remote (initially - Mason)
Specific Skills Needed: Business Objects, Microsoft SQL, Microsoft Excel and understands the use of data sets and data cubes; database and data warehouse management
Years of Experience: 2 Nesco Resource and affiliates (Lehigh G.I.T Inc, and Callos Resource, LLC) is an equal employment opportunity employer and does not discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, disability, age, or veteran status, or any other legally protected characteristics with respect to employment opportunities.
- Acceptance Testing
- Business Process Models
- Business Requirements
- Critical Thinking
- Data Analysis