Snowflake Architect

Summary role description:

Hiring for a Snowflake Architect for a high-end start-up AI Strategy and Consulting company.

Company description:

Our client is a start-up AI Strategy and Consulting company, headquartered in San Fransisco, that accelerate business strategies by seamlessly integrating AI, Data, and Digital technologies. They help businesses reimagine workflows, modernize data and digital infrastructure, and reduce tech, process, and talent debt by delivering tailor-made AI solutions that seamlessly integrate into your organization’s existing infrastructure.

Role details:

• Title / Designation: Snowflake Architect
• Reporting to: India Managing Director
• Location: Mumbai/Bengaluru/Hyderabad
• Work Mode: Work-from-Office

Role & responsibilities:

• Oversee and advise on the implementation of the customers Snowflake platform.  
• Demonstrate technical leadership through personally developed code, solution architectures and implementation recommendations
• Collaborate with Snowflake GTM and product teams to ensure customer alignment to Snowflake goals
• 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
• 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 modelling principles, processes, solutions, and best practices to ensure that the Snowflake is aligned with business needs of the environment.

Candidate requirements:

• 8+ years of experience in snowflake architecture with expertise in Management consulting using combination of Python, PySpark, Bash, SnowSQL and AWS cloud
• 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.
• Good to have – Certified Snowflake cloud data warehouse Architect

Selection process:

• Technical interview with Director
• Technical interview with RM
• HR Discussion