Snowflake + SQL (Architect)

VidPro Consultancy Services; Pune City; Hybrid; INR 1,200,000 - 2,000,000; Full time

Job summary

VidPro Consultancy Services is seeking a seasoned Snowflake Data Architect with 5-15 years of experience in IT. In this role, you will lead enterprise-scale projects, ensuring data architecture aligns with current technologies while implementing Snowflake best practices. The position requires expertise in data modeling, SQL, and cloud technologies, as well as strong communication skills.

Qualifications

• 5+ years in IT and 2+ years as a Snowflake Data Architect.
• Experience with data warehouse implementations.
• Certified Snowflake Cloud Data Warehouse Architect preferred.

Responsibilities

• Ensure integration with existing data structures and provide consistent views.
• Provide technical leadership for enterprise-scale projects.
• Resolve complex data pipeline issues proactively.

Skills

Snowflake

SQL queries

DBT

ETL

Data modeling

Cloud Technologies

Performance tuning

Education

Bachelor's degree in Computer Science

Master's degree in Computer Science

Tools

SnowSQL

SnowPipe

AWS

Azure

Job description

Get AI-powered advice on this job and more exclusive features.

VidPro Consultancy Services provided pay range

This range is provided by VidPro Consultancy Services. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

Base pay range

Bangalore, Pune, Chennai, Kolkata, Gurugram

Experience

5-15 Years

Work Mode

Hybrid

Mandatory Skills

Snowflake, SQL queries, Snowpipe, SnowSQL, DBT, Architect

Overview

Ensure new features and subject areas are modeled to integrate with existing structures and provide a consistent view. Develop and maintain documentation of the data architecture, data flow, and data models of the data warehouse appropriate for various audiences. Provide direction on adoption of cloud technologies (Snowflake) and industry best practices in data warehouse architecture and modeling.

Provide technical leadership to large enterprise-scale projects. Responsible for preparing estimates and defining technical solutions to proposals (RFPs). This role requires a broad range of skills and the ability to step into different roles depending on the size and scope of the project.

Roles & Responsibilities

• Must have total 5+ years in IT and 2+ years' experience working as a Snowflake Data Architect and 4+ years in Data warehouse, ETL, BI projects.
• Must have experience with at least two end-to-end implementations of Snowflake cloud data warehouse and three on-premise data warehouse implementations, preferably on Oracle.
• Expertise in Snowflake – data modeling, ELT using Snowflake SQL, implementing complex stored procedures, and standard DWH and ETL concepts.
• Expertise in Snowflake advanced features like resource monitors, RBAC controls, virtual warehouse sizing, query performance tuning, Zero Copy Clone, Time Travel, and how to utilize these features.
• Experience deploying Snowflake features such as data sharing, events, and lake-house patterns.
• Hands-on experience with Snowflake utilities, SnowSQL, SnowPipe, and Big Data modeling techniques using Python.
• Experience in data migration from RDBMS to Snowflake.
• Deep understanding of relational and NoSQL data stores, methods, and approaches (star schema, dimensional modeling).
• Experience with data security and access controls.
• Experience with AWS or Azure data storage and management technologies such as S3 and ADLS.
• Build processes supporting data transformation, data structures, metadata, dependencies, and workload management.
• Proficiency in RDBMS, complex SQL, PL/SQL, Unix Shell Scripting, performance tuning, troubleshooting.
• Provide resolutions to complex data pipeline issues proactively.
• Must have expertise in AWS or Azure Platform as a Service (PaaS).
• Certified Snowflake Cloud Data Warehouse Architect (Desirable).
• Ability to troubleshoot across infrastructure, platform, and application domains.
• Experience with Agile development methodologies.
• Strong written and oral communication skills.

Nice to Have Skills/Qualifications

• Bachelor's and/or master's degree in computer science or equivalent experience.
• Strong communication, analytical, and problem-solving skills with high attention to detail.

About You

• You are self-motivated, collaborative, eager to learn, and hands-on.
• You love exploring new apps and innovating.
• You stay updated with the latest trends and technologies.
• You follow industry best practices and maintain high standards of quality.

Additional Details

• Seniority level: Associate
• Employment type: Full-time
• Job function: Engineering and Information Technology
• Industry: Human Resources Services

Referrals increase your chances of interviewing at VidPro Consultancy Services by 2x.

Get notified about new Software Architect jobs in Pune, Maharashtra, India.