Data Analyst, SQL & BI — Impactful Cannabis Analytics

DACUT; West Bloomfield Charter Township (MI); On-site; USD 70,000 - 110,000; Full time

Benefits offered by this job

Medical, dental, and vision insurance

Paid Time Off

Employee discount program

Career advancement opportunities

Collaborative work environment

Cross-functional exposure

Impact on executive decisions

Job summary

DACUT Cannabis is seeking a highly analytical Data Analyst with strong SQL and BI skills to support reporting, analytics, and operational visibility across retail, cultivation, processing, and corporate functions.

You will transform raw data into actionable insights, build dashboards in Power BI, and partner with cross-functional teams to drive performance and compliance. The role emphasizes data quality and executive storytelling.

Qualifications

• Minimum of 2 years of experience in Data Analysis, BI, or Analytics.
• Strong proficiency with SQL, including queries, joins, aggregations, and data transformation.
• Experience with Power BI, Tableau, or similar data visualization platforms.
• Experience working with large datasets and enterprise reporting systems.
• Strong analytical, critical thinking, and problem-solving skills.
• Excellent attention to detail and commitment to data accuracy.
• Ability to clearly communicate technical information to non-technical stakeholders.
• Strong organizational skills and the ability to manage multiple priorities.

Responsibilities

• Write and maintain SQL queries to extract data from internal systems, including POS, inventory, compliance, and financial systems.
• Work directly with databases to retrieve, join, clean, and structure datasets for reporting and analysis.
• Ensure the accuracy, consistency, and reliability of data across multiple business systems.
• Optimize SQL queries and reporting processes for performance and scalability.
• Build, maintain, and enhance dashboards using Power BI or similar business intelligence platforms.
• Create automated reporting solutions that improve efficiency and increase visibility across the organization.
• Develop standardized reporting across all business units, including: Inventory tracking and shrink, Compliance metrics, Operational performance, Labor performance.
• Analyze sales, inventory, labor, and operational trends across multiple retail and production facilities.
• Identify patterns, inefficiencies, risks, and opportunities for operational improvement.

Skills

SQL

Power BI

Tableau

Large datasets

Analytical thinking

Attention to detail

Communication

Organizational skills

Problem solving

Tools

ERP systems

CRM systems

POS systems

Job description

DACUT Cannabis is seeking a highly analytical Data Analyst with strong SQL and BI skills to support reporting, analytics, and operational visibility across retail, cultivation, processing, and corporate functions.

You will transform raw data into actionable insights, build dashboards in Power BI, and partner with cross-functional teams to drive performance and compliance. The role emphasizes data quality and executive storytelling.