Technical Lead

About Us:

Birlasoft, a global leader at the forefront of Cloud, AI, and Digital technologies, seamlessly blends domain expertise with enterprise solutions. The company’s consultative and design-thinking approach empowers societies worldwide, enhancing the efficiency and productivity of businesses. As part of the multibillion-dollar diversified CKA Birla Group, Birlasoft with its 12,000+ professionals, is committed to continuing the Group’s 170-year heritage of building sustainable communities.

Experience: 10+ years

Location: Mumbai, Pune, Hyderabad

Employment Type: Full-time

Job Summary

We are looking for a Snowflake Tech Lead with 10+ years of experience in data engineering, cloud platforms, and Snowflake implementations. This role involves leading technical teams, designing scalable Snowflake solutions, and optimizing data pipelines for performance and efficiency. The ideal candidate will have deep expertise in Snowflake, ETL/ELT processes, and cloud data architecture.

Key Responsibilities

1. Snowflake Development & Optimization

• Lead Snowflake implementation, including data modeling, warehouse design, and performance tuning.
• Optimize SQL queries, stored procedures, and UDFs for high efficiency.
• Implement Snowflake best practices (clustering, partitioning, zero-copy cloning).
• Manage virtual warehouses, resource monitors, and cost optimization.

2. Data Pipeline & Integration

• Design and deploy ETL/ELT pipelines using Snowflake, Snowpark, Coalesce.
• Integrate Snowflake with BI tools (Power BI, Tableau), APIs, and external data sources.
• Implement real-time and batch data ingestion (CDC, streaming, Snowpipe).

3. Team Leadership & Mentorship

• Lead a team of data engineers, analysts, and developers in Snowflake projects.
• Conduct code reviews, performance tuning sessions, and technical training.
• Collaborate with stakeholders, architects, and business teams to align solutions with requirements.

4. Security & Governance

• Configure RBAC, data masking, encryption, and row-level security in Snowflake.
• Ensure compliance with GDPR, HIPAA, or SOC2 standards.
• Implement data quality checks, monitoring, and alerting.

5. Cloud & DevOps Integration

• Deploy Snowflake in AWS, Azure
• Automate CI/CD pipelines for Snowflake using GitHub Actions, Jenkins, or Azure DevOps.
• Monitor and troubleshoot Snowflake environments using logging tools (Datadog, Splunk).

Required Skills & Qualifications

• 10+ years in data engineering, cloud platforms, or database technologies.
• 5+ years of hands-on Snowflake development & administration.
• Strong expertise in SQL, Python for data processing.
• Experience with Snowflake features (Snowpark, Streams & Tasks, Time Travel).
• Knowledge of cloud data storage (S3, Blob) and data orchestration (Airflow, DBT).
• Certifications: Snowflake SnowPro Core/Advanced.
• Knowledge of DataOps, MLOps, and CI/CD pipelines.
• Familiarity with DBT, Airflow, SSIS & IICS