Snowflake - Developer / Lead /Architect

SP Staffing; India; On-site; INR 1,800,000 - 2,700,000; Full time

Job summary

SP Staffing Services seeks a seasoned Snowflake Architect to lead data and analytics initiatives for enterprise clients across India. You will design scalable data models, optimize Snowflake deployments, and collaborate with business stakeholders to translate requirements into robust solutions.

The ideal candidate has 8+ years in data/analytics architecture, strong SQL and Python skills, and experience with security, cost control, and governance in cloud environments.

Qualifications

• 8+ years of experience in architecting and building data and analytics solutions.
• Deep knowledge of Snowflake features such as virtual warehouses, micro-partitions, data sharing and security best practices.
• Strong SQL skills for complex queries, stored procedures, and optimization; familiarity with Python or other scripting languages for automation.
• Expertise in implementing role-based access control, encryption, compliance standards and auditing within Snowflake and cloud environments.
• Ability to optimize compute/storage costs, manage workloads, and tune queries for high performance.
• SnowPro Core or Advanced Architect certification is a strong plus.
• Ability to lead architecture discussions, mentor teams and collaborate with business and technical stakeholders
• Excellent communication, presentation, and interpersonal skills
• Experienced in working in a customer-facing role
• Conduct workshops with business and IT stakeholders to capture, document and summarize data, integration and analytics requirements for the Snowflake.
• Design optimized data models and schemas
• Integrate Snowflake with multiple data sources and platforms (on prem DBs, files, APIs, Azure/AWS services, Kafka/ETL tools) ensuring secure, reliable data ingestion and curation.
• Establish governance and security standardsRBAC, network policies, SSO/MFA, data classification, masking and secure data sharing across accounts/partners.
• Optimize performance and cost by tuning virtual warehouses, managing micro partitions/clustering, caching, query profiling and workload isolation for concurrency and throughput.
• Guide the technical team on architecture patterns and migration approaches (zero copy cloning, Time Travel, Fail safe) and oversee implementation to production readiness.
• Conduct proofs of concept and create reusable accelerators and reference architectures.
• Guide technical team of deliverables and get the solution implemented
• Conduct proof of concepts and create differentiating assets
• Conduct training and workshops on new technologies and trends

Responsibilities

• Architect and build Snowflake-based data analytics solutions.
• Lead architecture discussions and mentor teams.
• Collaborate with business and technical stakeholders.
• Conduct workshops with IT and business to capture requirements.
• Ensure production readiness and governance.

Skills

Snowflake architecture

SQL proficiency

Python scripting

RBAC & security

Cost optimization

Performance tuning

Data modeling

Stakeholder management

Customer-facing

Workshops facilitation

Leadership/mentoring

Snowflake features

Tools

ETL tools

Kafka

Azure

AWS

Job description

Greetings from SP Staffing Services!

Reaching out to you regarding permanent MNC opportunity!!

Job Description:

Location: Pan India

Experience : 6 Yrs- 20 yrs

Interview Mode:Virtual Interview

Interview Process: Technical & Managerial / HR round

Job Description :

• 8+ years of overall experience in architecting and building data and analytics solutions including data modeling, ETL/ELT pipelines and performance optimization.
• Deep knowledge of Snowflake features such as virtual warehouses, micro-partitions, data sharing and security best practices.
• Strong SQL skills for complex queries, stored procedures, and optimization; familiarity with Python or other scripting languages for automation.
• Expertise in implementing role-based access control, encryption, compliance standards and auditing within Snowflake and cloud environments.
• Ability to optimize compute/storage costs, manage workloads, and tune queries for high performance.
• SnowPro Core or Advanced Architect certification is a strong plus.
• Ability to lead architecture discussions, mentor teams and collaborate with business and technical stakeholders
• Excellent communication, presentation, and interpersonal skills
• Experienced in working in a customer-facing role
• Conduct workshops with business and IT stakeholders to capture, document and summarize data, integration and analytics requirements for the Snowflake.
• Design optimized data models and schemas
• Integrate Snowflake with multiple data sources and platforms (on prem DBs, files, APIs, Azure/AWS services, Kafka/ETL tools) ensuring secure, reliable data ingestion and curation.
• Establish governance and security standardsRBAC, network policies, SSO/MFA, data classification, masking and secure data sharing across accounts/partners.
• Optimize performance and cost by tuning virtual warehouses, managing micro partitions/clustering, caching, query profiling and workload isolation for concurrency and throughput.
• Guide the technical team on architecture patterns and migration approaches (zero copy cloning, Time Travel, Fail safe) and oversee implementation to production readiness.
• Conduct proofs of concept and create reusable accelerators and reference architectures.
• Guide technical team of deliverables and get the solution implemented
• Conduct proof of concepts and create differentiating assets
• Conduct training and workshops on new technologies and trends