Data Engineer, Data and Analytics

Work Location

About SNDL

SNDL is the largest private sector liquor and cannabis retailer in Canada with retail banners that include Ace Liquor, Wine and Beyond, Liquor Depot, Value Buds, and Spiritleaf. As a licensed cannabis producer, SNDL also has indoor state-of-the-art grow-op facilities to supply wholesale and retail customers under a cannabis brand portfolio that includes Top Leaf, Sundial, Palmetto, Spiritleaf Selects, and Grasslands. SNDL's investment portfolio seeks to deploy strategic capital through direct and indirect investments and partnerships throughout the global cannabis industry.

Job Overview

SNDL’s Business Technology Team designs, delivers and operates the products and platforms that enable SNDL’s profitability and growth. This is your opportunity to apply your leadership experience at an established company in a new & emerging industry. This unique role will provide the incumbent with a broad leadership role in data, analytics and business intelligence operations, platforms and projects throughout the corporation, in a team-oriented environment, with the potential for directly impacting SNDL’s results and growth.

Reporting directly to the Director, Data & Analytics, you are responsible for leading the design, implementation and maintenance of robust data integration, data transformation, and data modeling solutions.  You will enable data-driven decision making and insights by ensuring enterprise data is timely, accurate, trusted and properly structured for business and analytical consumption across the enterprise.

Roles and responsibilities include, but are not limited to:

• Design, develop, and maintain scalable data integration pipelines with Microsoft tools such as Azure Synapse Analytics, Azure Data Factory, Microsoft Fabric, and SQL Server.
• Build and optimize semantic data models and dimensional schemas to support analytics and reporting across business units and functions including sales, operations, supply chain, customer engagement, finance, HR and other analytics consumers.
• Extract, transform, and load (ETL/ELT) data from Microsoft Dynamics 365 Finance and Operations into the enterprise data platform.
• Integrate data from other line-of-business applications to support analytics across the organization.
• Build, publish and manage curated datasets in Power BI, ensuring alignment with reporting standards and analytical needs.
• Implement, manage and mature CI/CD pipelines for data integration workflows using Azure DevOps, enabling consistent, automated, and testable deployments across environments that enable complete data lineage tracing from data-source to report.
• Work closely with the ERP and application teams, application developers, and business analysts to understand and fully document data sources, application data flows, integration requirements, and business context for analytics.
• Proactively identify, investigate, and resolve issues in data pipelines (and data repositories) to ensure high availability, quality, and reliability of data provisioning processes.
• Contribute to the development and deployment of enterprise-wide data models (e.g. the customer entity) and business-centric data glossaries that mature the organization’s data literacy and adoption of data and analytics for decision-making. 
• Monitor, troubleshoot, and optimize data integration processes, stored procedures and other data processes enabling analytics and enterprise data integration

Experience and Qualifications:

• Minimum of 5 years in data engineering, data integration, and data platform development roles.
• Expert level knowledge and use of Microsoft Azure data services, including Azure Synapse, Azure Data Factory, Microsoft Fabric, SQL Server, and Azure SQL.
• Proven ability to design, implement and optimize data warehouses with industry-standard frameworks (e.g. Kimball).
• A comprehensive understanding and application of modern data architecture such as fabric or mesh architecture.
• Proven ability to design and implement enterprise-grade data pipelines and dimensional data models for business intelligence and analytics.
• Expert level knowledge of Power BI dataset development, DAX, and Power Query.
• Advanced SQL skills are required for this role; the ability to create, debug and optimize SQL Server stored procedures is a key requirement.   
• Programming experience with “data engineering” languages such as Python is an asset.  
• Experience implementing CI/CD pipelines using Azure DevOps for deploying data integration solutions in a controlled, auditable, and automated manner.
• Familiarity with internal controls and SOX-compliance related to enterprise data management, role-based access controls, and data security is preferred. 
• Experience extracting and transforming data from ERP systems, preferably Dynamics 365 Finance and Operations.
• Familiarity with data governance frameworks is an asset.
• Knowledge of, and experience with, master data management is preferred.
• Prior experience in the retail industry is preferred.
• Proven ability to work in cross-functional teams of ERP analysts, software developers, and business analysts, to deliver integrated and business-aligned data solutions.
• Exceptional verbal and written communication skills; the ability to clearly describe and document data flows, data models, ETL, and data integration processes.
• Preferred certifications include Microsoft Certified Azure Data Engineer Associate, Power BI Data Analyst Associate, Fabric Data Engineer Associate, and/or DevOps Engineer.

As a valued member of the SNDL team, you will enjoy:

• Competitive total compensation and incentives.
• An extended benefits package including medical, health spending account and dental.
• An entrepreneurial and innovative environment that fosters growth and continuous learning.

We are grateful for the interest in this role from all candidates; however, we will be contacting only those that are selected for next steps in the hiring process.

Our Commitment to Diversity & Inclusion:

SNDL is an equal opportunity employer. We are committed to building a welcoming, inclusive, diverse, and safe workplace where all our team members have equal opportunity to succeed. We know this begins with recruitment. To honor our commitment, SNDL encourage applications from individuals from all backgrounds, sexual orientation, gender identity, ancestry, ages and abilities.