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
Apply Now