Data Integration Lead

HEXAWARE•Canada,

14h

About The Position

We are seeking a skilled Sr. Data Modeler to join our team and contribute to the design and implementation of scalable and efficient data models. The ideal candidate will have experience with Data Vault techniques, proficiency in Cloud Azure, and good to have working knowledge with Databricks.

Requirements

Bachelor’s degree in Computer Science, Information Systems, or a related field (Master’s degree preferred).
Proven experience in data modeling, with a strong focus on Data Vault techniques.
Proficiency in Cloud Azure services, including Azure Data Lake, Azure SQL Database, and Azure Synapse Analytics.
Understand/Knowledge with Databricks and its ecosystem.
Strong understanding of data warehousing concepts, Data Lake house, ETL processes, and data integration techniques.
Excellent analytical and problem-solving skills with attention to detail.
Strong communication and collaboration skills to work effectively with cross-functional teams.

Nice To Haves

Relevant certifications in Azure and Databricks are a plus.
Experience with additional cloud platforms (e.g., AWS, Google Cloud) is a plus.
Knowledge of data governance and data quality principles.
Experience with BI tools such as Power BI, Tableau, or Looker

Responsibilities

Design and develop data models using Data Vault methodologies to ensure robust, scalable, and flexible data architectures.
Create and maintain conceptual, logical, and physical data models to support business requirements.
Collaborate with stakeholders to understand data requirements and translate them into effective data models.
Implement best practices for data modeling, including normalization, denormalization, and data integration.
Utilize Data Vault techniques to build enterprise data lake and lake house and integrate disparate data sources.
Design and implement Hubs, Links, and Satellites to ensure comprehensive data capture and historical tracking.
Optimize data vault models for performance and scalability.
Design and deploy data models on Azure Data Services, including Azure SQL Database, Azure Data Lake, and Azure Synapse Analytics.
Ensure data security, compliance, and best practices in Azure environments.
Work closely with data engineers, data scientists, and business analysts to understand data needs and ensure data model alignment.
Provide technical guidance and support on data modeling best practices and Data Vault principles.
Document data models, data flows, and integration processes clearly and comprehensively.