Merchandise Analyst

Company: Universal Screen Arts Inc
Location: Hudson
Posted on: September 20, 2023

Job Description:

Join the company that delivers Comfort & Joy through our unique gift offerings. You will be part of a winning team and participate in our Employee Stock Ownership Plan (ESOP) -- an added retirement benefit that is completely paid for by Universal Screen Arts. The ESOP shares the wealth with our dedicated employees and makes us a healthy stable employer. Located in historic Hudson, Ohio, Universal Screen Arts, Inc., a 100% employee-owned company, is a specialty catalog and online marketer that celebrates merchandising to a range of demographics with a variety of gift, self-purchase and needs-based product categories. Our story began over 38 years ago by offering Comfort and Joy through unique gifts shipped direct to the consumer and continues today with seven brands and more than 26 million customers served.We are looking for a talented Merchandising Analyst to join our team. The Merchandising Analyst will work with the merchant team to use various analytical skills and techniques to help drive improvements in online and catalog performance. The Merchandising Analyst gathers, interprets, analyzes, and organizes complex data to inform actionable steps to improve sales performance. This role uses data to help merchant teams assess strategic business opportunities for their brands. The Merchandising Analyst partners with inventory planners to understand key items to assure appropriate forecasts and inventory levels to support sales. The Merchandising Analyst should have a strong desire to work within a team to build improvements and efficiencies through systems and process updates, build cross-functional relationships, and a desire to analyze and summarize data in order to make a positive impact. Key Responsibilities: Perform query-based analysis using various analytical tools including SQL, Power Pivots, Power Query and Data Modeler. Develop reports and dashboards using analytical tools. Collaborate with merchandising teams to identify, design, and implement reporting tools to maximize sales, margin, and inventory performance. Work with the merchandising teams and use weekly data to provide analysis that will lead to improvements in process, decision-making and overall results. Develop reporting to identify trends and selling patterns and establish buy plans. Help to develop standardized analysis and reporting across merchandise teams.Provide comprehensive analysis of web sales and each catalog at established completion thresholds. Analysis includes, but is not limited to: category performance, price point analysis, gross margin, contribution, sales ranking reporting and segment performance. Assist in the Merchandising Budget process. Communicate with the Merchandising and Marketing teams to understand by Brand/Month/Category future sales and margin rates and gain insight into future circulation plans. Monitor the results compared to the annual goal and report weekly. Ad hoc queries including, but not limited to: cart/basket analysis, fatigue analysis, repurchase trend, as requested from the various merchant teams.Work with IT and the Business Intelligence Team to recommend/develop improvements to existing processes and/or systems. Work closely with the Purchasing Team to assure identify opportunities in item forecasting. BA/BS degree or equivalent in business, statistics, economics, finance, engineering. MS Access and database programming certification or equivalent is a plus.Marketing/Merchandising, Retail, and/or Direct Marketing experience is desirable. 5+ years relevant experience. Strong business analytical mindset. Strong computer skills in Excel, Access and PowerPoint. SQL knowledge a plus. Excellent mathematical skills. Good Communication and organization skills required. Proficiency with various BI tools such as Power BI, Data Modeler, SAS, SSRS, Tableau a plus. Basic financial analysis.PI32613948-25660-50f0d7d77f13

Keywords: Universal Screen Arts Inc, Cuyahoga Falls , Merchandise Analyst, Professions , Hudson, Ohio