Data Analyst

Canopy Growth; Toronto; Hybrid; CAD 70,000 - 90,000; Full time

Job summary

A leading cannabis company in Ontario is seeking a skilled Data Analyst to enhance master data management and deliver insights through Microsoft Power BI. The ideal candidate will have over 4 years of experience in data analytics and proficiency in SQL and ERP systems. This is a full-time role offering the chance to work in a values-driven environment.

Qualifications

• 4+ years of experience in data analytics, business intelligence, and reporting.
• Strong SQL proficiency with complex queries and performance tuning.
• Advanced Power BI skills including DAX and data modeling.

Responsibilities

• Develop and implement master data management strategies.
• Extract, analyze, and report on key business data from ERP systems.
• Design interactive dashboards and reports using Microsoft Power BI.

Skills

Master Data Management

SQL proficiency

Microsoft Power BI

Data analysis

Education

Bachelor’s degree in computer science, Information Systems, Data Analytics, or related field

Tools

ERP systems (preferably Sage X3)

SQL Server

Microsoft Power BI

Job description

The Company

At Canopy Growth, our mission is clear: improve lives, end cannabis prohibition, and strengthen communities.We believe that cannabis can be a force for good. We’re building a consumer-centric organization that is focused on sharing the transformational potential of cannabis with the world. We will achieve this through an innovative and disruptive portfolio of cannabis and hemp-derived products.

Canopy Growth is the world's leading cannabis and hemp company. We recognize that employees are at the core of our success, and we take pride in a corporate culture that emphasizes inclusiveness, collaboration, and diversity.

Our employees come from a wide range of backgrounds, each bringing their own unique skills and talents to the table, working together to continue our incredible momentum of growth. If you are interested in building global challenger brands, scaling a business, and working in a values-driven environment, we want to hear from you!

The Opportunity

We are seeking a highly skilled Data Analyst with strong experience in Master Data, Microsoft Power BI and ERP systems to join our Data Engineering & Analytics team. The ideal candidate will have expertise in master data management, reporting, data modeling, enabling them to deliver actionable insights and support business decision-making.

Responsibilities

Master Data Management (MDM) & Governance

• Develop and implement master data management (MDM) strategies to ensure data consistency, accuracy, and integrity.
• Define and enforce data governance policies, including data ownership, stewardship, and quality standards.
• Manage master data domains (e.g., customers, vendors, products, financial data) across the organization.
• Work closely with business teams to define data definitions, taxonomies, and hierarchies.
• Monitor data quality metrics, identify anomalies, and implement corrective actions.
• Collaborate with IT and business teams to establish data integration and synchronization processes.
• Support ERP master data migration, consolidation, and cleansing efforts.
• Ensure consistency and integrity of master data across ERP and other business systems.

ERP Data Analysis & Reporting

• Work with ERP systems (preferably Sage X3) to extract, analyze, and report on key business data.
• Ensure accurate and seamless data integration between the ERP system and other enterprise applications.
• Identify opportunities for data automation and process improvement related to ERP reporting.

SQL & Database Management

• Write, optimize, and troubleshoot complex SQL queries for data extraction, transformation, and analysis.
• Develop and maintain stored procedures, functions, views, and triggers to support analytics and reporting needs.
• Perform data cleansing, validation, and normalization to ensure accuracy and consistency across databases.
• Work with relational databases such as SQL Server, MySQL, PostgreSQL, or Oracle to support data analysis requirements.
• Implement indexing, partitioning, and performance tuning techniques to enhance query efficiency.
• Ensure data security, integrity, and compliance when handling sensitive business data.

Power BI Reporting & Data Visualization

• Design and develop interactive dashboards and reports using Microsoft Power BI to provide business insights.
• Work with DAX (Data Analysis Expressions) to create calculated columns, measures, and aggregations.
• Build and manage Power BI data models, including defining relationships, hierarchies, and calculated tables.
• Implement row-level security (RLS) to restrict access to sensitive data within Power BI reports.
• Optimize Power Query (M Language) transformations to efficiently process and shape data from multiple sources.
• Publish, maintain, and schedule Power BI reports and datasets using Power BI Service.
• Integrate Power BI with other data sources, APIs, and cloud-based solutions (e.g., AWS, Snowflake).
• Conduct user training and support for Power BI report consumers.

Experience

• Bachelor’s/College degree in computer science, Information Systems, Data Analytics, or a related field.
• 4+ years of experience in data analytics, business intelligence, and reporting.

• Strong SQL proficiency, with experience in writing and optimizing complex queries, stored procedures, and performance tuning.

• Advanced Power BI skills, including DAX, Power Query (M), data modeling, and Power BI Service administration.

• Experience with ERP systems (preferably Sage X3) for data extraction, integration, and reporting.

• Knowledge of data modeling techniques (e.g., star schema, snowflake schema, dimensional modeling).

• Understanding of master data management (MDM) principles and data governance.

• Strong analytical, problem-solving, and communication skills to interact with technical and non-technical stakeholders.

• Experience working with AWS cloud services (S3, RDS, Redshift, Lambda) is an asset.
• Knowledge of cloud-based data platforms (AWS, Snowflake) is a plus.

Other Details

This is a full-time role based out of Ontario.

#LI-Remote

We appreciate your interest, and promise to review all applications, but we will only be contacting those who best fit the requirements.

We welcome and encourage applications from people with disabilities. Accommodations are available upon request for candidates taking part in all aspects of the selection process. If you require accommodation, please notify your Talent Acquisition Partner. Please note, the chosen applicant will be required to successfully complete background and reference checks.