Please Accept our Privacy Policy
Position Description: About the RoleDACUT Cannabis is seeking an experienced AI Data & Analytics Engineer to build intelligent reporting, automation, and forecasting solutions across our vertically integrated cannabis position will combine artificial intelligence, financial analytics, SQL, Power BI, and data engineering to improve decision-making across retail, cultivation, processing, distribution, and corporate operations. The AI Data & Analytics Engineer will transform complex financial and operational data into scalable dashboards, predictive models, automated workflows, and actionable business ideal candidate has strong technical experience with AI-powered analytics, financial modeling, SQL development, and Power BI. Experience supporting a vertically integrated, multi-location organization is highly ResponsibilitiesArtificial Intelligence & AutomationDevelop and implement AI-powered tools that improve forecasting, reporting, operational efficiency, and financial machine-learning models for revenue forecasting, demand planning, inventory optimization, labor analysis, and expense opportunities to automate recurring financial, operational, and executive AI-assisted workflows using large language models, APIs, and automation systems that identify trends, anomalies, financial risks, and operational emerging AI technologies and recommend practical applications across the safeguards and validation processes to ensure AI-generated insights are accurate, secure, and AnalyticsAnalyze revenue, gross margin, operating expenses, labor costs, inventory value, profitability, and cash-flow financial models, forecasts, budgets, and scenario analyses for executive location-level, department-level, product-level, and brand-level profitability performance across retail, cultivation, processing, distribution, and corporate with Finance and Accounting to validate financial data and maintain consistent reporting automated reporting for actual performance compared with budgets, forecasts, and prior strategic planning by identifying cost-saving opportunities, revenue trends, and performance BI & Business IntelligenceDesign, develop, and maintain executive-level Power BI dashboards and reporting scalable data models using Power Query, DAX, calculated measures, and dashboards for financial performance, retail sales, inventory, cultivation yields, production output, labor, and operational row-level security, scheduled refreshes, and data-quality dashboard usability by presenting complex information in a clear and actionable consistent definitions for KPIs across departments and business & Data EngineeringWrite, optimize, and maintain complex SQL queries, stored procedures, views, and data and manage ETL/ELT pipelines that consolidate information from multiple data from POS, ERP, accounting, payroll, inventory, compliance, CRM, and operational centralized datasets that support reporting, forecasting, and AI data pipelines, troubleshoot failures, and resolve inconsistencies between source processes for data cleansing, validation, reconciliation, and the development of a reliable data warehouse or centralized reporting Integrated OperationsConnect data across retail, cultivation, processing, distribution, inventory, finance, and corporate reporting that tracks products and costs throughout the entire operational cultivation yields, production costs, inventory movement, retail sell-through, product margins, and overall gaps between departments that affect data accuracy, inventory control, or financial with leaders across each division to understand operational challenges and develop data-driven standardized reporting across multiple locations, departments, brands, and legal Governance & ComplianceMaintain accurate, consistent, and secure financial and operational documentation for data sources, models, calculations, dashboards, and automated validation controls to identify missing, duplicated, or inaccurate confidential financial, employee, customer, and operational reporting requirements within a highly regulated AI tools and data integrations follow company security, privacy, and compliance QualificationsBachelor’s degree in Data Science, Computer Science, Data Analytics, Finance, Accounting, Engineering, or a related least 3–5 years of experience in data analytics, business intelligence, data engineering, financial analytics, or a related SQL skills, including complex joins, CTEs, data transformations, query optimization, and database experience developing Power BI dashboards, semantic models, Power Query transformations, and DAX experience applying AI, machine learning, or predictive analytics to real business understanding of financial statements, budgeting, forecasting, profitability, and operational integrating and reconciling data from multiple business to translate complex technical findings into clear recommendations for executives and operational analytical, organizational, and problem-solving to work onsite at the West Bloomfield corporate QualificationsExperience supporting a vertically integrated or multi-entity within cannabis, manufacturing, retail, distribution, consumer packaged goods, or another highly regulated with Python, Microsoft Fabric, Azure, Databricks, APIs, or cloud-based data building machine-learning models, AI agents, or large language model of ERP, POS, inventory-management, payroll, and accounting analyzing product costing, inventory valuation, supply-chain performance, and multi-location with cannabis platforms such as METRC, Dutchie, Alpine IQ, or similar developing enterprise data governance and KPI CompetenciesAI and machine-learning implementationFinancial modeling and forecastingPower BI dashboard developmentAdvanced SQL developmentData engineering and system integrationBusiness intelligence and executive reportingProcess automationData governance and quality controlVertically integrated operational analysisCross-functional communicationWhat Success Looks LikeLeadership has timely access to accurate financial and operational reporting processes are replaced with reliable automated forecasts become more accurate and from retail, cultivation, processing, inventory, and corporate systems is BI dashboards provide a consistent view of performance across the solutions produce measurable improvements in efficiency, profitability, and decision-making.#Priority26 $90,000.00 - $110,000.00 Annually