Stiiizy Data Analyst interview questions & guide 2026

The following questions are representative of the patterns observed in the Stiiizy interview process. While specific inquiries may shift based on the immediate needs of the hiring team, you should prepare to demonstrate both technical fluency and the ability to apply data to business context.

Technical and Analytical Proficiency

These questions assess your core competency in data manipulation, query writing, and your ability to use tools to extract actionable insights.

• How would you approach automating a manual reporting process in Excel or Google Sheets?
• Explain your process for writing a SQL query to join data from disparate retail and distribution tables.

Success at Stiiizy requires more than just technical skill; it requires a proactive mindset. You should be prepared to discuss your past projects in terms of the business problems they solved, rather than just the tools you used.

Technical Competency – You must demonstrate advanced mastery of Excel/Google Sheets, SQL, and at least one BI tool. Expect interviewers to probe your ability to handle large data sets and write efficient, readable queries.

Analytical Rigor – Interviewers look for candidates who don't just "report" data but "interpret" it. You should be ready to talk about how you validate your assumptions and how you handle ambiguity when data is missing or imperfect.

Communication and Stakeholder Management – You will be working with diverse departments like Retail and Manufacturing. Your ability to translate "data speak" into "business strategy" is a primary evaluation point.

The interview process at Stiiizy is designed to gauge both your technical foundation and your cultural alignment with a fast-paced, high-growth environment. You can expect a structured progression that begins with a screening call to verify your experience, followed by technical assessments, and culminating in interviews with department leads. The pace is generally brisk, reflecting the operational tempo of the company.

This timeline illustrates the progression from initial screening to final decision. Use this to pace your study of SQL and Excel functions, ensuring you are "interview-ready" before your first deep-dive technical round. Note that variations in scheduling may occur based on the specific department (e.g., Retail vs. Technology) you are supporting.

Data Manipulation and Automation

This area evaluates your efficiency. Stiiizy values analysts who can move beyond basic reporting to create scalable, automated solutions.

Be ready to go over:

• Advanced Excel functions (Pivot Tables, VLOOKUP, INDEX/MATCH, Power Query).
• SQL optimization (joins, subqueries, and window functions).

As a Data Analyst at Stiiizy, your daily workflow will be focused on the full lifecycle of data. You will spend significant time aggregating data from primary and secondary sources, ensuring that the information flowing into your pipelines is accurate and clean. You will act as a consultant for departments like Distribution and Sales, providing them with the clear, data-driven reports they need to reach their targets.

A major component of the role is process improvement. You will be expected to locate inefficiencies in current workflows and suggest or implement automated solutions. This is not a siloed position; you will be expected to collaborate across the entire organization, navigating the facilities to understand the physical processes (like manufacturing or retail stocking) that your data represents.

A competitive candidate for the Data Analyst position at Stiiizy will demonstrate a strong blend of technical expertise and a "get it done" attitude.

• Must-have skills:
• Advanced proficiency in MS Excel/Google Sheets (including automation and complex formulas).
• Strong command of SQL for data extraction and manipulation.
• Experience building and maintaining dashboards in tools like PowerBI, Tableau, or Quicksight.
• Excellent written and verbal communication skills.
• Nice-to-have skills:
• Experience with Azure Databricks and Spark.
• Knowledge of statistical forecasting methods.
• Prior experience in the cannabis or retail/procurement sectors.

Q: How long does the hiring process typically take? The timeline can vary, but most candidates move through the stages within a few weeks. We prioritize candidates who are responsive and ready to engage with the team.

Q: Is there a coding test? Expect technical assessments that involve writing SQL queries or demonstrating proficiency in Excel. You should be prepared to solve problems in real-time.

Q: What is the work culture like for the Data & Analytics department? We are a fast-paced, high-energy environment. We value punctuality, diligence, and a "ready to work" mindset. You will be expected to support organizational priorities, which may occasionally include weekend or holiday coverage.

Q: How much interaction will I have with leadership? High. Because your analysis drives business decisions, you will frequently present your findings to project teams and senior leadership.

• Understand the Business: Before your interview, research the Stiiizy supply chain. Understanding how we go from "cultivation to retail" will help you frame your answers in the right context.
• Show, Don't Just Tell: If you have a portfolio or examples of dashboards you have built (ensuring no proprietary data is shared), bring them. Visual evidence of your work is highly persuasive.
• Be Ready for Ambiguity: In the cannabis industry, processes evolve quickly. When answering questions, show that you can handle "messy" data and still find a way to provide value.
• Focus on Automation: Whenever you discuss a past project, emphasize how you made it repeatable. Stiiizy values efficiency; show that you look for ways to save time for yourself and the team.

The Data Analyst role at Stiiizy is an exceptional opportunity to influence a market leader in a rapidly evolving industry. By mastering the core technical requirements—specifically SQL, Excel, and visualization tools—and pairing them with a proactive, business-first mindset, you position yourself as a candidate who can hit the ground running.

Use the insights provided in this guide to structure your preparation. Focus on articulating your past experiences in a way that highlights your ability to turn complex data into clear, actionable business strategies. We encourage you to continue exploring additional resources on Dataford to refine your approach. You have the potential to make a significant impact here—prepare with focus, and good luck.

The salary data provided reflects the compensation range for this position. Interpret these figures as a starting point for your total rewards package, which includes benefits such as health insurance, 401k matching, and employee discounts on our products. Your specific offer will be determined by your level of experience, technical proficiency, and the results of your interview performance.