Share this Job

Business Intelligence Data Analyst

Job location: REMOTE
Employment type: FT
Hours: 40


A little about us
Hi, we’re Aurora Cannabis, and we’re so excited to meet you! 


We’re a global cannabis company driven by our passion to help people improve their lives. We have a diverse team who bring their best every day so Aurora can be the cannabis provider of choice for patients and consumers.  We love our work, and we especially love our high quality, innovative brands that make up the Aurora family – from Aurora, Aurora Drift, San Rafael ’71 and Whistler. 


Our people combined with our collective passion for the industry is what makes Aurora a special place to work and defines what we call our “A-Team”. We are a high-performing team of cannabis experts, innovators, and champions, that work, learn and win together. We think BIG, act BOLD and execute with PURPOSE in all that we do, and will stop at nothing to cultivate the ultimate cannabis experience for our community. 

Job summary

Our Business Intelligence and Analytics department integrates data and develops modern reporting solutions, provides advanced analytics to all business units across the organization to generate insights and foster innovation. 

As the Data Analyst in the Data Science and Analytics team, the successful candidate will possess very strong analytical skills and the proven ability to gather, view and analyze all forms of information in detail. You will work directly with the business stakeholders. The ideal incumbent will have excellent familiarity of data analysis processes and systems and outstanding interpersonal skills. Previous experience in Microsoft BI technology such as SQL Server, Power BI and DAX scripting is critical. The candidate will need to identify the business needs and requirements, process data from multiple sources, and deliver analytical results. You will be a key contributor who enables Aurora to make decisions by turning data into actionable insights.


We are looking for a highly motivated team player who is always able to deliver on time. Apply if you enjoy data and analytics, are innovative, love to advocate for change, and have the desire to develop strong working relationships with intelligent colleagues in a new and fast-growing international organization!


As a BI Data Analyst, you will...

  • Maintain strong relationships and work closely with stakeholders to identify business needs and provide recommendations for innovative analytical solutions 
  • Lead workshops and collaborate in small groups to gather information from business domain SMEs to identify business objectives, process workflows and requirements.
  • Extract and merge data sets from multiple data sources. Perform data cleansing, transformation, exploration, analysis and visualization with Microsoft BI technologies.
  • Build on-demand interactive reports using Microsoft Power BI and deploy your solutions to Power BI Service.
  • Support day-to-day requests for data analysis such to support data driven decision making.
  • Act as a mentor to more junior team members in PowerBI and SQL development
  • Optimize SQL and DAX queries to achieve optimal report refresh performance.
  • Manage multiple projects simultaneously while exhibiting professionalism to ensure an incredible stakeholder experience.

You would be the best fit for this role if you have...

  • A university degree or diploma in Computing Science, Statistics, Mathematics, or similar quantitative disciplines plus 5+ years of work experience in Business Intelligence and Analytics.
  • Very strong experience in database systems including data warehouses and multi-dimensional analytic solutions. Very strong experience working with various data types.
  • Outstanding skills in Microsoft BI technologies with expert level knowledge of Power BI, DAX and SQL Server. Knowledge of Power Apps and Power Automate is a plus.
  • Excellent SQL skills to write complex queries involving multiple tables and develop stored procedures, triggers, user defined functions.
  • Practical experience with Databricks or Spark is a plus.
  • Proven knowledge or certification related to using cloud platform and/or serverless architecture for data processing and analysis. Experience with Azure services such as ADF, ADL, Functions, ML Studio and Logic Apps is preferred.
  • Strong Agile project experience with proven ability to develop user stories and managing backlog(breaking up user stories into tasks and sizing them up).
  • Demonstrated success with strategic analytical projects, working with various stakeholders across the business areas.
  • Demonstrated ability to manage deadlines, workload, and multiple complex projects.
  • Strong desire to learn new technologies and to keep up the latest trends in data analysis


