Snowflake Architect

Location: Bengaluru

We are seeking an experienced Snowflake Architect with a strong technical background and solution-shaping orientation to join our team. The ideal candidate will have a deep understanding of Snowflake architecture, excellent communication skills, and the ability to analyze both technical and business requirements to design optimal solutions.

As a Snowflake Architect, you will play a crucial role in selecting the right technologies, shaping solutions, and providing technical guidance to meet our clients' needs.

Location - Mumbai/Bangalore/Hyderabad/Gurgaon (Hybrid - 3 Days a week in Office)

Responsibilities:

- Oversee and advise on the implementation of the customers Snowflake platform
- Demonstrate technical leadership through personally developed code, solution architectures and implementation recommendations
- Act as a trusted advisor to customer executive leadership for thought leadership and solution approaches
- Extract business requirements from customers and translate them into a well-architected recommendation
- Develop and provide forward looking guidance and future state roadmaps
- Leverage known best practices and solutions to reduce risk to customer implementations
- Decompose future state goals into actionable execution plans
- Collaborate with Snowflake GTM and product teams to ensure customer alignment to Snowflake goals
- Work closely with frontend developers, designers, and product managers to understand requirements and deliver high-quality features.
- Lead in Developing Project requirements for end-to-end Data integration process using ETL for Structured, semi-structured and Unstructured Data.
- Make necessary on-going updates to modeling principles, processes, solutions, and best practices to ensure that the Snowflake is aligned with business needs of the environment.

Requirements:

- 10+ years of experience implementing data management solutions .
- Management consulting experience.
- Expertise in Snowflake concepts like setting up Resource monitors, RBAC controls, scalable virtual warehouse, SQL performance tuning, zero copy clone, time travel and automating them.
- Experience in handling semi-structured data (JSON, XML), columnar PARQUET using the VARIANT attribute in Snowflake.
- Experience in in re-clustering of the data in Snowflake with good understanding on Micro-Partitions.
- Experience in Migration processes to Snowflake from on-premises database environment.
- Experience in designing and building manual or auto ingestion data pipeline using Snowpipe.
- Experience in Cloud technologies such as AWS – S3, SQS, EC2, Lambda, Redshift, RDS
- Design and Develop automated monitoring processes on Snowflake using combination of Python, PySpark, Bash with SnowSQL.
- SnowSQL Experience in developing stored Procedures writing Queries to analyze and transform data.
- Certified Snowflake cloud data warehouse Architect (Desirable).