Senior Data Engineer

Microart Services Inc. Toronto, ON 2022-01-29
Apply Now Copy link

About Us The Ontario Cannabis Store provides safe, responsible access to recreational cannabis for adults 19 and older. We operate the sole legal online store for recreational cannabis in Ontario and is now the provincial wholesaler of cannabis for 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 looking for a Senior Data Engineer to join Data Science team. As Senior Data Engineer, you will be responsible to optimize and build our data pipelines and data architecture within our integrated systems to power, advanced analysis, analytical reports, and dashboards for our internal clients. You will contribute towards the design and implementation of data warehouses.As a Senior Data Engineer, you will use your strong collaboration skills to work cross-functionally to translate business requirements into technical designs. This is an exciting opportunity to use your 5+ years of experience with data engineering to provide guidance and insights into data initiatives/requests, based upon your knowledge of industry best practices and methodology to provide robust solutions. About Your Day Build and maintain batch and real-time data pipelinesDevelop data integration solutions to integrate a variety of data sets from disparate sources into a data model to support 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 Build predictive and prescriptive data models to enable deeper and better data insightsAutomate pipelines and troubleshoot data failuresMaintain existing Azure Eco-system and ensure consistency in data delivery architecture throughout the project life cycle.Architect standard procedures for data storage, processing, and consumption using industry best practicesEnsure adherence to architectural guidelines and principles Partner closely with data analysts and cross-functional teams to translate business requirements into detailed technical designsImprove and automate, where possible, the data pipelines used for data analytics, business data flows, and solution integrationTranslate data requirements into detailed designs and pipeline architecture, ensuring proper documentation of methodologyCreate technical and functional documentation for Data Science and other business teams Drive thought leadership and define best practices around data extraction, modeling, consumption, and governanceAbout You Bachelor's degree in Computer Science/Software Engineering/Information Technology or a related field of study, or equivalent level of education and experienceAzure Data Engineer or Azure Solution Architect certification would be an asset5+ years of experience with data analytics, developing and maintaining data warehouses to feed advanced analytics and deploying analytical models within an organizationExpertise in Azure data engineering, including Automated Data Pipelines, LogicApps, Azure functions, Azure Data Factory, Azure Data Lake, Azure data monitoring and ETL jobsStrong experience with data warehousing, data integration, schema design and data modeling Advanced skill with Excel, SQL and one of the scripting languages (Python or R)Good knowledge of Power BI and/or other reporting tools would be an asset Excellent analytical, troubleshooting, research, and problem-solving skillsAbility to align with rapid business changes: new requirements, evolving goals and strategies and technological advancementsExperience with Azure Synapse would be an assetAbility to work independently with business users under minimal supervision in a highly collaborative and agile work environmentExcellent written and verbal communication skills Remote WorkThis position offers a Hybrid work schedule. When the office reopens, you will be required to be in the office 1-2 days 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) Job DetailsCity: Toronto, ON Employment Type: Full-Time PermanentRequired Travel: Rare, usually within GTA Application Deadline: January 12, 2022We are committed to providing an accessible, equitable and inclusive candidate and employee experience. We provide reasonable accommodation throughout the recruitment process and in employment. If you require an accommodation, please let us know, we will work with you to meet your needs