Data Engineer (Snowflake, DBT, SQL)

VDart Software Services; Hyderabad, Pune District, Bengaluru; Hybrid; INR 1,000,000 - 2,000,000; Full time

Job summary

VDart Software Services is seeking a data engineering professional with strong SQL, DW concepts, and hands-on experience in Data Vault Modeling (DV 2.0). The role focuses on Snowflake data platforms, ETL/ELT pipelines, and robust data governance.

You will design scalable data vault architectures, optimize complex queries, and collaborate across stakeholders to deliver enterprise data solutions in a cloud environment.

Qualifications

• Proficient in SQL and data modeling for warehousing environments.
• Hands-on experience with Data Vault 2.0 modeling and design patterns.
• Strong knowledge of Snowflake and cloud data platforms.
• Experience building scalable data pipelines with ETL/ELT processes.
• Familiarity with DBT and data integration best practices.

Responsibilities

• Design and implement Data Vault architecture for enterprise DW solutions.
• Develop and optimize complex SQL queries, procedures, and data pipelines.
• Build and maintain data ingestion, transformation, and integration processes in Snowflake.
• Create and manage data models to support reporting and analytics requirements.
• Ensure data quality, integrity, security, and governance standards are maintained.
• Collaborate with stakeholders, architects, and dev teams to deliver scalable data solutions.
• Monitor and optimize data warehouse performance and storage utilization.

Skills

SQL

Data Vault Modeling

ETL/ELT

Data Warehousing concepts

Agile/Scrum

Tools

Snowflake

DBT

AWS/Azure/GCP

Job description

Role & responsibilities

• Strong experience in Data Vault Modeling (DV 2.0).
• Expertise in SQL and performance tuning.
• Hands-on experience with Snowflake Data Platform.
• Strong knowledge of Data Warehousing concepts and ETL/ELT processes.
• Experience in Data Modeling (Conceptual, Logical, and Physical models).
• Knowledge of building scalable data pipelines and data integration solutions.
• Experience with cloud platforms such as AWS, Azure, or GCP is an added advantage.

Understanding of Agile/Scrum methodologies

• Design and implement Data Vault architecture for enterprise data warehousing solutions.
• Develop and optimize complex SQL queries, stored procedures, and data pipelines.
• Build and maintain data ingestion, transformation, and integration processes in Snowflake.
• Create and manage data models to support reporting, analytics, and business intelligence requirements.
• Ensure data quality, integrity, security, and governance standards are maintained.
• Collaborate with business stakeholders, architects, and development teams to deliver scalable data solutions.
• Monitor and optimize data warehouse performance and storage utilization.

Preferred candidate profile

Strong experience in SQL, DBT and Snowflake