Job Type: Full Time
Job Category: IT
Job Description
Snowflake Tech Lead
Full Time.
Bangalore, INDIA
Experience: 8+ Years
Key Responsibilities:
- Lead the design and implementation of scalable, secure, and high-performance Snowflake architectures.
- Drive the implementation of medallion architecture (Bronze, Silver, Gold layers) and enterprise data modeling standards.
- Design and implement transformation frameworks using dbt (data build tool) for modular, testable, and version-controlled data models.
- Design and standardize automated onboarding and environment provisioning frameworks for rapid, repeatable deployments.
- Provide technical leadership to data engineering teams building ELT/ETL pipelines and data transformation workflows.
- Design, implement, and govern CI/CD pipelines for Snowflake objects, data pipelines, and IaC deployments.
- Establish best practices for performance tuning, cost optimization, clustering strategies, workload management, and resource governance.
- Conduct code reviews, and enforce development standards across teams.
- Mentor engineers and act as the primary technical escalation point for Snowflake-related initiatives.
- Collaborate with cross-functional stakeholders including Data Architects, DevOps, Cloud, and Security teams.
- Define and drive enterprise data strategy and operating model, including data domain ownership, data product thinking, SLA/SLO definitions, platform roadmap planning, and alignment with business KPIs.
- Establish enterprise data quality, governance, and metadata management frameworks, including automated data validation, lineage tracking, catalog integration, schema evolution controls, and regulatory compliance (e.g., PII governance).
- Lead modernization and transformation initiatives, including legacy EDW decommissioning, large-scale data migrations, streaming-first architectures, and adoption of event-driven and lakehouse patterns across the organization.
- Lead Snowflake platform performance, scalability, and cost optimization initiatives, including advanced query tuning (Query Profile analysis, micro-partition pruning, clustering key strategy), multi-cluster warehouse optimization, and enterprise cost governance using Resource Monitors and chargeback frameworks.
- Design and govern secure, enterprise-grade Snowflake environments, including cross-account and cross-region data sharing (Secure Shares, Reader Accounts), robust RBAC models with least-privilege principles, dynamic data masking, row access policies, and disaster recovery/failover strategies.
- Drive implementation of scalable ingestion, orchestration, and observability frameworks leveraging Streams & Tasks for CDC, Snowpipe/Snowpipe Streaming for near real-time data pipelines, and comprehensive monitoring using ACCOUNT_USAGE, INFORMATION_SCHEMA, and custom telemetry dashboards.
Required Qualifications:
- Snowflake extensive hands-on implementation experience.
- 8+ years of experience in data engineering and enterprise data warehousing.
- Proven experience leading automated, scalable onboarding and provisioning frameworks.
- Deep experience implementing CI/CD pipelines using Git, Jenkins, GitLab, Azure DevOps, or similar tools.
- Advanced SQL expertise and strong programming skills in Python or similar scripting languages.
- Hands-on experience with cloud platforms (AWS, Azure, or GCP).
- Demonstrated experience leading technical teams and driving architectural decisions.
Preferred Qualifications:
- Snowflake certification
- Familiarity with DevOps and DataOps best practices.
- Experience with enterprise-scale migrations to Snowflake.
- Exposure to multi-account Snowflake strategy and cross-region data sharing.
- Strong stakeholder communication and solution design documentation skills.
Required Skills
Data Analyst