Opening For Data Engineer with DBT (Data Build Tool), Snowflake

Tekskills Inc.; Mumbai; On-site; INR 1,500,000 - 2,100,000; Full time

Job summary

Tekskills Inc. seeks a seasoned Data Engineer in Mumbai to design scalable data models and DBT pipelines on Snowflake, and to develop robust PL/SQL for complex transformations.

You will collaborate with analysts, scientists, and business stakeholders to deliver high-quality data solutions while tuning Snowflake performance and enforcing data governance. Ideal candidates bring 5+ years in data engineering, strong DBT, Snowflake, and PL/SQL skills, plus knowledge of Git, CI/CD, and orchestration

Qualifications

• 5+ years of experience in data engineering or related field.
• Hands-on experience with DBT (modular SQL development, testing, documentation).
• Proficiency in Snowflake (data warehousing, performance tuning, security).
• Advanced knowledge of PL/SQL and experience with stored procedures, functions, and packages.
• Solid understanding of data modeling concepts (star/snowflake schemas, normalization).
• Experience with version control systems (e.g., Git) and CI/CD practices.
• Familiarity with orchestration tools (e.g., Airflow, dbt Cloud, Prefect) is a plus.

Responsibilities

• Design and implement scalable data models and transformation pipelines using DBT on Snowflake.
• Write efficient and maintainable PL/SQL code for complex data processing and transformation tasks.
• Collaborate with data analysts, data scientists, and business stakeholders to understand data requirements and deliver high-quality solutions.
• Optimize Snowflake performance through query tuning, clustering, and resource management.
• Ensure data quality, integrity, and governance through testing, documentation, and monitoring.
• Participate in code reviews, architecture discussions, and continuous improvement initiatives.
• Maintain and enhance CI/CD pipelines for DBT projects.

Skills

DBT development

Snowflake

PL/SQL

Data modeling

Version control

CI/CD

Orchestration tools

Tools

Git

DBT Cloud

Airflow

Prefect

Job description

Key Responsibilities:

• Design and implement scalable data models and transformation pipelines using DBT on Snowflake.
• Write efficient and maintainable PL/SQL code for complex data processing and transformation tasks.
• Collaborate with data analysts, data scientists, and business stakeholders to understand data requirements and deliver high-quality solutions.
• Optimize Snowflake performance through query tuning, clustering, and resource management.
• Ensure data quality, integrity, and governance through testing, documentation, and monitoring.
• Participate in code reviews, architecture discussions, and continuous improvement initiatives.
• Maintain and enhance CI/CD pipelines for DBT projects.

Required Qualifications:

• 5+ years of experience in data engineering or a related field.
• Strong hands-on experience with DBT (modular SQL development, testing, documentation).
• Proficiency in Snowflake (data warehousing, performance tuning, security).
• Advanced knowledge of PL/SQL and experience with stored procedures, functions, and packages.
• Solid understanding of data modeling concepts (star/snowflake schemas, normalization).
• Experience with version control systems (e.g., Git) and CI/CD practices.
• Familiarity with orchestration tools (e.g., Airflow, dbt Cloud, Prefect) is a plus.