Snowflake Developer
- Newbie Soft Solutions
- 10 - 17 years
- Pune
- 2 months ago
- Email to a friend
- Report this job
Job Description
Job Title: Senior Snowflake Architect / Lead Snowflake Engineer
Experience: 10+ Years (Minimum 4+ Years Hands-On in Snowflake)
Locations: Chennai | Bangalore | Pune | Hyderabad
Work Mode: Hybrid 3 Days from Office
Job Overview
We are seeking a highly experienced Snowflake Architect with 10+ years in IT and at least 4 years of strong hands-on expertise in Snowflake. The candidate will lead architecture, design, and implementation of scalable, secure, and cost-optimized data platforms.
This role requires strong leadership, deep technical knowledge, and the ability to mentor engineering teams while aligning with enterprise standards.
Roles and Responsibilities
Requirement Analysis
- Understand business needs for data storage, transformation, analytics, and reporting.
- Convert business requirements into scalable Snowflake-based architectural solutions.
Architectural Design
- Design end-to-end Snowflake data architecture focusing on performance, scalability, and security.
- Define schemas, data models, data flows, and integration points with other enterprise systems.
- Establish Snowflake architectural best practices, governance, and standards.
Migration Strategy
- Create and execute migration strategies for moving legacy data platforms to Snowflake.
- Ensure minimal downtime, data integrity, and smooth data transition.
Optimization Framework
- Optimize Snowflake workloads, storage, and query performance.
- Collaborate with data engineers and DBAs to improve overall data processing quality.
Collaboration
- Work closely with business analysts, PMs, data engineers, and architects.
- Ensure technical design aligns with business objectives and enterprise architecture.
Governance
- Ensure compliance with enterprise governance, data security, and audit requirements.
- Establish escalation mechanisms and quality checkpoints across phases.
Review & Certification
- Validate and certify architecture documents, pipelines, and all technical deliverables.
- Conduct detailed reviews of data models, SQL scripts, Snowflake objects, and migration components.
Day-to-Day Activities
- Conduct requirement workshops and architecture meetings.
- Design and document data models, architecture diagrams, and Snowflake migration blueprints.
- Guide implementation teams to align with architecture and Snowflake best practices.
- Review SQL, SnowSQL, stored procedures, UDFs, and Snowflake components.
- Evaluate and implement features like Streams, Tasks, Time Travel, Clustering, Materialized Views, etc.
- Work with or explore Snowpark & Snowflake Cortex functionalities.
- Collaborate on CI/CD, DevOps, data quality, and performance tuning.
- Stay updated with new Snowflake releases and incorporate them as needed.
Required Technical Skills
- Strong expertise in SQL, SnowSQL, stored procedures, and UDFs.
- Hands-on experience or exposure to:
- Snowpark
- Snowflake Cortex
- Strong understanding of Snowflake architectural concepts:
- Micro-partitioning
- Virtual warehouses
- Query optimization
- RBAC & governance
- Streams & Tasks
- Data sharing & secure views
- Experience with DBT / Coalesce or other ETL platforms.
- Exposure to BI tools (Power BI, Tableau, Looker, etc.).
- Knowledge of DevOps, Git, CI/CD pipelines.
- Added advantage: exposure to AI/ML/GenAI within the Snowflake ecosystem.
Job Classification
Industry: IT Services & ConsultingFunctional Area / Department: Engineering - Software & QARole Category: DBA / Data warehousingRole: Data warehouse DeveloperEmployement Type: Full timeContact Details:
Company: Newbie Soft SolutionsLocation(s): Pune
Keyskills: Snowsql Stored Procedures Snowflake Snowpark Cortex Data Warehousing
Similar positions
Newbie Soft Solutions
PureSoftware delivers IT services and digital solutions across industries including telecom, healthcare, and financial services. The company specializes in software engineering, product development, and digital transformation. Its career portal reflects roles in DevOps, QA, cloud technologies, and e...
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in