Senior Technical Specialist

Chennai

Posted:1 week ago

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.
Must Have Skill
Data Build Tool (DBT),MS SQL,Python,Snowflake
Good 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.

Skills Required

Analytics T-sql Stored Procedures MS SQL Server Python Automation Data Ingestion Data Modelling Data Quality Ci/cd Version Control GIT

Learn the skills this job asks for

Free courses, interview questions and practice for each skill.

Mock Interview

Practice Video Interview with JobPe AI

Start Python Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

coding practice

Enhance Your Python Skills

Practice Python coding challenges to boost your skills

Start Practicing Python Now
HCLTech logo
HCLTech

Information Technology Services

New Delhi

RecommendedJobs for You