Manager, Enterprise Analytics

Renew Cannabis Co.; Eatontown, Northern (NJ, KY); Hybrid; USD 120,000 - 180,000; Full time

Job summary

Ascend Wellness Holdings, LLC is seeking a Manager, Enterprise Analytics to lead the design, operation, and maintenance of the SQL database environment and ETL/ELT pipelines, enabling trusted Power BI reporting and analytics across the organization.

You will oversee data architecture, semantic modeling, and governance, collaborating with stakeholders to define metrics and ensure data quality, security, and performance in Azure and Fabric environments.

Qualifications

• Bachelor's degree in a related field
• Minimum five years of experience in BI engineering, data engineering, or a related SQL/database role
• Experience building semantic models in Power BI (Tabular, DAX) or Azure Analysis Services
• Hands-on experience with Azure data services such as Azure SQL Database, Azure Synapse Analytics, and/or Azure Data Factory
• Knowledge of Microsoft Fabric including Fabric Lakehouses, OneLake, Fabric Pipelines, and Direct Lake models
• Experience with dbt or similar transformation frameworks
• Strong SQL proficiency with tuning and optimization for large datasets
• Experience with SQL Server in Azure environment
• Knowledge of data security concepts and data quality checks
• Familiarity with Git and CI/CD for data assets and model deployments
• Strong problem-solving and communication skills

Responsibilities

• Maintain Azure-based SQL Server environments across dev, test, and production tiers
• Design, build, and maintain enterprise semantic models (Power BI Tabular, Direct Lake) as the authoritative logic layer
• Define and govern measures, KPIs, hierarchies, and relationships for consistency
• Develop ETL/ELT pipelines using Azure Data Factory, Fabric Pipelines, dbt, or equivalent
• Manage and monitor production data jobs and pipelines with SLA adherence
• Perform code promotion to test and production environments
• Implement data quality checks and observability tooling
• Enforce CI/CD practices and documentation for data assets

Skills

SQL

Power BI

Azure

dbt

Fabric

CI/CD

Git

DAX

Data Modeling

Education

Bachelor's Degree in Computer Science, Data Science, Information Systems

Tools

Azure Data Factory

Fabric Pipelines

OneLake

Job description

JOB SUMMARY

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.

PRIMARY RESPONSIBILITES

• 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.

JOB REQUIREMENTS

• 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.
• 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.

EEO STATEMENT

Ascend Wellness Holdings, LLC 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.