Senior Technical Specialist
HCL Technologies Limited
Posted Nov 16, 2026
Apply by Dec 21, 2026
- Other
Job description
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. 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.