Sr DBT Developer- Chennai- 27th F2F drive

We are looking for Senior Data Engineer candidates

Face to Face Drive on 27th June @ World Trade center, Chennai

Role: Senior DBT Developer

Experince; 7years to 13 years

Notice period : Immediate to 45 days only

Primary Skillset: DBT, Airflow, Python, AWS Glue, Snowflake, Databricks and Data Modelling

WORK Location: Chennai-Work From Office

Drive Address : Perungudi, Chennai, Tamil Nadu 600096

Date and Time: 27th June'26 from 10.30 AM- 3.30PM

Key Responsibilities

Data Modeling & DBT Development

• Develop and maintain DBT models (staging, intermediate, mart layers) following modular design and best practices.
• Implement dbt tests, documentation, sources, macros, and packages.
• Build reusable and scalable data transformation frameworks.

Data Pipeline Engineering

• Design and optimize ELT workflows using DBT integrated with orchestrators (Airflow, Dagster, Prefect, etc.).
• Work with cloud data environments - AWS and Snowflake
• Develop and optimize Snowflake schemas, warehouses, and SQL performance
• Ensure high performance of SQL transformations and warehouse queries.

Data Quality & Governance

• Implement and maintain data quality tests within DBT (unique, not null, referential integrity).
• Contribute to version control, CI/CD, documentation standards, and best practices.
• Implement data quality checks, monitoring, and failure handling
• Apply RBAC, secure views, and cost/performance optimization in Snowflake

Collaboration & Stakeholder Support

• Work with analysts and business teams to understand requirements and convert them into scalable data models.
• Support data consumers with well_structured data and documentation (dbt docs).
• Participate in code reviews and provide engineering guidance.
• 8+ years experience in Data Engineering / ELT development.
• Strong SQL proficiency, with experience writing optimized queries.
• 2+ years of Hands_on experience with DBT Cloud.
• Experience with AWS cloud data warehouse: AWS
• Datawarehouse: Snowflake - Develop and optimize Snowflake schemas, warehouses, and SQL performance
• Familiarity with Git, CI/CD pipelines, and modern data stack principles.
• Understanding of data modeling techniques (Kimball, Data Vault, Star/Snowflake
• Experience integrating DBT with orchestrators (Airflow, Dagster, Prefect, etc.).

Required Skills

• AWS Cloud - AWS Glue, S3, Lambda, Step Functions, IAM
• Strong Python and SQL
• Hands-on Snowflake experience (performance, security, cost),;
• Pyspark/Snowpark Programming
• Data Modelling
• Production dbt experience (models, tests, macros)
• Apache Airflow for orchestration
• Solid understanding of ELT, dimensional modeling, and data quality

If Interested please apply using the given link and directly apply to the job.And you will recieve call from our recruiter to book your slot.

This job is posted by

Aishwarya K

HRBP - India Operations

Cortex Consultants LLC (US) | Cortex Consulting Pvt Ltd (India) | Tcell (Canada)