Data Architect

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

Couche-Tard Inc.

Qualifications & Required Skills:

 Full-Time bachelors or masters 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