Auxo AI - Snowflake Architect - ETL/SQL (9-11 yrs)

Job Description :

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.

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.

Qualifications :

- 8+ 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 Snow SQL.

- Snow SQL Experience in developing stored Procedures writing Queries to analyze and transform data.

- Certified Snowflake cloud data warehouse Architect (Desirable)