Senior Data Engineer

Division:  Information Technology
Job location: Remote (Alberta, Saskatchewan, Manitoba, Ontario, Quebec
Hours: 40 hours per week, Monday to Friday with flexibility to work across national and international time zones

Employment type: Full-time Permanent

A little about us

Hi, we’re Aurora Cannabis, and we’re so excited to meet you!

Aurora Cannabis is a leader in the rapidly evolving global cannabis industry, serving both medical and consumer markets worldwide. Dedicated to helping people improve their lives, Aurora is driven by science and innovation, with a focus on providing premium medical cannabis products produced with the highest standards. We proudly serve both patients and consumers across Canada, Europe, Australia and New Zealand. Our global brand portfolio includes Aurora, Being, CanniMed, CraftPlant, Daily Special, Drift, Greybeard, IndiMed, MedReleaf, Pedanios, San Raf, Tasty’s, Whistler Cannabis Co, and WMMC. Aurora's brands continue to break through as industry leaders in the medical, wellness and adult recreational markets wherever they are launched.

At Aurora, employees are at the heart of everything we do as we execute with excellence and agility. Whether in our manufacturing facilities, in our state-of-the-art research labs or supporting our global business development, or, within our corporate functions such as HR, operations, government affairs, and more – our diverse A-Team leads with expertise, passion and dedication every day. Together, we are opening the world to cannabis and making a meaningful impact for patients, consumers, our communities and our A-team. 

Job Summary

As the Senior Data Engineer, you will report to the Director, IT Business Intelligence & Analytics and be part of a broader Business Intelligence and Analytics team that consolidates data into our enterprise data warehouse and delivers reporting, advanced analytics, and data science services across the organization. The role will help generate actionable insights, enable data-driven decision-making, and promote innovation.

This role is responsible for maintaining and modernizing our cloud-based enterprise data warehouse. It requires advanced expertise in data orchestration and integration to ensure data is readily available for reporting and analysis.

As the Senior Data Engineer you will be involved in…

• Design, build, and maintain batch and near-real-time data pipelines to support enterprise data warehouse needs.
• Lead the development of end-to-end, best-in-class data integration solutions that enable enterprise reporting and analytics.
• Architect, design, and implement automated transactional data pipelines using Azure components such as Logic Apps, Power Apps, and Azure Functions.
• Automate and standardize existing data workflows, while proactively identifying and resolving data pipeline failures.
• Translate business data requirements into detailed technical designs and scalable pipeline architectures, with thorough documentation of processes and methodologies.
• Foster strong partnerships with business stakeholders to ensure solutions effectively address organizational needs.
• Support and enhance the existing data ecosystem, ensuring consistency and reliability in data delivery architecture across the product lifecycle.
• Collaborate closely with Master Data and Business Intelligence teams to streamline data acquisition processes and establish best practices for data extraction, modelling, consumption, and governance.

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

• Degree in computer science, Software Engineering, Information Technology, or a related field—or an equivalent combination of education and experience.
• Minimum of 5 years of experience in data analytics, including the development and maintenance of data warehouses, supporting advanced analytics, and deploying analytical models.
• Additional certifications or nanodegrees in Artificial Intelligence, Machine Learning, or Data Science are considered an asset.
• Deep expertise in cloud technologies and infrastructure for data integration and processing, including Microsoft Azure Data Lake, Azure Functions, Data Factory, and Databricks.
• Extensive experience in data warehousing, data integration, schema design, and data modelling.
• Advanced proficiency in SQL, with the ability to write and optimize complex queries.
• Strong programming and scripting skills in Python and C#.
• Hands-on experience with Visual Studio development environments.

Bonus points if you have…

• Familiarity with source code management tools such as Azure DevOps and GitHub (considered an asset).
• Understanding of CI/CD pipelines and best practices for automated deployment (considered an asset).
• Experience working with ERP and CRM systems (strongly preferred).
• Knowledge of statistics and data mining techniques (considered an asset).
• Familiarity with Azure Synapse Analytics (considered an asset).
• Proven track record of successfully delivering large-scale data projects involving cross-functional business stakeholders.
• Excellent organizational skills with the ability to manage multiple tasks, deadlines, and priorities effectively.

Why you’ll love working at Aurora

• Flexibility: you will enjoy a flexible work environment that is the perfect blend of work and fun! You will be empowered to achieve work-life balance with flexible hours, remote work options, meeting-free-Friday-afternoons and more!  

• Total Rewards: we will motivate you to go above and beyond with a competitive salary, professional development opportunities, company SWAG, team activities and modern technology. 

• 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 cannabis.

Next steps

Apply today by submitting your resume through our website. You can expect your application to be reviewed by our Talent Acquisition Team and we will contact you if we see a fit via email.

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? Share this posting with your network while subscribing to our Talent Community to learn more about upcoming opportunities (hot tip: if you are an Aurora employee, take advantage of the employee referral program by sharing this posting with someone in your network! If they are the successful candidate, you may be eligible for 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!

#LI-REMOTE
#LI-MC1