I am looking for Snowflake Architect

I am seeking an expert Snowflake Architect to assist with my project. 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, Data warehouse design concepts, 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. Key Responsibilities Collaborate with stakeholders to gather and understand technical and business requirements. Assess various technologies and tools to recommend the most suitable solutions for different projects. Serve as a bridge between technical and non-technical teams, demonstrating a hybrid of technical and sales skills. Utilize in-depth analysis skills, especially in SQL, data structures, and business acumen, to design effective solutions. Shape solutions that align with business objectives, providing advice based on business results required. Communicate solutions effectively, including standing firm on decisions when necessary and delivering hard facts respectfully. Manage risks and identify potential challenges in projects, ensuring smooth execution and delivery. Provide project and resource management support to ensure alignment with solution goals. Collaborate with project managers and developers to guide development processes in line with solution requirements. Ensure solutions are scalable and adaptable for future modifications, considering the organization's goals. Qualifications And Experience Minimum 4 yrs+ experience with snowflake- snowflake SQL, Snow pipe, streams, Stored procedure, Task, Hashing, Row Level Security, Time Travel etc. Proficiency in SQL, data structures, and database design principles. Strong experience in ETL or ELT Data Pipelines and various aspects, terminologies with Pure SQL like SCD Dimensions, Delta Processing etc. 3+ years of Experience of working with AWS cloud services- S3, Lambda, Glue, Athena, IAM, CloudWatch, Redshift etc. 5+ years of proven expertise in creating pipelines for real time and near real time integration working with different data sources - flat files, XML, JSON, Avro files and databases Excellent communication skills, including the ability to explain complex technical concepts clearly. Prior experience in a client-facing or consulting role is advantageous. Ability to manage projects and resources effectively, ensuring timely delivery and goal alignment. Candidate is expected to be fluent in Python to be able to write maintainable, reusable, and complex functions for backend data processing. Front development with python is good to have but not necessary. Preferred Snowflake Solution Architect Certified AWS Solution Architect –(At least Associate) Certified Exposure to Airflow is plus Experience with Tableau