Data Engineer

Division: IT

Job location: Remote (Canada)
Hours: 40 hours per week, Monday to Friday 

Employment type: Temporary (12-month contract)  
Salary:   $86,000 – $106,000

A little about us

Aurora is proud to be a global leader in the cannabis industry. With a smart strategy, unmatched talent and focus on our long-term success, we believe we have a bright future.

At Aurora, we’re passionate about helping patients improve their lives through high-quality premium medical cannabis under brands they can trust and rely on. Our products, available across Canada, Europe, Australia, and New Zealand, include leading brands like Pedanios, IndiMed, San Raf, Whistler, Greybeard and CraftPlant. 

Our diverse team works passionately across various roles, from manufacturing to corporate positions, and many more, united by our purpose: Opening the World to Cannabis. Enabled by science and empowered by people, for patients and consumers. We collaborate globally, embrace change with courage, stay agile, and treat everyone with compassion. We live our values daily, making a meaningful impact on patients, communities, and our A-Team.

Job Summary

Reporting to the Director, Business Intelligence & Analytics, the Data Engineer is responsible for the design, development, implementation, and maintenance of enterprise data integration and processing solutions. The position develops and supports data pipelines, data warehouse structures, and related data infrastructure used for business intelligence, reporting, and analytics.

The Data Engineer integrates data from multiple source systems, translates business and technical requirements into data solutions, and maintains processes and controls related to data quality, reliability, availability, and performance. The position works with business and technical stakeholders to support the operation, maintenance, and ongoing development of the organization’s data environment.  Interesting?  Here is a little more…
 

As a Data Engineer you will…

• • Design, develop, implement, and maintain scalable batch and near-real-time data pipelines that integrate data from enterprise applications, databases, cloud platforms, and other data sources.
  • Develop end-to-end data integration and processing solutions that support the organization’s data warehouse, reporting, business intelligence, and analytics requirements.
  • Design, develop, configure, and maintain data solutions using Microsoft Azure technologies and related components, including Data Factory, Data Lake, Databricks, Azure Functions, Logic Apps, and other applicable services.
  • Translate business and technical data requirements into detailed solution designs, data flows, pipeline architecture, transformation logic, and technical specifications.
  • Develop and implement automated processes for data ingestion, transformation, validation, monitoring, and delivery to improve reliability and operational efficiency.
  • Monitor data pipelines and integration processes, troubleshoot failures and data issues, perform root-cause analysis, and implement corrective and preventative solutions.
  • Implement data quality controls, validation processes, and reconciliation procedures to support the accuracy, completeness, consistency, and integrity of enterprise data.
  • Optimize data pipelines, queries, data models, and processing workflows to improve performance, scalability, reliability, and efficient use of computing resources.
  • Support the design and maintenance of data warehouse structures, data models, schemas, and related data architecture in accordance with organizational standards and business requirements.
  •  Apply organizational standards and practices related to data security, privacy, governance, access controls, retention, and the appropriate handling of organizational data.
  • Develop and maintain technical documentation, including data mappings, data lineage, transformation logic, pipeline designs, system configurations, operating procedures, and troubleshooting information.
  • Apply source control, testing, deployment, and CI/CD practices to support reliable and controlled development and release of data solutions.
  •  Collaborate with business stakeholders, analysts, application teams, and other technical resources to understand data needs, resolve issues, and deliver solutions that support organizational priorities.
  • Provide technical support for production data solutions and contribute to the continuous improvement, modernization, and standardization of the organization’s data environment.
  • Research and evaluate emerging data technologies, tools, and practices and recommend opportunities to improve the organization’s data engineering capabilities.
  • Perform other related duties as required.

You will be setup for success if you have…

• • Bachelor’s degree in Computer Science, Software Engineering, Information Technology, Data Science, or a related discipline, or an equivalent combination of education, training, and relevant experience.
  • Three to five years of progressively responsible experience in data engineering, data integration, data warehousing, or a closely related field, including experience designing, developing, implementing, and supporting enterprise data pipelines and data solutions.
  • Experience working with cloud-based data platforms, preferably Microsoft Azure, in a production environment.
  • Experience with Azure Synapse Analytics.
  • Experience with source code management and development tools such as Azure DevOps, GitHub, Git, and Visual Studio.
  • Experience implementing CI/CD processes for data solutions.
  • Experience integrating data from ERP, CRM, or other enterprise business systems.
  • Knowledge of statistical analysis, data mining, machine learning, or advanced analytics.
  • Relevant certification or additional education in cloud computing, data engineering, artificial intelligence, machine learning, or data science
  • Advanced knowledge of data engineering principles and practices, including data ingestion, transformation, integration, orchestration, processing, and delivery.
  • Strong knowledge of cloud-based data technologies and architecture, particularly Microsoft Azure services such as Azure Data Factory, Azure Data Lake, Databricks, Azure Functions, and related data services.
  • Strong knowledge of relational databases, SQL, data warehousing concepts, dimensional modelling, schema design, and data modelling techniques.
  • Proficiency in SQL, including the ability to develop and optimize complex queries, stored procedures, and data transformations.
  • Proficiency in a programming or scripting language used for data engineering, such as Python or C#.
  • Knowledge of ETL/ELT design patterns and techniques for integrating structured and semi-structured data from multiple source systems.
  • Knowledge of data quality, validation, reconciliation, metadata, and data lineage concepts and practices.
  • Knowledge of data security, privacy, governance, and access-control principles applicable to enterprise data environments.
  • Knowledge of software development lifecycle practices, including source control, testing, code review, deployment, and CI/CD.

Bonus points if you have…

• • Ability to analyze complex data and technical problems, identify root causes, evaluate alternatives, and develop effective and sustainable solutions.
  • Ability to translate business and data requirements into technical specifications, data models, and scalable data engineering solutions.
  • Ability to monitor and optimize data pipelines, queries, and processing workflows for performance, reliability, and scalability.
  • Ability to prepare and maintain clear and accurate technical documentation.
  • Strong analytical, problem-solving, organizational, and troubleshooting skills.
  • Strong verbal and written communication skills, with the ability to explain technical concepts to both technical and non-technical audiences.
  • Ability to establish and maintain effective working relationships and collaborate with business stakeholders, analysts, developers, vendors, and other technical teams.
  • Ability to manage multiple priorities and assignments in a changing environment while maintaining attention to detail and quality.

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. Apply today by submitting your resume through our website. You can expect your application to be reviewed by our Talent Acquisition Team and not an AI software/system.  We 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, Equity, Inclusion, Belonging and Accessibility

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.

We value the unique skills and experience each person brings to Aurora and are committed to creating and maintaining an accessible environment. We are committed to the requirements of the Accessibility for Ontarians with Disabilities Act so if you require accommodation during the hiring process, please let our Human Resources team know by contacting us at hr.services@auroramj.com

#LI-REMOTE

#LI-MC1