Why you’ll love working at Aurora 
Our people are at the heart of everything we do here at Aurora, and we take pride in fostering an inclusive space that inspires our team to love where they work! From rewarding career opportunities to flexible work environments to team activities, we go above and beyond to prioritize your success and here’s how we do it…  

  • Flexibility: you will enjoy a flexible work environment that is the perfect blend of work and fun! With flexible working hours to compressed work weeks (OR remote work options – depending on role) to paid sick and vacation time, you will be empowered to achieve work-life balance.


  • Total rewards: we will motivate you to go above and beyond with a competitive salary or hourly wage (with shift premiums), stock options, an RRSP program, annual bonuses, and a health and personal care spending account for you to use for gym memberships, ski passes or staycations.


  • Benefits: we will foster your health and wellness (and your dependents) with our employee benefits package including, employer-paid health and dentalcare premiums, life insurance and LTD policies and a medical cannabis coverage program, designed exclusively for our A-Team, that will provide you with $3,000 of coverage each year (because we truly believe cannabis is the best medicine).  


  • Life-long learning: we’re lifelong learners here at Aurora and will invest in your professional development throughout all aspects of your career! You will have access to a tuition assistance program, virtual learning activities and annual performance reviews, to ensure you are provided with the toolkit and support you need to succeed. 


  • Perks: we love to celebrate our people by providing corporate perks including employee discounts, perkopolis memberships, company SWAG, paid volunteer time, modern technology and snacks and beverages at all our office locations.


  • Team: we are a diverse and global team of cannabis enthusiasts, energetic innovators, fitness gurus, caring parents, foodies and more, with a collective passion to nurture an inclusive environment that helps you grow and provide people better days with medical cannabis. 

Next steps
Think you have what it takes to join our team? So do we! 


Apply today by submitting your resume along with salary expectations through our website. You can expect your application to be reviewed by a human recruiter (not a robot) shortly after you apply, and our team will contact you via email if we see a fit. 


Think you’re the ideal candidate but you don’t meet all the requirements? Apply anyways! We would love to review your application to see if you’re the right fit or find you an alternative opportunity! 

Not the role for you? That’s okay! Visit our careers page to find the perfect opportunity for you or share this posting with a friend or colleague that you think would be a great fit (hot tip: if you are already an Aurora employee, take advantage of the employee referral program by referring this posting to a friend! If they are successful, you will receive a bonus!) 

Diversity and inclusion
At Aurora, we are proud to foster and celebrate a diverse community of professionals! We take pride in nurturing an inclusive culture that empowers our people to be their authentic selves, celebrate their differences and love where they work. 


Our diverse community combined with our inclusive culture, is what sets us apart in the industry and equips our A-Team with superpowers – and this is why, we encourage all candidates to apply for job opportunities regardless of race, national origin, colour, religion, age, gender identity or expression, sexual orientation, marital and family status, disability, or any other identifying characteristic. If you require accommodation (including, but not limited to, an accessible interview site or alternate format of job posting) during the recruitment and selection process, please do not hesitate to let our team know! We are here to help. 

Health and safety
Our mission at Aurora has always been to improve the health and wellness of our core community. We strive to create a safe, healthy, and inclusive environment for our team and strongly believe introducing a mandatory COVID-19 vaccination policy will help us achieve this. 


As of February 2022, Aurora has introduced a mandatory COVID-19 vaccination policy for all employees and as a condition of employment, all candidates must provide proof of vaccination against COVID-19 or receive an approved medical or human rights accommodation prior to commencing employment with Aurora. If proof of vaccination is not provided or a request for accommodation is not approved, the offer of employment will be rescinded.


If applicable, Aurora Human Resources will contact you via your email address provided. We do not contact candidates over Facebook or other Social Media apps. You will never be requested to provide confidential information such as banking information or your Social Insurance Number in the interview process.

Job Segment: Database, Medical, Business Intelligence, Social Media, Data Analyst, Technology, Healthcare, Marketing, Data