Job Summary
We are looking for a Tech Lead ‿ Data Engineering who will lead the design, development, and delivery of scalable cloud based data platforms. The role requires strong hands on experience with Snowflake, dbt, and Apache Airflow, along with the ability to mentor teams, drive engineering best practices, and work closely with business stakeholders.
Key Responsibilities
Technical Leadership & Architecture
- Lead the end to end design and implementation of modern data platforms using Snowflake, dbt, and Airflow
- Define data architecture, modelling standards, and transformation patterns (RAW â¿¿ STG â¿¿ MART)
- Review and approve technical designs, data models, and pipeline implementations
- Drive performance optimization and cost optimization in Snowflake Hands on Development
- Design and build ELT pipelines using dbt (Core/Cloud) for transformations
- Develop and orchestrate workflows using Apache Airflow (DAG design, scheduling, monitoring)
- Implement incremental models, snapshots (SCD Type 1 & 2), macros, tests, and seeds in dbt
- Optimize Snowflake SQL queries, clustering, and warehouse sizing
Data Quality & Governance
- Define and implement data quality rules, testing frameworks, and validation checks using dbt tests
- Ensure adherence to data governance, security, and compliance standards
- Support production issues, root cause analysis, and permanent fixes
Team & Stakeholder Management
- Mentor and guide data engineers; conduct code reviews and knowledge sharing sessions
- Collaborate with business analysts, BI teams, and stakeholders to translate requirements into scalable data solutions
- Coordinate with DevOps and QA teams for CI/CD and release management
Required Skills & Expertise
Core Technical Skills
- Snowflake:
- Advanced Snowflake SQL, data modelling, performance tuning
- Warehouses, stages, streams, tasks, secure views, RBAC
- dbt:
- dbt Core / dbt Cloud
- Incremental models, snapshots, macros, tests, seeds
- Apache Airflow:
- DAG development, scheduling, monitoring, retries, SLA management
Programming & Data
- Strong proficiency in SQL
- Working knowledge of Python for data engineering use cases
- Experience with large scale data ingestion and transformation pipelines
Good to Have
- Experience with real time ingestion (Snowpipe, Streams)
- Exposure to Data Vault / Dimensional modeling
- Experience in telecom domain
- Experience in Power BI Reporting
- Prior experience in client facing or offshore‿onsite delivery models
Leadership & Soft Skills
- Strong analytical and problem solving skills
- Excellent communication and stakeholder management abilities
- Proven ability to lead teams and deliver under tight timelines
- Ownership mindset with a focus on quality and scalability
- Need to start at 7 AM IST