Senior Technical Specialist (IN)

HCL TechnologiesIN

Senior

Posted 9 days agoStill open, checked 55m ago

About the job

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.

Similar jobs