Lead Data Engineer - DBT

8 - 10 years

10 - 12 Lacs

Posted:1 week ago| Platform: Naukri logo

Apply

Work Mode

Work from Office

Job Type

Full Time

Job Description

Location: Bangalore/Hyderabad/Pune

Experience level: 8+ Years

About the Role

technical and hands-on Lead Data Engineer

deep experience with DBT


Key Responsibilities
  • Lead the migration

    of legacy SQL-based ETL logic to DBT-based transformations
  • Design and implement

    a scalable, modular DBT architecture (models, macros, packages)
  • Audit and

    refactor legacy SQL

    for clarity, efficiency, and modularity
  • Improve

    CI/CD pipelines

    for DBT: automated testing, deployment, and code quality enforcement
  • Collaborate with data analysts, platform engineers, and business stakeholders to understand current gaps and define future data pipelines
  • Own

    Airflow orchestration redesign

    where needed (e.g., DBT Cloud/API hooks or airflow-dbt integration)
  • Define and enforce

    coding standards, review processes, and documentation practices

  • Coach junior data engineers on DBT and SQL best practices
  • Provide

    lineage and impact analysis

    improvements using DBTs built-in tools and metadata


Must-Have Qualifications
  • 8+ years of experience in data engineering
  • Proven success in

    migrating legacy SQL to DBT

    , with visible results
  • Deep understanding of

    DBT best practices

    , including model layering, Jinja templating, testing, and packages
  • Proficient in

    SQL performance tuning

    , modular SQL design, and query optimization
  • Experience with

    Airflow

    (Composer, MWAA), including DAG refactoring and task orchestration
  • Hands-on experience with modern data stacks (e.g., Snowflake, BigQuery etc.)
  • Familiarity with

    data testing and CI/CD for analytics workflows

  • Strong communication and leadership skills; comfortable working cross-functionally


Nice-to-Have
  • Experience with

    DBT Cloud or DBT Core integrations with Airflow

  • Familiarity with

    data governance and lineage tools

    (e.g., dbt docs, Alation)
  • Exposure to Python (for custom Airflow operators/macros or utilities)
  • Previous experience mentoring teams through modern data stack transitions

Mock Interview

Practice Video Interview with JobPe AI

Start Python Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Python Skills

Practice Python coding challenges to boost your skills

Start Practicing Python Now
Relanto Global logo
Relanto Global

Technology Consultancy

San Francisco

RecommendedJobs for You