Lead Data Engineer
Chennai, Tamil Nadu, India
- Pay
- Pay not listed
- Work setting
- Not stated
- Employment
Permanent — employment source
Employment type in the employer’s posting: Permanent
From the employer’s posting
What you’ll work on
Full postingDesign, build, and optimize ETL/ELT pipelines and workflows
Build and maintain data warehouses and dimensional data models
Write and tune complex SQL for large-scale data processing
Monitor, troubleshoot, and optimize pipelines for performance and cost
Mentor associate engineers with technical guidance and feedback
From the employer’s posting
Lead the design, development, and optimization of ETL/ELT pipelines and workflows
Build and maintain data warehouses and data models (relational, dimensional, star schema)
Write, tune, and optimize advanced SQL queries for large-scale data processing
Proactively monitor, optimize, and troubleshoot pipelines for performance, scalability, and cost efficiency
Mentor associate engineers, providing technical guidance and feedback
Tools in this posting
- Python
- SQL
- AWS
- Azure
- dbt
- GCP
- Kafka
- Snowflake
- Spark
- Airflow
- Luigi
Source — Tool mentions in context
Duties & Responsibilities Lead the design, development, and optimization of ETL/ELT pipelines and workflows Write, tune, and optimize advanced SQL queries for large-scale data processing Build and maintain data warehouses and data models (relational, dimensional, star schema) Translate business requirements into robust, well-architected, and reusable data solutions Partner with analysts, data scientists, and stakeholders to deliver trusted, actionable datasets Implement and maintain unit tests, integration tests, and validation frameworks to ensure pipeline reliability Document workflows, and design decisions to support knowledge sharing and operational continuity Apply coding standards, CI/CD practices, version control, and peer code reviews to ensure high-quality deliverables Proactively monitor, optimize, and troubleshoot pipelines for performance, scalability, and cost efficiency Support deployments and handle post-production monitoring and incident resolution Mentor associate engineers, providing technical guidance and feedback Requirements Basic Qualifications Bachelor’s degree in computer science, Information Systems, Engineering, or a related field 6-10 years of hands-on experience in data engineering or related fields Expertise in writing complex SQL queries, optimizing, using advanced functionals and turning the performance on cloud data warehouse environment. Strong experience with data warehousing concepts, design, and implementation Minimum 6 years of hands-on experience with Snowflake or modern cloud data warehouse Minimum 3 years of hands-on experience in data modeling Minimum 2 year of hands-on Python development (ETL/ELT scripting, OOP, automation) Strong knowledge of at least one major cloud platform (AWS, Azure, or GCP) Experience with orchestration tools (e.g., Airflow, ADF, Luigi) for workflow management Demonstrated ability to lead and mentor teams while managing multiple priorities Strong communication and stakeholder management skills Strong hands-on experience with data warehousing concepts, design, and implementation Preferred Qualifications Hands-on experience with DBT (Data Build Tool) for data transformations Familiarity with DevOps and CI/CD best practices in data engineering Exposure with real-time/streaming platforms (Kafka, Spark Streaming, Flink) Exposure to the e-commerce domain or large-scale B2B/B2C environments Has the ability to break down problems and estimate time for development tasks Experience mentoring and guiding junior engineers Understands the technology landscape, up to date on current technology trends and new technology, brings new ideas to the team Learns organization vision statement and decision-making framework. Able to understand how team and personal goals/objectives contribute to the organization vision
Posting record
Report an error- Status in our records
- Live
- First seen by us
- Sep 29, 2026 · 30 days ago
- Recorded sightings
- 70
- Last seen by us
- Oct 29, 2026
- Reposted
- once since Jun 3, 2026
These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications. We count a repost when the same title and location comes back as a new listing within 60 days of the last one coming down. Some hiring systems expire listings on a schedule, so repost rates vary by system.
Your next step
- Have your resume and examples of relevant work ready.
- Check the listed location, eligibility and core experience before starting.
- Ask the employer about the pay range before committing time to the process.
Complete your application on staples.zohorecruit.in. The employer’s form will show what is required.
Already applied? Track this application
Job description
Duties & Responsibilities Lead the design, development, and optimization of ETL/ELT pipelines and workflows Write, tune, and optimize advanced SQL queries for large-scale data processing Build and maintain data warehouses and data models (relational, dimensional, star schema) Translate business requirements into robust, well-architected, and reusable data solutions Partner with analysts, data scientists, and stakeholders to deliver trusted, actionable datasets Implement and maintain unit tests, integration tests, and validation frameworks to ensure pipeline reliability Document workflows, and design decisions to support knowledge sharing and operational continuity Apply coding standards, CI/CD practices, version control, and peer code reviews to ensure high-quality deliverables Proactively monitor, optimize, and troubleshoot pipelines for performance, scalability, and cost efficiency Support deployments and handle post-production monitoring and incident resolution Mentor associate engineers, providing technical guidance and feedback Requirements Basic Qualifications Bachelor’s degree in computer science, Information Systems, Engineering, or a related field 6-10 years of hands-on experience in data engineering or related fields Expertise in writing complex SQL queries, optimizing, using advanced functionals and turning the performance on cloud data warehouse environment. Strong experience with data warehousing concepts, design, and implementation Minimum 6 years of hands-on experience with Snowflake or modern cloud data warehouse Minimum 3 years of hands-on experience in data modeling Minimum 2 year of hands-on Python development (ETL/ELT scripting, OOP, automation) Strong knowledge of at least one major cloud platform (AWS, Azure, or GCP) Experience with orchestration tools (e.g., Airflow, ADF, Luigi) for workflow management Demonstrated ability to lead and mentor teams while managing multiple priorities Strong communication and stakeholder management skills Strong hands-on experience with data warehousing concepts, design, and implementation Preferred Qualifications Hands-on experience with DBT (Data Build Tool) for data transformations Familiarity with DevOps and CI/CD best practices in data engineering Exposure with real-time/streaming platforms (Kafka, Spark Streaming, Flink) Exposure to the e-commerce domain or large-scale B2B/B2C environments Has the ability to break down problems and estimate time for development tasks Experience mentoring and guiding junior engineers Understands the technology landscape, up to date on current technology trends and new technology, brings new ideas to the team Learns organization vision statement and decision-making framework. Able to understand how team and personal goals/objectives contribute to the organization vision
Source details
Source notes
Source excerptsSelected passages from the saved posting. Check the full description for conditions and exceptions.
- Pay
No pay amount identified in the saved description.
- Location & working pattern
Chennai, Tamil Nadu, India
Working pattern and location restrictions need checking in the full posting.
- Work authorization
No clear work-authorization passage found. Eligibility is unconfirmed.
See how this role fits your experience
Add your resume to compare the role’s scope, tools and requirements with your experience.