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

No7 Advisor
No.7 Boots Blackpool, England 11.3 - 12.5 GBP HOURLY Today

Consistently delivering against your sales targets by driving in store promotions and No 7 offers. Making sure your counter is beautifully and expertly

data entry
IntraHealth Leyland, England Today

Bank & Casual contracts Data Entry Support

Lancashire Business Park

We are looking for Data Entry Support to...

SEARCH ENGINE OPTIMIZATION (SEO) SPECIALIST (M/F/D)
EAME Regional Office London, England Today

Contribute to the development and implementation of local and international SEO strategies. As the SEO Specialist, you will be responsible for optimizing Hyatt

advisor
DIY Kitchens Remote 24960 - GBP HOURLY Today

You will be working a 4 on 4 off shift.

Remote working. Must be available for training in Pontefract for a couple of weeks.

About...

Shop Assistant
Podium 4 Sport Belfast, Northern Ireland 6.56 - 12 GBP HOURLY Today

Customer service, a successful applicant will be comfortable speaking with and advising customers. Staff discount on all store products.