Job description
- Location: Carlsbad, CA- Onsite: 4-5 days a week
- Contract
Role Overview:
The Product Data & Reporting Analyst will be responsible for the overhaul of the Assortment Management Tools used. This position will help to evolve the current Merchandising tool set, creating more automation and expanding each tool to include seasonal financial data. The revisions needed to the current Assortment Management tool set will enable the team to transition into managing the assortment under a new Product Hierarchy and prepare the data for the eventual integration into PLM. This position will work closely with the core Merchandising team and partner with Planning and IT for support on data integration. The Product Data & Reporting Analyst should have a strong analytical skill set with an expertise in building and managing large Excel databases.
Responsibilities include but are not limited to:
- Upgrade functionality of Seasonal Line Plan
- Reformat Line Plan tool to include multi-channel views, enabling growth of International Channel
- Revise Roll Up Summary Tabs to include various time periods and additional attributes
- Integrate historical data and future GM% forecasting model
- Linking of multiple data sources to feed automation
- Transition the Assortment Database as active G-sheets into Excel databases
- Linking of multiple seasons to create automatic data feeds
- Create multi-user functionality
- Linking of multiple data sources to feed automation
- Creating appropriate governance of data and tool set
Educational/ Position Requirements:
- Bachelor’s degree preferred or equivalent combination of education and experience
- Advanced Excel computer skills required
- Previous experience with ERP and PLM software is preferred
- Experience gathering requirements and documenting business processes
- Aptitude for systems and systematic work
- Highly organized, able to multi-task
- Strong communication skills
Expired job