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)
