Data Engineer

Job DescriptionAlimentation Couche-Tard Inc., (ACT) is a global Fortune 200 company. A leader in the convenience store and fuel space with over 17,000 stores in 31 countries, serving more than 6 million customers each day It is an exciting time to be a part of the growing Data Engineering team at Circle K. We are driving a well-supported cloud-first strategy to unlock the power of data across the company and help teams to discover, value and act on insights from data across the globe. With our strong data pipeline, this position will play a key role partnering with our Technical Development stakeholders to enable analytics for long term success.About the roleWe are looking for a Data Engineer with a collaborative, "can-do" attitude who is committed & strives with determination and motivation to make their team successful. A Data Engineer who has experience implementing technical solutions as part of a greater data transformation strategy. This role is responsible for hands on sourcing, manipulation, and delivery of data from enterprise business systems to data lake and data warehouse. This role will help drive Circle K's next phase in the digital journey by transforming data to achieve actionable business outcomes.Roles and ResponsibilitiesCollaborate with business stakeholders and other technical team members to acquire and migrate data sources that are most relevant to business needs and goalsDemonstrate technical and domain knowledge of relational and non-relational databases, Data Warehouses, Data lakes among other structured and unstructured storage optionsDetermine solutions that are best suited to develop a pipeline for a particular data sourceDevelop data flow pipelines to extract, transform, and load data from various data sources in various forms, including custom ETL pipelines that enable model and product developmentEfficient in ELT/ETL development using Azure cloud services and Snowflake, including Testing and operational support (RCA, Monitoring, Maintenance)Work with modern data platforms including Snowflake to develop, test, and operationalize data pipelines for scalable analytics deliverProvide clear documentation for delivered solutions and processes, integrating documentation with the appropriate corporate stakeholdersIdentify and implement internal process improvements for data management (automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability)Stay current with and adopt new tools and applications to ensure high quality and efficient solutionsBuild cross-platform data strategy to aggregate multiple sources and process development datasetsProactive in stakeholder communication, mentor/guide junior resources by doing regular KT/reverse KT and help them in identifying production bugs/issues if needed and provide resolution recommendationJob RequirementsBachelor's degree in Computer Engineering, Computer Science or related discipline, Master's Degree preferred3+ years of ETL design, development, and performance tuning using ETL tools such as SSIS/ADF in a multi-dimensional Data Warehousing environment3+ years of experience with setting up and operating data pipelines using Python or SQL3+ years of advanced SQL Programming: PL/SQL, T-SQL3+ years of experience working with Snowflake, including Snowflake SQL, data modeling, and performance optimizationStrong hands-on experience with cloud data platforms such as Azure Synapse and Snowflake for building data pipelines and analytics workloads3+ years of strong and extensive hands-on experience in Azure, preferably data heavy / analytics applications leveraging relational and NoSQL databases, Data Warehouse and Big Data3+ years of experience with Azure Data Factory, Azure Synapse Analytics, Azure Analysis Services, Azure Databricks, Blob Storage, Databricks/Spark, Azure SQL DW/Synapse, and Azure functions3+ years of experience in defining and enabling data quality standards for auditing, and monitoringStrong analytical abilities and a strong intellectual curiosity.In-depth knowledge of relational database design, data warehousing and dimensional data modeling conceptsUnderstanding of REST and good API designExperience working with Apache Iceberg, Delta tables and distributed computing frameworksStrong collaboration, teamwork skills, excellent written and verbal communications skillsSelf-starter and motivated with ability to work in a fast-paced development environmentAgile experience highly desirableProficiency in the development environment, including IDE, database server, GIT, Continuous Integration, unit-testing tool, and defect management toolsPreferred SkillsStrong Knowledge of Data Engineering concepts (Data pipelines creation, Data Warehousing, Data Marts/Cubes, Data Reconciliation and Audit, Data Management)Strong working knowledge of Snowflake, including warehouse management, Snowflake SQL, and data sharing techniquesExperience building pipelines that source from or deliver data into Snowflake in combination with tools like ADF and DatabricksWorking Knowledge of Dev-Ops processes (CI/CD), Git/Jenkins version control tool, Master Data Management (MDM) and Data Quality toolsStrong Experience in ETL/ELT development, QA and operation/support process (RCA of production issues, Code/Data Fix Strategy, Monitoring and maintenance)Hands on experience in Databases like (Azure SQL DB, MySQL/, Cosmos DB etc.), File system (Blob Storage), Python/Unix shell ScriptingADF, Databricks and Azure certification is a plusTechnologies we use: Databricks, Azure SQL DW/Synapse, Azure Tabular, Azure Data Factory, Azure Functions, Azure Containers, Docker, DevOps, Python, PySpark, Scripting (Powershell, Bash), Git, Terraform, Power BI, Snowflake#LI-DS1