Pitch N Hire
Software Development Contract On-site

Data Vault & DBT Engineer.

Experienced Data Vault & DBT Engineer with expertise in Snowflake and data transformation frameworks. Able to design scalable data solutions and optimize data workflows in a cloud-native environment.

Experience

5–6 yrs

Location

Chennai

Tamil Nadu-35, India


The Brief

TITLE

Data Vault & DBT Engineer

TEAM

Software Development

TYPE

Contract

POSTED

Jun 2, 2026

JOB ID

019e88de

Data Vault 2.0 Dbt Engineer Elt/etl Frameworks Snowflake

Key Responsibilities:
Data Modeling & Architecture :

- Design and implement enterprise-scale Data Vault 2.0 models, including Hubs, Links, Satellites, and Business Vault structures.
- Apply Enterprise Data Modeling (EDM) principles to support scalable, maintainable, and auditable data platforms.
- Develop and maintain logical and physical data models aligned with business and analytics requirements.

Snowflake Engineering:
- Design, develop, and optimize data solutions within Snowflake.
- Implement performance tuning, query optimization, clustering strategies, and cost-efficient data storage solutions.
- Support scalable cloud-based data warehouse architectures and analytics environments.

DBT Development:
- Build and maintain modular, reusable data transformation frameworks using DBT (Data Build Tool).
- Develop data models, macros, tests, documentation, and deployment workflows.
- Implement best practices for data quality, lineage, testing, and maintainability.

Data Engineering & Orchestration:
- Develop and support scalable ELT/ETL pipelines for enterprise data integration.
- Work with orchestration platforms such as Apache Airflow to automate and manage data workflows.
- Collaborate with upstream and downstream system teams to ensure reliable data delivery and processing.

Required Skills & Experience:

-Strong hands-on experience with Data Vault 2.0 modeling methodologies and Enterprise Data Modeling concepts.
- Deep expertise in Snowflake, including data warehousing, performance optimization, and cloud-native architecture.
- Proven experience developing data transformation solutions using DBT.
- Strong understanding of ELT/ETL frameworks, data integration patterns, and pipeline development.
- Experience with workflow orchestration tools such as Apache Airflow.
- Advanced SQL development and performance tuning skills.
- Strong understanding of modern data warehousing concepts and best practices.
- Excellent analytical, troubleshooting, and problem-solving abilities.
- Strong communication, collaboration, and stakeholder engagement skills.

Preferred Qualifications:
- Experience supporting enterprise-scale analytics and reporting platforms.
- Familiarity with CI/CD practices and Git-based development workflows.
- Exposure to cloud-native data engineering platforms and modern data architecture patterns.
- Experience working in Agile delivery environments.

About the company

Appsierra Group

appsierra.com

Our clients are at the centre of everything we do at Appsierra. We were built on the belief that in order to be exceptional at something, you must be incredibly focused. That is why we are committed to providing our customers with the technology-enabled solutions they require to succeed in today's digital economy. Simply put, we help our customers accelerate what matters to them by leveraging our agile engineering skills to deliver human-centric products to market at lightning speed.

We embrace the four superpowers of technology because we were born in the digital age, allowing our customers to not only better their present performance but also rethink their business in whole new ways. Appsierra , headquartered in Noida, India employs extraordinary people and is trusted by hundreds of Fortune companies.