Lead Data Engineer / Architect (Snowflake, DBT, Airflow, Terraform)

Job Description:

Lead Data Engineer / Architect (Snowflake, DBT, Airflow, Terraform)

Job Location: Hyderabad / Bangalore / Chennai / Kolkata / Noida/ Gurgaon / Pune / Indore / Mumbai

Role Overview
We are seeking a highly skilled Lead Data Engineer / Architect with 10+ years of industry experience (5+ years working extensively on Snowflake and modern data engineering platforms). The ideal candidate will be responsible for designing, optimizing, and leading large-scale data engineering solutions using Snowflake, DBT, Airflow, Snowpark, and Terraform. This role requires strong expertise in advanced SQL, data pipeline orchestration, CI/CD automation, and proven leadership in driving architecture and mentoring teams. Key Responsibilities

• Build and optimize ELT/ETL pipelines leveraging Snowpark, dbt, and Python.
• Write complex SQL queries including window functions, CTEs, and advanced ANSI SQL for business-critical transformations.
• Develop reusable frameworks for data quality, lineage, and monitoring.
• Implement CI/CD pipelines for Snowflake, dbt, and Airflow using Git and Terraform.
• Optimization & Performance Tuning
• Monitor and optimize query performance, warehouse costs, and storage usage.
• Implement query tuning strategies using clustering, micro-partitioning, caching, and indexing techniques.
• Drive efficiency in batch and streaming ingestion using COPY INTO, Snowpipe, and orchestration frameworks.

Required Skills & Qualifications
10+ years of total IT experience, with 5+ years of relevant Snowflake data engineering experience. Expertise in:

• Snowflake (Snowpipe, COPY INTO, Snowpark, Snowsql)
• dbt for modular transformations and version control
• Airflow for orchestration and scheduling
• Terraform for infrastructure automation
• Advanced ANSI SQL including window functions and performance tuning
• Strong knowledge of CI/CD pipelines and DevOps practices for data engineering.
• Hands-on experience with data architecture, governance, and cost optimization strategies.
• SnowPro Advanced: Data Engineer Certification required.
• Strong communication, stakeholder management, and leadership skills.

At DXC Technology, we believe strong connections and community are key to our success. Our work model prioritizes in-person collaboration while offering flexibility to support wellbeing, productivity, individual work styles, and life circumstances. We re committed to fostering an inclusive environment where everyone can thrive.

Recruitment fraud is a scheme in which fictitious job opportunities are offered to job seekers typically through online services, such as false websites, or through unsolicited emails claiming to be from the company. These emails may request recipients to provide personal information or to make payments as part of their illegitimate recruiting process. DXC does not make offers of employment via social media networks and DXC never asks for any money or payments from applicants at any point in the recruitment process, nor ask a job seeker to purchase IT or other equipment on our behalf. More information on employment scams is available here .