Snowflake Data Architect

You will be working as a Snowflake Expert in an onsite role in Pune. Your role involves utilizing your 10+ years of experience and strong skills in cloud data warehouse principles to design, build, optimize, and maintain robust and scalable data solutions on the Snowflake platform. Your responsibilities will include data modelling, ETL/ELT, SQL development, performance tuning, scaling, monitoring, and security handling. You will collaborate with stakeholders to translate business requirements into efficient data pipelines and models, leveraging Snowflake's capabilities to unlock data-driven insights. Key Responsibilities: - Proficient in Snowflake architecture, virtual warehouses, data sharing, time travel, cost optimization, and data governance features - Advanced SQL knowledge, including complex queries, window functions, stored procedures, and optimization techniques - Designing and implementing ETL/ELT pipelines using Snowflake Snowpipe, Tasks, Streams, and scripting languages - Experienced in data modelling methodologies and their application within Snowflake - Expertise in debugging and resolving performance bottlenecks, optimizing warehouse size and cost, query profiles, and data loading strategies - Deep understanding of Snowflake security features and implementing data governance frameworks - Proficient in scripting languages for automating data-related tasks and integration with other systems - Familiarity with cloud platforms such as Azure and integration with Snowflake - Experience in working with data analysis tools and BI platforms for data exploration and visualization - Proficient in using Git for managing code and collaborating within development teams - Experience working in Agile development, collaborating with Data and ETL team, reviewing and implementing best practices for data pipelines and models, optimizing SQL queries, ensuring data quality, integrity, and security, and participating in code reviews Qualifications Required: - Bachelors degree in computer science, Data Science, Information Technology, or equivalent - Relevant Snowflake certifications are a plus (e.g., Snowflake certified Pro / Architecture / Advanced) Please note that this job is an onsite role in Pune and requires expertise in Snowflake, SQL, ETL/ELT development, data modelling, performance tuning, security, scripting, cloud ecosystems, data analysis, version control, and Agile methodologies.,