Data Analyst, Commercial Finance

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.

With millions of square feet of licensed production capacity and operations spanning four continents, 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

Reporting to the Manager, Commercial Finance, the Data Analyst will act as a key support figure on the Commercial Finance team, defining and leading the implementation of data policies, procedures, governance, and documentation that pertain to master data management and data integrity/validation, to support complete and accurate downstream organizational reporting. The Data Analyst will further be responsible for supervising the intake, ingestion, processing, and delivery of various data sources into a centralized data warehouse on a daily/weekly/monthly basis (as warranted by the data source), as well as overseeing and executing the responsibilities related to the maintenance of raw data integrity.

Responsibilities 

• Lead the weekly master data management process for Canopy’s commercial sales data, including but not limited to data cleaning, updating master references tables, ETL and pipeline management, and pursuing avenues for process automation with a focus on master data management

• Manage dynamic product and location hierarchies within the Master Reference Tables, ensuring completeness and accuracy of attributes populated within

• Support the Manager in engaging with stakeholders across the business to ensure reporting and data dictionaries are actionable, relevant and accurate

• Routinize and execute daily/weekly data audits and validate reporting and self-serve analytical tools, as well as ad-hoc audits for new integrations occur and reporting

• Maintain user catalogues and distribution lists to facilitate thorough and efficient communication with end user groups

• Develop, maintain and socialize documentation related to all routinized processes held within the Commercial Finance team, including documentation of data sources, master data management routines, reporting overviews, training materials, etc.

• Support the Manager in critical aspects of supporting Canadian Recreational and Medical business units from a data and analytics infrastructure standpoint

• Maintain department-owned MySQL database and AWS repository

• Work with IT organization to adhere to and maintain organizational requirements around cyber security, data storage, and documentation

• Work with IT to ensure complete and accurate data representation in Snowflake

Experience/Qualifications

• Minimum bachelor’s degree in Statistics, Information Technology, Finance or similar

• 3+ years of experience in master data management and/or data governance roles, preferably in a CPG/Retail/Alcohol environment

• Advanced user of MS Office suite, with a focus on Excel; experience with VBA considered a strong asset

• Proficiency in SQL, relational databasing and data warehousing with proven experience managing a SQL database; proficiency in R and Python are considered assets

• Experience with Snowflake and AWS S3 is preferred

• Experience with data visualization tools (particularly Tableau and PowerBI) is considered an asset

• Attention to detail is imperative to success in this role, as is focus on routinized, process-driven work

• Excellent time management and organizational skills, and ability to balance and execute against multiple competing priorities simultaneously

• Demonstrated ability to work with cross-functional teams and to thrive in a fast-paced and dynamic working environment

• Excellent written and verbal communication skills, including sharing ideas and information across diverse audiences

• Prior experience in Finance is considered a strong asset

Other Details

This is a full-time remote position based out of Toronto, ON, with flexibility to work in-office from our Smiths Falls location.

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.