Role Overview :
We are looking for a skilled Data Engineer with deep expertise in the Data Vault 2.0 modeling framework and strong capabilities in SQL, Python, and DBT to develop scalable, efficient data pipelines.
The ideal candidate will play a key role in designing, building, and maintaining data architectures that empower data analytics and business intelligence teams.
Key Responsibilities :
- Design and develop robust data pipelines using SQL, Python, and DBT, ensuring clean, transformed, and reliable data delivery.
- Implement and optimize Data Vault 2.0 modeling techniques alongside building Star Schemas to support downstream analytics and reporting.
- Build and maintain DBT models that align with Data Vault 2.0 principles and scalable data architectures.
- Work extensively with Snowflake data warehousing platform to ensure data storage and querying efficiency.
- Apply CI / CD best practices for data pipelines to enable continuous integration and deployment, enhancing reliability and agility.
- Leverage version control tools like GitHub and productivity enhancements such as GitHub Copilot for efficient code development and collaboration.
- Collaborate with data architects, analysts, and business stakeholders to gather requirements and translate them into technical specifications.
- Monitor and troubleshoot data workflows to ensure pipeline performance, data quality, and system availability.
Required Skills and Qualifications :
Strong command of SQL and Python programming languages for data manipulation and pipeline development.Hands-on experience and expert understanding of Data Vault 2.0 modeling principles and best practices.Proficiency in DBT for data pipeline orchestrations and transformations.Experience working with Snowflake or similar cloud-native data warehouses with a focus on scalable architectures.Familiarity with CI / CD pipelines, automation tools, and version control (GitHub, GitHub Copilot).Ability to design and implement scalable workflows that support high data volumes and complex transformation logic.Strong problem-solving skills and keen attention to data integrity and quality.Recommended Experience :
4 to 7 years of experience in data engineering or related data roles, with at least 2 years specializing in Data Vault 2.0 and modern cloud data platforms(ref : hirist.tech)