Category Analyst

As a Category Analyst, you will play a vital role in providing
valuable insights to drive business growth and enhance decision-making processes.
You will be responsible for analyzing sales data and trends, generating reports, and
creating presentations to support various departments and key stakeholders. The ideal
candidate will possess strong analytical skills, a keen eye for detail, and proficiency in
utilizing syndicated data (i.e., Circana) and SAP.

Job Description:

• Utilizing syndicated data and SAP to extract and manipulate data for analysis.
• Generating weekly, monthly, and quarterly sales reports to monitor business performance.
• Preparing comprehensive reports on sales performance, market trends, and competitor analysis.
• Analyzing sales data and identifying trends, patterns, and opportunities for improvement.
• Collaborating with cross-functional teams to gather relevant data and insights for decision-making purposes.
• Creating visually appealing presentations to effectively communicate analytical findings to management and other stakeholders.
• Developing and maintaining manufacturer scorecards to evaluate and assess vendor performance.
• Providing recommendations and actionable insights based on data analysis to drive sales growth and optimize business strategies.
• Conducting SKU optimizations by department and category to maximize shelf space efficiency and product velocities.
• Generating syndicated data reports via Circana to identify trends and generate merchandising alerts.
• Creating and distributing weekly sales trends graphs based on Client's major categories and brands.
• Creating demographic profiles of new client stores based on U.S. Census data.
• Tracking and scoring the progress of clien Elite Vendor Shelf Set and SKU Op Program.
• Producing client store Ccmpliance reports on a bi-weekly basis to monitor store purchase behavior.
• Conducting ad-hoc data analysis to support various departments, such as merchandising, marketing, finance, and operations.
• Handling ad-hoc data and insights requests from senior management, store owners, and internal cross-functional partners.
• Leveraging internal sales data and external resources to increase store revenue, such as consumer decision trees.
• Working towards automation of the planning process by utilizing data from various ERP platforms.
• Assisting merchandising and buying teams in leveraging available insights to drive increased vendor/brand trade spending and positively impact same-store sales and margin.
• Becoming proficient in using in-house tools such as SAP, and Circana to enhance store membership focus, including store-level analytics, data updates, ad-hoc requests, and warehouse-to-store shipment information

Qualifications:

EDUCATION

• Bachelor's degree in business, Statistics, Economics, or a related field.

SKILLS & EXPERIENCE

• Proven experience in data analysis and reporting within the retail or consumer goods industry.
• Proficiency in utilizing proprietary tools for brand planning, vendor planning, and general business review sessions.
• Strong analytical skills with the ability to conduct SKU optimizations and generate trend reports.
• Familiarity with syndicated data platforms, such as Circana, for trend identification and merchandising insights.
• Proficiency in creating graphical representations of sales trends and demographic profiles.
• Excellent communication and collaboration skills to work effectively with cross-functional teams.
• Strong problem-solving abilities and the ability to generate actionable insights from data analysis.
• Excellent communication/presentation skills
• Excellent Excel and PowerPoint skills