data engineer Toronto
Job description
About Us
The Ontario Cannabis Store provides safe, responsible access to recreational cannabis for adults 19 and older. We operate the provincial online store for recreational cannabis in Ontario and are the exclusive provincial wholesaler to authorized private retail stores.
Working at the OCS is a unique opportunity to be part of an agile start-up in a ground-breaking new industry. We’re a diverse team passionate about delivering a great customer experience, working together with mutual respect, and building value out of our differences. We’re an inclusive organization that understands that delivering great results comes out of ensuring every voice is heard.
About the Role
We are recruiting for a Data Engineer to join our Data Engineering team. The Data Engineer optimizes and builds data pipelines and data architecture to power advanced analysis, analytical reports, and dashboards for internal clients. The Data Engineer is responsible for the design and implementation of data warehouses.
In this role, you will work closely with a team of data engineers to translate business requirements into technical designs. As a Data Engineer, you will combine raw information from different sources to create consistent and machine-readable formats. In this role, you will develop and test architectures that enable data extraction and transformation for predictive or prescriptive modeling.
This is an exciting opportunity to leverage your 3+ years of experience with data analytics, and data warehouses to feed advanced analytics and deploy analytical models within the OCS.
About Your Day
- Build and maintain batch and real-time data pipelines
- Develop data integration solutions to integrate a variety of data sets from disparate sources into a data model to support Business Intelligence (BI) and analytical requirements
- Design and develop automated transactional data processing pipelines, LogicApps, Azure functions and other Azure components
- Solution complex data engineering problems to directly support and deliver strategic data initiatives
- Automate pipelines and troubleshoot data failures
- Architect standard procedures for data storage, processing, and consumption using industry best practices
- Translate data requirements into detailed designs and pipeline architecture, ensuring proper documentation of methodology
- Partner closely with data analysts and cross-functional teams to translate business requirements into detailed technical designs
- Maintain existing Azure Eco-system and ensure consistency in data delivery architecture throughout the project life cycle
- Move data between systems by accessing data from many different technologies, and then apply rules to “transform” and cleanse the data so that it is ready for analysis
- Work with different layers of modern data platform and add and modify data sets based on the business requirements
- Create technical and functional documentation for Data Science and other business teams
- Bachelor's degree in Computer Science/Software Engineering/Information Technology or a related field of study, or equivalet level of education and experience
- 3+ years of experience with data analytics, developing and maintaining data warehouses to feed advanced analytics and deploying analytical models within an organization
- Experience with Azure Synapse would be mandatory
- Expertise in Azure data engineering, including Automated Data Pipelines, LogicApps, Azure functions, Azure Data Factory, Azure Data Lake, Azure data monitoring and ETL jobs
- Strong experience with data warehousing, data integration, schema design and data modeling
- Good knowledge of Power BI and/or other reporting tools would be an asset
- Strong analytical skills and the ability to combine data from different sources. Data engineer skills also include familiarity with several programming languages and knowledge of learning machine methods.
- Excellent analytical, troubleshooting, research, and problem-solving skills
- Ability to align with rapid business changes: new requirements, evolving goals and strategies and technological advancements
- Ability to work independently with business users under minimal supervision in a highly collaborative and agile work environment
- Advanced skill with Excel, SQL and one of the scripting languages (Python)
- Excellent written and verbal communication skills
- This position offers a Hybrid work schedule. You will be required to be in the office a minimum of 1 day each week, with the ability to work from home for the remaining workdays (subject to specific business needs requiring office attendance).
- When working from home, a reliable internet connection is required. Remote work is supported with cloud-based applications and collaboration tools (i.e., MS Teams)
- City: Toronto, ON
- Employment Type: Full-Time Permanent
- Required Travel: None
About Ontario Cannabis Store
Revenue: Unknown / Non-Applicable
Size: 201 to 500 Employees
Type: Government
Website: www.ocs.ca
