bi analyst

bi analyst Toronto

Auxly Cannabis Group
Full Time Toronto 85467 - 66500 CAD ANNUAL Today
Job description

Business Intelligence & Data Visualization Specialist

Toronto, ON (Hybrid)


About Auxly Cannabis Group Inc.

Auxly is an international cannabis company dedicated to bringing innovative, effective, and high-quality cannabis products to the medical, wellness and adult-use markets. Auxly's experienced team of industry first-movers and enterprising visionaries have secured a diversified supply of raw cannabis, strong clinical, scientific, and operating capabilities and leading research and development infrastructure to create trusted products and brands in an expanding global market. Learn more at www.auxly.com and stay up to date at Twitter: @AuxlyGroup; Instagram: @auxlygroup; Facebook: @auxlygroup; LinkedIn: company/auxlygroup/.


About the role

Based out of Toronto, ON, Auxly Cannabis is currently looking for a passionate Business Intelligence & Data Visualization Specialist to join our Technology team. Reporting to the Director, of Application Solutions, the ideal candidate aspires to work in the growing cannabis field with an award-winning team!


The technology team is looking for a passionate person with a business-savvy mindset to help us turn our data into actionable insights. This role is part of the team responsible for driving the strategic vision and execution of Data Warehousing, Business Intelligence and Data Visualizations. You will own and be responsible for building a portfolio of enterprise-wide dashboards and the data architecture needed to achieve them.


What you can expect to do:

Data Visualizations:

  • Design, develop, and implement advanced visualizations and executive-level interactive dashboards to turn company data into actionable insights.
  • Engage with stakeholders and analytical business partners to understand KPIs, determine methods to calculate them and incorporate them into dashboards.
  • Create day to day reporting with a variety of tools to assist in monitoring business performance and identifying exceptions.
  • Running ad-hoc queries for internal stakeholders as needed

Data Warehouse:

  • Design, develop and modify relational and multidimensional database structures, relationships, data flows and data interfaces within the data warehouse.
  • Build data models and data marts to support business data analysis needs.
  • In collaboration with DevOps Engineer, design, test and maintain ETL processes to load data from various sources into the data warehouse.
  • Create and maintain complex SQL views.

Projects & Other Responsibilities:

  • Collaborate with business stakeholders to understand data analysis requirements and data sources
  • Manage data warehouse & visualisation projects from inception to completion.
  • Drive user adoption of reporting and visualization applications and ongoing end user support.
  • Create documentation for and deliver training to business users on the use of company’s data analysis tools.
  • Maintain security roles and access rights according to company’s best practices.
  • Establish subject matter expertise and strongly influence our data warehousing and visualization strategy.
  • Own budget responsibility for data warehouse reporting and visualization. Monitoring and controlling licencing costs, usage costs and costs of external resources.

What we are looking for

  • Must have 3 years experience using Microsoft SQL Server and crafting advanced SQL queries
  • Must have 3 years experience using Power BI and DAX
  • A minimum of 3-5 years of experience in analyzing, designing, testing, and deploying Business Intelligence and Data Analytics reporting tools and content.
  • Experience with ERP processes (Purchasing, Manufacturing, Sales, Inventory) and related data structures.
  • Experience with financial reporting (Income Statements, Balance Sheets) and related financial posting data.
  • Solid practical understanding of relational data modelling and data integration between disparate databases.
  • Excellent verbal and written communication skills to lead working sessions with business stakeholders.
  • Strong organizational skills to ensure proper follow up and adherence to project timelines.
  • Ability to lead reporting projects and functional cross-department teams.
  • Enjoys creating new ways of working at scale, without being overly process-heavy
  • Ability to work independently as well as cooperatively with a diverse group of teammates

Specific Technologies

  • Experience with current technology is a plus:
    • Power BI / DAX
    • SQL
    • Snowflake
    • Talend
    • Sage X3 ERP
    • CRM - Salesforce Cloud
    • Sage Enterprise Intelligence / Nectari

Auxly Cannabis Group Inc. is an equal opportunity employer and encourages applications from all qualified individuals. We thank all applicants for their interest, however, only those selected for an interview will be contacted.

We provide accommodation for job applicants with disabilities during the recruitment process in accordance with applicable laws. Please contact us to request accommodation.

About Auxly Cannabis Group

Revenue: Unknown / Non-Applicable
Size: 51 to 200 Employees
Type: Company - Public
Website: www.auxly.com

bi analyst
Auxly Cannabis Group

www.auxly.com
Toronto, Canada
Unknown / Non-Applicable
51 to 200 Employees
Company - Public
Consumer Product Manufacturing
Related Jobs

All Related Listed jobs

registered nurse
Royal Bournemouth Hospital Poole, England 42618 - 35392 GBP ANNUAL Today

We are looking for experienced nurses to join our friendly forward thinking unit as part of our senior team. Our nurses work closely alongside our...

Lifeguard
Mytime Active Beckenham, England 19760 GBP ANNUAL Today

To deal with customers in a friendly and professional manner and to ensure the highest level of customer enjoyment and satisfaction, meeting the Customer

PR Executive
British Airways Heathrow, England 28770 - 38970 GBP ANNUAL Today

Supporting the implementation of social engagement activities in collaboration with the airline's social media team.

social worker
NHS Liverpool, England 27596 - 25147 GBP ANNUAL Today

The post holder will be an integral part of the Cancer Multidsciplinary Team, who
assists, supports and co-ordinates patients along their cancer...

receptionist
Smith Crossing Orland Park, IL 38615 - 29508 USD ANNUAL Today

Part-time Role:
3-4 shifts per week

10AM - 3PM or 4PM - 8PM -- mixture of shift hours

Job Description:
Warm and...