Job Description DBT & Snowflake Engineer

Position

DBT & Snowflake Engineer / Analytics Engineer

Role Overview

We are looking for an experienced DBT & Snowflake Engineer to design, develop, and maintain scalable data transformation pipelines and analytical data models using dbt and Snowflake.

The candidate will work closely with Data Engineering, Data Architecture, BI, QA, and Product teams to build high-quality, scalable, and performant data solutions that support enterprise reporting and analytics.

Key Responsibilities
- Develop and maintain dbt models on the Snowflake data platform.
- Design scalable staging, intermediate, and data mart models using dbt.
- Develop complex and optimized SQL queries in Snowflake.
- Implement incremental models, snapshots, macros, seeds, sources, and dbt tests.
- Design and implement dimensional data models, including fact and dimension tables.
- Optimize Snowflake queries, warehouses, and data models for performance and cost efficiency.
- Implement data quality checks, reconciliation, and validation using dbt tests and Snowflake.




- Establish and maintain data lineage, documentation, and model dependencies.
- Troubleshoot data discrepancies across source systems, Snowflake, dbt transformations, and reporting datasets.
- Work with Data Engineers and Architects to define appropriate ELT and data transformation strategies.
- Support integration of Snowflake data models with Power BI and other BI platforms.
- Implement and maintain CI/CD processes for dbt using Git/GitHub/Azure DevOps.
- Participate in code reviews and ensure adherence to SQL, dbt, Snowflake, and data engineering best practices.
- Monitor production transformations and proactively resolve data pipeline and data-quality issues.
- Create and maintain technical documentation, data dictionaries, and runbooks.

Mandatory Technical Skills

DBT
- Solid hands-on experience with dbt Core or dbt Cloud.
- Experience with dbt models, sources, tests, snapshots, macros, seeds,

📌 DBT & Snowflake Engineer (Chennai)
🏢 ALTIMETRIK
📍 Chennai