[A-285] | Business Intelligence Data Engineer

Cannimed By Aurora Toronto, ON 2022-05-12 $130k - $150k -
Apply Now Copy link

Job location : REMOTE

Employment type : FT


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

Are you a cannabis enthusiast with an energetic spirit? Are you looking to work with a fun group of people? If so, we would love to meet you!

As a member of the Business Intelligence & Analytics team, the successful candidate will possess very strong technical and analytical skills to gather and analyze all forms of data in detail.

You will support the cloud base enterprise data warehouse maintenance and modernization through your advanced knowledge of data orchestration, ingestion, and reporting.

You will identify the business needs and requirements, assemble data sets through efficient data processing pipelines that balance speed and reliability.

You will develop automated reporting solutions and deliver analytical results for the business across the company. You will be a key contributor who enables Aurora to make data driven decisions.

Join an enthusiastic team that always enjoys learning, working collaboratively, and solving complex business problems with data.

As a BI Data Engineer, you will

- Maintain strong relationships with business stakeholders and work closely with Data Scientists, Analysts and Developers to ensure business needs are addressed.

- Maintain cloud base enterprise data warehouse and data marts.

- Automate reporting solutions and operationalize machine learning models.

- Implement optimised pipelines to extract and merge data sets from multiple sources.

- Perform data cleansing and transformation using advanced Azure tools.

- Work with the team to deploy new cloud-based reporting and analytics tools.

- Work side-by-side with the business SME’s, iterate the development in an agile fashion to build and test solutions with incremental changes.

- Set up automated deployment processes.

- Implement data process improvements such as optimizing data delivery and scalability.

- Execute multiple tasks simultaneously while exhibiting professionalism to ensure an incredible stakeholder experience.

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

- Very strong experience in database systems including data warehouses and multi-dimensional analytic solutions.

- Deep understanding of cloud technologies and infrastructure for data retention and processing such as Microsoft Azure Data Lake, Functions, Data Factory and Databricks.

- Proficiency in scripting and programming using R and / or Python, C#.

- Strong experience with Microsoft Azure data ingestion. Demonstrated via hands-on project experience.

- Outstanding skills in Microsoft full BI Stack in Azure environment. Excellent SQL development skills to write complex queries involving multiple tables and develop stored procedures, triggers, user defined functions.

- Proficiency in Extracting, Transforming and Loading (ETL) data between data systems / data warehouses. Experience in ETL change data capture methodologies and techniques, ETL data quality validation for mission critical data migrations.

- Experience in managing and deploying code to cloud services, including Azure DevOps experience.

- Working knowledge of Linux, Visual Studio.

- Hand on experience with deployment and monitoring of machine learning models.

- Hand on experience with Microsoft Power Suite Power Apps and Power BI.

- Knowledge in statistics and data mining.

- Strong Agile project execution experience with proven ability to prioritize and manage time.

- Display teamwork and integrity with excellent interpersonal skills and the ability to interact with internal and external stakeholders, and directly influence them in a positive and effective manner.

- Ability to work independently and in a cross-functional team environment and be comfortable in a dynamic, high growth environment.

- Excellent organizational skills and attention to detail with ability to meet tight deadlines.

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