About the role
LEAD DATA ENGINEER
Experience: 8 to 12 years
Location: Gurugram
ROLE OVERVIEW
We are looking for a hands-on Lead Data Engineer to design, build and deliver enterprise-scale cloud data platforms on Snowflake and Microsoft Azure.
You will lead complex data engineering and transformation initiatives, guide a team of engineers, and work directly with senior stakeholders to deliver scalable, secure, high-performance data solutions that support business decisions.
The role combines deep technical expertise, architectural thinking, team leadership and stakeholder management.
KEY RESPONSIBILITIES
1. Data Architecture and Platform Design
- Design scalable, robust and secure enterprise data platforms on Snowflake and Azure, including cloud data warehouses, data lakes and lakehouses.
- Define data engineering standards, architectural best practices and reusable design patterns.
- Ensure platforms meet performance, scalability, availability and security requirements.
- Implement data governance, security, access controls and monitoring.
2. Snowflake Development and Optimization
- Provide hands-on leadership in Snowflake development, architecture, administration and optimization.
- Optimize queries, compute resources, storage and overall platform performance.
3. Data Pipelines and Transformation
- Lead the design, development, testing and deployment of complex ETL/ELT pipelines for structured and semi-structured data, using Azure data services end to end.
- Set best practices for data ingestion, transformation, orchestration and integration.
- Ensure data quality, consistency, reliability and availability across enterprise systems.
- Troubleshoot complex issues and continuously improve pipeline performance.
4. Technical Leadership
- Lead and mentor data engineers on design, development, code reviews and problem-solving.
- Drive technical decisions and ensure adherence to engineering standards.
- Collaborate with architects, business analysts, data scientists and other cross-functional teams.
- Own technical deliverables for complex data initiatives.
5. Stakeholder Management and Delivery
- Work with business stakeholders and clients to translate requirements into technical solutions.
- Communicate architecture decisions, risks and recommendations clearly to technical and non-technical audiences.
- Manage priorities, dependencies and delivery timelines across distributed teams.
- Identify opportunities for automation, innovation, cost optimization and process improvement.
REQUIRED TECHNICAL SKILLS
- Strong hands-on experience with Snowflake and cloud data warehousing.
- Extensive experience with Microsoft Azure Data Services and cloud data engineering.
- Strong understanding of data warehousing, data modelling (including dimensional modelling) and modern data architecture.
- Expertise in ETL/ELT design, development, orchestration and optimization, including complex pipelines and data integration frameworks.
- Strong SQL, with performance tuning and query optimization.
- Knowledge of data governance, data quality, security and access management.
- Experience with engineering best practices, deployment processes and production support.
KEY COMPETENCIES
- Strong technical leadership and stakeholder management, with the ability to influence and drive technical decisions.
- Excellent written and verbal communication.
- Strong analytical, problem-solving and decision-making skills.
- Customer focus and sound business acumen.
- Experience working with cross-functional, geographically distributed teams.
- Self-motivated, innovative and committed to continuous improvement.
PREFERRED QUALIFICATIONS
- Delivery of large-scale enterprise cloud data transformation projects.
- Exposure to automation and CI/CD in data engineering.
- Experience with Agile delivery.
- Cloud or Snowflake certifications.