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 Schwazze provides consulting services for cannabis growing technologies and methodologies. It was founded in 2012, and is headquartered in Denver, Colorado, USA, with a workforce of 501-1000 employees. Its website is