Azure Lead Data Engineer

EXL Talent Acquisition Team; Gurugram District; On-site; INR 3,000,000 - 4,800,000; Full time

Job summary

EXL Talent Acquisition Team in Gurugram is seeking an experienced Data Engineer to design and build robust data pipelines in a cloud environment and to optimize Snowflake workloads while delivering scalable analytics solutions.

You will write efficient SQL, collaborate with data teams, and ensure governance and documentation standards are upheld in a dynamic, cross-functional setting.

Qualifications

• 8+ years of experience in data engineering using Azure and Snowflake.
• Strong SQL skills for data extraction and transformation.
• Hands-on with Snowflake, SnowSQL and DBT.
• Experience building data integration pipelines in cloud environments.
• Knowledge of data governance and metadata management is a plus.

Responsibilities

• Design and develop ETL/ELT pipelines using Azure Data Factory, Snowflake and DBT.
• Build and maintain data integration workflows from diverse sources to Snowflake.
• Write optimized SQL queries for data extraction and transformation.
• Collaborate with stakeholders to translate business requirements into technical solutions.
• Monitor, troubleshoot and optimize data pipelines for performance and reliability.
• Ensure data quality, governance, and documentation standards.
• Collaborate with analysts, architects, and DevOps in a cloud-native environment.

Skills

Azure Cloud Platform

Azure Data Factory

SQL

Snowflake

SnowSQL

DBT

Cloud-based data environments

Python

Education

Bachelor’s or Master’s degree in Computer Science or related field

Tools

Snowflake

SnowSQL

DBT

Azure Data Lake

Azure Synapse

Job description

Key Responsibilities:

• Design and develop ETL/ELT pipelines using Azure Data Factory, Snowflake, and DBT.
• Build and maintain data integration workflows from various data sources to Snowflake.
• Write efficient and optimized SQL queries for data extraction and transformation.
• Work with stakeholders to understand business requirements and translate them into technical solutions.
• Monitor, troubleshoot, and optimize data pipelines for performance and reliability.
• Maintain and enforce data quality, governance, and documentation standards.
• Collaborate with data analysts, architects, and DevOps teams in a cloud-native environment.

Must-Have Skills:

• Strong experience with Azure Cloud Platform services.
• Proven expertise in Azure Data Factory (ADF) for orchestrating and automating data pipelines.
• Proficiency in SQL for data analysis and transformation.
• Hands-on experience with Snowflake and SnowSQL for data warehousing.
• Practical knowledge of DBT (Data Build Tool) for transforming data in the warehouse.
• Experience working in cloud-based data environments with large-scale datasets.

Good-to-Have Skills:

• Experience with DataStage, Netezza, Azure Data Lake, Azure Synapse, or Azure Functions.
• Familiarity with Python or PySpark for custom data transformations.
• Understanding of CI/CD pipelines and DevOps for data workflows.
• Exposure to data governance, metadata management, or data catalog tools.
• Knowledge of business intelligence tools (e.g., Power BI, Tableau) is a plus.

Qualifications:

• Bachelor’s or Master’s degree in Computer Science, Data Engineering, Information Systems, or a related field.
• 8+ years of experience in data engineering roles using Azure and Snowflake.
• Strong problem-solving, communication, and collaboration skills.