Data Architect

Job Description

Alimentation Couche-Tard Inc., (ACT) is a global Fortune 200 company. A leader in the convenience store and fuel space with over 16,700 stores in 31 countries, serving more than 9 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 role:

We are seeking a talented and experienced Data Architect to join our team. The Data Architect will be responsible for designing enterprise data management frameworks, ensuring data security and compliance, implementing data management processes, build data models and strategies to support various business needs and initiatives. The ideal candidate will have a strong background in data modeling principles, database design, and data management best practices.

Responsibilities:

• Collaborate with solution architect, data engineers, business stakeholders, business analysts, and DQ testers to ensure data management and data governance framework is defined as critical components.
• Design and develop data models using industry-standard modeling techniques and tools.
• Perform data profiling, data lineage and analysis to understand data quality, structure, and relationships.
• Optimize data models for performance, scalability, and usability by creating optimal data storage layer.
• Define and enforce data modeling standards, best practices, and guidelines.
• Participate in data governance initiatives to ensure compliance with data management policies and standards.
• Work closely with database administrators and developers to implement data models in relational and non-relational database systems.
• Conduct data model reviews and provide recommendations for improvements.
• Stay updated on emerging trends and technologies in data modeling and data management

Qualifications & Required Skills:

• Full-Time bachelor’s or master’s degree in engineering/technology, computer science, information technology, or related fields.
• 10+ years of total experience in data modeling and database design and experience in Retail domain will be added advantage.
• 8+ years of experience in data engineering development and support.
• 3+ years of experience in leading technical team of data engineers and BI engineers  
• Proficiency in data modeling tools such as Erwin, ER/Studio, or similar tools.
• Strong knowledge of Azure cloud infrastructure and development using SQL/Python/PySpark using ADF, Synapse and Databricks.
• Hands-on experience with Azure Data Factory, Azure Synapse Analytics, Azure Analysis Services, Azure Databricks, Blob Storage, Python/PySpark, Logic Apps, Key Vault, and Azure functions.
• Strong communication, interpersonal, collaboration skills along with leadership capabilities.
• Ability to work effectively in a fast-paced, dynamic environment as cloud SME.
• Act as single point of contact for all kinds of data management related queries to make data decisions.
• Design and manage centralized, end-to-end data architecture solutions, such as- Data model designs, Database development standards, Implementation and management of data warehouses, Data analytics systems.
• Conduct continuous audits of data management system performance and refine where necessary.
• Identify bottlenecks, optimize queries, and implement caching mechanisms to enhance data processing speed.
• Work to integrate disparate data sources, including internal databases and external application programming interfaces (APIs), enabling organizations to derive insights from a holistic view of the data.
• Ensure data privacy measures comply with regulatory standards.

Preferred

• Azure Data Factory (ADF), Databricks certification is a plus.
• Data Architect or Azure cloud Solution Architect certification is a plus.

Technologies we use: Azure Data Factory, Databricks, Azure Synapse, Azure Tabular, Azure Functions, Logic Apps, Key Vault, DevOps, Python, PySpark, Scripting (PowerShell, Bash), Git, Terraform, Power BI, Snowflake