Manager of Enterprise Analytics

Who We Are

Ascend Wellness Holdings (AWH) is a vertically integrated cannabis cultivator, processor, and retailer with assets in Illinois, Maryland, Massachusetts, Michigan, New Jersey, Ohio, and Pennsylvania. Our mission is to shape the future of cannabis as a leading healthcare solution while delivering a premium, customer-focused retail experience. We are committed to building a high-performing team that is passionate about our products, our communities, and creating operational excellence across our growing footprint.

The Role

The Manager, Enterprise Analytics is responsible for the design, operation, and maintenance of AWH's SQL database environment, ETL/ELT pipelines, and the enterprise semantic models that serve as the authoritative source for Power BI reporting and analytics. The role requires deep SQL and Azure platform expertise, strong Power BI and Microsoft Fabric proficiency, and the ability to manage data projects end-to-end in a collaborative environment.

Location: This is a remote position

Key Responsibilities

Data Infrastructure & Architecture

• Supports and maintains Azure-based SQL Server environments across development, test, and production tiers.
• Participates in the architecture and design of the enterprise data platform, including Microsoft DevOps and Fabric.
• Acts as coordinator for data engineering projects to ensure appropriate design, performance, and security controls.
• Evaluates new data and BI technologies and assesses their application in the AWH environment.

Semantic Models & Business Intelligence

• Designs, builds, and maintains enterprise semantic models (Power BI Tabular, Direct Lake) as the authoritative business logic layer for reporting.
• Defines and governs measures, KPIs, hierarchies, and relationships to ensure consistency across downstream consumers.
• Partners with business stakeholders to document metric definitions and encode them in reusable, version-controlled model assets.
• Monitors and tunes semantic model performance including DAX optimization and incremental refresh configurations.

ETL / Data Pipelines

• Designs and develops ETL/ELT pipelines using Azure Data Factory, Microsoft Fabric Pipelines, dbt, or equivalent tools.
• Develops and integrates data from a variety of sources including transactional systems, SaaS platforms, and third-party APIs.
• Manages and monitors production data jobs and pipelines daily, ensuring SLA adherence and data freshness.
• Performs scheduled maintenance including code promotion to test and production environments.

Operations & Governance

• Manages mission-critical databases requiring 24x7 business operational support.
• Responsible for SQL design reviews, query optimization, and data security enforcement.
• Implements data quality checks and observability tooling across the data platform.
• Develops and enforces data engineering best practices including documentation, naming standards, and CI/CD practices.

Qualifications and Experience

• Bachelor's Degree in Computer Science, Data Science, Information Systems, or a related field.
• Minimum five years of experience in BI engineering, data engineering, or a related SQL/database role.
• Demonstrated experience building and maintaining semantic models in Power BI (Tabular, DAX) or Azure Analysis Services.
• Hands-on experience with Azure data services: Azure SQL Database, Azure Synapse Analytics, and/or Azure Data Factory.
• Working knowledge of Microsoft Fabric including Fabric Lakehouses, OneLake, Fabric Pipelines, and Direct Lake models.
• Experience with dbt or similar transformation frameworks for building modular, tested data pipelines.
• Deep proficiency in SQL including query tuning, execution plan analysis, and optimization for large-scale datasets.
• Experience with SQL Server in the Azure environment.
• Knowledge of database backup/restore strategies, transactional replication, and database security concepts.
• Familiarity with monitoring and observability tools for SQL Server and cloud data platforms (Azure Monitor or equivalent).
• Familiarity with Git and CI/CD practices applied to data assets and model deployments.
• Retail industry experience preferred, ideally within a multi-site or high-growth environment
• Strong problem-solving and analytical skills; ability to analyze complex technical and data-related challenges.
• Ability to work independently and collaboratively across data, engineering, and business teams.
• Strong communication skills with the ability to translate technical concepts for non-technical stakeholders.

Work Environment

This position primarily performs duties in a remote office setting.

Physical Requirements

While performing the duties of this job, this position is regularly required to sit and regularly use hand(s) to handle, grasp, feel, and or touch. This position is occasionally required to stand, walk and reach with hands and arms. This position is required to speak and listen regularly.

EEO Statement

Ascend Wellness Holdings, Inc. ("AWH") and its subsidiaries is an equal opportunity employer and celebrate the population of differences and does not discriminate in its hiring / hiring practices, regardless of race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, veteran status, or any other characteristic protected by law.

Nothing in this job specification restricts management's right to assign or reassign duties and responsibilities to this job at any time. Critical features of this job are described under various headings above. They may be subject to change at any time due to reasonable accommodation or other reasons. The above statements are strictly intended to describe the general nature and level of the work being performed. They are not intended to be construed as a complete list of all responsibilities, duties, and skills required of employees in this position.

This job description in no way states or implies that these are the only duties to be performed by the employee(s) incumbent in this position. Employees will be required to follow any other job-related instructions and to perform any other job-related duties requested by any person authorized to give instructions or assignments. All duties and responsibilities are essential functions and requirements and are subject to possible modification to reasonably accommodate individuals with disabilities.

To perform this job successfully, the incumbents will possess the skills, aptitudes, and abilities to perform each duty proficiently. Some requirements may exclude individuals who pose a direct threat or significant risk to the health or safety of themselves or others. The requirements listed in this document are the minimum levels of knowledge, skills, or abilities. This document does not create an employment contract, implied or otherwise, other than an "at will" relationship.