Senior Technical Specialist
India
Apply now
Job Description
Senior Technical Specialist
Chennai, Tamil Nadu

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.
Apply now
Information at a Glance

Why HCLTech?

At HCLTech, you'll supercharge your potential. You'll find your career. And you'll find your spark. All at a place that knows that helping its customers stay on top starts by putting its people first.

HCLTech is a global technology company, home to more than 230,000 people across 60 countries, delivering industry-leading capabilities centered around digital, engineering, cloud and AI, powered by a broad portfolio of technology services and products. We work with clients across all major verticals, providing industry solutions for Financial Services, Manufacturing, Life Sciences and Healthcare, Technology and Services, Telecom and Media, Retail and CPG, and Public Services. Consolidated revenues as of 12 months ending September 2026 totaled $14.8 billion.