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

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

Job summary

Tekskills Inc. is seeking a data engineer to design scalable data models and DBT pipelines on Snowflake, delivering high-quality data transformations. You will implement efficient PL/SQL, collaborate with analysts, and tune Snowflake for performance and security.

Lead data quality and governance through testing and documentation, contribute to code reviews, and enhance CI/CD pipelines for DBT projects in Bengaluru. Experience with Airflow, dbt Cloud, and Prefect is a plus.

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.

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

Snowflake

PL/SQL

Data modeling

Git

CI/CD

Airflow

dbt Cloud

Prefect

Tools

DBT

Snowflake

Git

CI/CD

Airflow

dbt Cloud

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.