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. Were 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 information on employment scams is availablehere.