Job Summary

Job Title: Data Engineer – DBT & BigQuery

Role Summary

We are looking for an experienced Data Engineer with strong expertise in DBT (Data Build Tool), Google BigQuery, SQL, and cloud data engineering. The role will focus on building scalable data transformation pipelines, developing analytical data models, implementing data-quality controls, and optimizing BigQuery performance and cost.

Key Responsibilities

- Design, develop, and maintain data transformation pipelines using DBT.
- Develop scalable data models and analytical datasets in Google BigQuery.
- Write and optimize complex SQL queries for large-volume datasets.
- Build DBT models using staging, intermediate, and mart layers.
- Implement incremental models, snapshots, seeds, macros, tests, hooks, and reusable DBT packages.
- Develop dimensional models using Star/Snowflake schemas, fact tables, and dimensions.
- Implement automated data-quality and validation tests using DBT.
- Optimize BigQuery workloads through partitioning, clustering, query optimization, and efficient data-model design.
- Build and maintain CI/CD pipelines for DBT deployments using Git-based development practices.
- Troubleshoot data-pipeline failures and resolve data-quality and performance issues.
- Maintain technical documentation, data lineage, model descriptions, and business definitions.
- Collaborate with data analysts, BI teams, data scientists, and business stakeholders to translate requirements into scalable data solutions.
- Follow enterprise data governance, security, access-control, and engineering standards.

Key Responsibilities

Job Title: Data Engineer – DBT & BigQuery

Role Summary

We are looking for an experienced Data Engineer with strong expertise in DBT (Data Build Tool), Google BigQuery, SQL, and cloud data engineering. The role will focus on building scalable data transformation pipelines, developing analytical data models, implementing data-quality controls, and optimizing BigQuery performance and cost.

Key Responsibilities

- Design, develop, and maintain data transformation pipelines using DBT.
- Develop scalable data models and analytical datasets in Google BigQuery.
- Write and optimize complex SQL queries for large-volume datasets.
- Build DBT models using staging, intermediate, and mart layers.




- Implement incremental models, snapshots, seeds, macros, tests, hooks, and reusable DBT packages.
- Develop dimensional models using Star/Snowflake schemas, fact tables, and dimensions.
- Implement automated data-quality and validation tests using DBT.
- Optimize BigQuery workloads through partitioning, clustering, query optimization, and efficient data-model design.
- Build and maintain CI/CD pipelines for DBT deployments using Git-based development practices.
- Troubleshoot data-pipeline failures and resolve data-quality and performance issues.
- Maintain technical documentation, data lineage, model descriptions, and business definitions.
- Collaborate with data analysts, BI teams, data scientists, and business stakeholders to translate requirements into scalable data solutions.
- Follow enterprise data governance, security, access-control, and engineering standards.

Skill Requirements

Job Title: Data Engineer – DBT & BigQuery

Role Summary

We are looking for an experienced Data Engineer with strong expertise in DBT (Data Build Tool), Google BigQuery, SQL, and cloud data engineering. The role will focus on building scalable data transformation pipelines, developing analytical data models, implementing data-quality controls, and optimizing BigQuery performance and cost.

Key Responsibilities

- Design, develop, and maintain data transformation pipelines using DBT.
- Develop scalable data models and analytical datasets in Google BigQuery.
- Write and optimize complex SQL queries for large-volume datasets.
- Build DBT models using staging, intermediate, and mart layers.
- Implement incremental models, snapshots, seeds, macros, tests, hooks, and reusable DBT packages.
- Develop dimensional models using Star/Snowflake schemas, fact tables, and dimensions.
- Implement automated data-quality and validation tests using DBT.
- Optimize BigQuery workloads through partitioning, clustering, query optimization,



and efficient data-model design.
- Build and maintain CI/CD pipelines for DBT deployments using Git-based development practices.
- Troubleshoot data-pipeline failures and resolve data-quality and performance issues.
- Maintain technical documentation, data lineage, model descriptions, and business definitions.
- Collaborate with data analysts, BI teams, data scientists, and business stakeholders to translate requirements into scalable data solutions.
- Follow enterprise data governance, security, access-control, and engineering standards.

Must Have Skill

Data Build Tool (DBT),GCP BigQuery

Good to Have Skill

Other Requirements

Job Title: Data Engineer – DBT & BigQuery

Role Summary

We are looking for an experienced Data Engineer with solid expertise in DBT (Data Build Tool), Google BigQuery, SQL, and cloud data engineering. The role will focus on building scalable data transformation pipelines, developing analytical data models, implementing data-quality controls, and optimizing BigQuery performance and cost.

Key Responsibilities

- Design, develop, and maintain data transformation pipelines using DBT.
- Develop scalable data models and analytical datasets in Google BigQuery.
- Write and optimize complex SQL queries for large-volume datasets.
- Build DBT models using staging, intermediate, and mart layers.
- Implement incremental models, snapshots, seeds, macros, tests, hooks, and reusable DBT packages.
- Develop dimensional models using Star/Snowflake schemas, fact tables, and dimensions.
- Implement automated data-quality and validation tests using DBT.
- Optimize BigQuery workloads through partitioning, clustering, query optimization, and efficient data-model design.
- Build and maintain CI/CD pipelines for DBT deployments using Git-based development practices.
- Troubleshoot data-pipeline failures and resolve data-quality and performance issues.
- Maintain technical documentation, data lineage, model descriptions, and business definitions.
- Collaborate with data analysts, BI teams, data scientists, and business stakeholders to translate requirements into scalable data solutions.
- Follow enterprise data governance, security, access-control, and engineering standards.

📌 Senior Technical Lead (Bengaluru)
🏢 HCLTech
📍 Bengaluru