Merchandising Analyst

Schwazze is a purpose-driven cannabis operator focused on building a leading seed-to-sale company. The Merchandising Analyst will provide analytical and operational support to the Merchandising organization, ensuring data accuracy and producing actionable insights to enhance category performance.

Responsibilities

• Maintain and support the backend data infrastructure for merchandising and retail reporting, ensuring data integrity across systems, banners, and categories
• Support data migration, normalization, and validation efforts related to mergers, acquisitions, and system integrations
• Maintain and update master category and item files, including pricing, cost, margin targets, tiering, and inventory guidelines
• Ensure accuracy and consistency of data used in dashboards, reports, financial summaries, and category reviews
• Serve as a point of coordination for resolving data discrepancies between POS, inventory, finance, and merchandising systems
• Analyze sales, margin, inventory, and promotional performance across categories to identify trends, risks, and growth opportunities
• Build, maintain, and enhance recurring scorecards, dashboards, and KPIs including sell-through, inventory turns, aging, margin mix, and promotional ROI
• Support pricing analysis using competitive benchmarks, internal performance data, and market intelligence tools (e.g., BDSA or similar)
• Provide analytical support for assortment frameworks such as Good/Better/Best, tiered pricing, and category role definitions
• Deliver clear, concise insights to Category Managers and leadership to inform decisions and recommendations
• Partner closely with Category Managers to support SKU rationalization, category strategy execution, and new item launches
• Evaluate vendor performance, pricing changes, cost structures, and promotional activity using standardized scorecards and metrics
• Support vendor negotiations and line reviews by preparing data, analyses, and performance summaries
• Assist with assortment resets, category transitions, and promotional planning through analytical preparation and post-event analysis
• Support the standardization and continuous improvement of merchandising reporting, analytical tools, and workflows
• Assist in developing scalable reporting frameworks that support growth across multiple banners and markets
• Improve data visualization, automation, and reporting efficiency to reduce manual effort and increase insight velocity
• Contribute to best-practice merchandising analytics that enable consistency, transparency, and accountability
• Translates complex data into clear, actionable insights that executives can use to make strategic decisions
• Identifies key performance drivers and risks without being asked, proactively surfacing critical issues
• Presents findings with business context and recommended actions, not just data dumps
• Tailors communication style and level of detail to audience (executives need different insights than category managers)
• Assesses product performance at granular levels: SKU, banner, store, time period
• Identifies products that are dying (declining sales velocity, aging inventory, compressed margins)
• Analyzes contribution margin by product to understand true profitability, not just revenue
• Tracks product lifecycle patterns and signals when items need promotional support, repositioning, or discontinuation
• Compares performance across banners to identify execution gaps or assortment opportunities
• Calculates sales per square foot and dollars per linear foot to optimize space allocation
• Identifies low-productivity SKUs that are consuming valuable shelf space
• Recommends space reallocation based on category growth, margin contribution, and customer demand
• Analyzes adjacencies and cross-sell opportunities to inform merchandising placement strategies
• Supports planogram optimization with data on product velocity and basket attachment
• Identifies missing items in categories by comparing assortment to competitive benchmarks and market data
• Uses external benchmarking data (BDSA, competitor shopping) to quantify assortment gaps and opportunities
• Analyzes customer behavior and search patterns to identify unmet demand
• Recommends new item introductions based on market trends, competitive activity, and category strategy
• Quantifies the financial opportunity of closing assortment gaps (estimated incremental revenue and margin)
• Tracks category performance against market benchmarks to measure share capture and competitive positioning

Skills

• Foundational understanding of retail merchandising concepts including pricing, margin, assortment, promotions, and inventory management
• Familiarity with category management principles and how analytics support commercial decision-making
• Advanced proficiency in Excel, including pivot tables, formulas, lookups, and data modeling
• Strong ability to analyze large datasets and synthesize findings into clear, actionable insights
• Ability to communicate analytical findings clearly to non-technical partners
• Strong collaboration skills and comfort supporting multiple Category Managers and cross-functional stakeholders
• Ability to operate effectively in an evolving, acquisition-driven organization with comfort navigating ambiguity
• Experience analyzing sales, margin, inventory, and promotional data required
• Ability to obtain and maintain an active Marijuana Enforcement Division (MED) badge in the state of Colorado
• Experience working with BI or visualization tools such as Power BI or Tableau preferred
• Bachelor's degree in Business, Analytics, Finance, Retail, Supply Chain, or related field preferred
• 1-3 years of experience in merchandising analytics, retail analysis, business analysis, or a related support role
• Experience supporting growth, system changes, or M&A integrations is a plus

Benefits

• Medical/Dental/Vision Insurance
• Pet Insurance
• EAP Programs
• Paid Time Off
• Paid Parental Leave
• Employee Discount at all Schwazze Retail locations

Company Overview