Job Summary

- Design and implement scalable data architectures and ELT pipelines on Snowflake.
- Develop, test and maintain modular DBT models, macros, tests and documentation, following analytics engineering best practices.
- Write and optimise complex T-SQL queries, stored procedures and views in MS SQL Server, and lead migration of legacy workloads to Snowflake.
- Build Python-based automation, data ingestion, transformation and orchestration frameworks.
- Define data modelling standards (dimensional, Data Vault, star/snowflake schemas) and ensure data quality, lineage and governance.
- Tune performance and manage cost in Snowflake (warehouse sizing, clustering, query optimisation, resource monitors).
- Implement CI/CD, version control (Git) and environment promotion for DBT and data pipelines.
- Collaborate with business stakeholders, analysts and architects to translate requirements into technical solutions.
- Conduct code reviews, set engineering standards and mentor junior and mid-level engineers.
- Troubleshoot production issues and ensure SLA adherence for data delivery.

Key Responsibilities

- Design and implement scalable data architectures and ELT pipelines on Snowflake.
- Develop, test and maintain modular DBT models, macros, tests and documentation, following analytics engineering best practices.
- Write and optimise complex T-SQL queries, stored procedures and views in MS SQL Server, and lead migration of legacy workloads to Snowflake.
- Build Python-based automation, data ingestion, transformation and orchestration frameworks.
- Define data modelling standards (dimensional, Data Vault, star/snowflake schemas) and ensure data quality,



lineage and governance.
- Tune performance and manage cost in Snowflake (warehouse sizing, clustering, query optimisation, resource monitors).
- Implement CI/CD, version control (Git) and environment promotion for DBT and data pipelines.
- Collaborate with business stakeholders, analysts and architects to translate requirements into technical solutions.
- Conduct code reviews, set engineering standards and mentor junior and mid-level engineers.
- Troubleshoot production issues and ensure SLA adherence for data delivery.

Skill Requirements

- Design and implement scalable data architectures and ELT pipelines on Snowflake.
- Develop, test and maintain modular DBT models, macros, tests and documentation, following analytics engineering best practices.
- Write and optimise complex T-SQL queries, stored procedures and views in MS SQL Server, and lead migration of legacy workloads to Snowflake.
- Build Python-based automation, data ingestion, transformation and orchestration frameworks.
- Define data modelling standards (dimensional, Data Vault, star/snowflake schemas) and ensure data quality, lineage and governance.
- Tune performance and manage cost in Snowflake (warehouse sizing, clustering, query optimisation, resource monitors).
- Implement CI/CD,



version control (Git) and environment promotion for DBT and data pipelines.
- Collaborate with business stakeholders, analysts and architects to translate requirements into technical solutions.
- Conduct code reviews, set engineering standards and mentor junior and mid-level engineers.
- Troubleshoot production issues and ensure SLA adherence for data delivery.

Must Have Skill

Data Build Tool (DBT),MS SQL,Python,Snowflake

Valuable to Have Skill

Other Requirements

- Design and implement scalable data architectures and ELT pipelines on Snowflake.
- Develop, test and maintain modular DBT models, macros, tests and documentation, following analytics engineering best practices.
- Write and optimise complex T-SQL queries, stored procedures and views in MS SQL Server, and lead migration of legacy workloads to Snowflake.
- Build Python-based automation, data ingestion, transformation and orchestration frameworks.
- Define data modelling standards (dimensional, Data Vault, star/snowflake schemas) and ensure data quality, lineage and governance.
- Tune performance and manage cost in Snowflake (warehouse sizing, clustering, query optimisation, resource monitors).
- Implement CI/CD, version control (Git) and environment promotion for DBT and data pipelines.
- Collaborate with business stakeholders, analysts and architects to translate requirements into technical solutions.
- Conduct code reviews, set engineering standards and mentor junior and mid-level engineers.
- Troubleshoot production issues and ensure SLA adherence for data delivery.

📌 Senior Technical Specialist (Chennai)
🏢 HCLTech
📍 Chennai