We are looking for an experienced Snowflake Architect to join our team. In this role, you will be responsible for the management, architecture, and optimization of Snowflake data warehousing solutions. You will be working on complex data systems, ensuring efficient and effective use of Snowflake’s capabilities across multiple cloud providers.
- Manage and optimize multiple Snowflake accounts and cloud resources.
- Oversee Snowflake usage, warehouse management, and implement appropriate resource monitoring.
- Design, implement, and manage Snowflake’s Role-Based Access Control (RBAC) system.
- Set up and manage Snowflake Secure Data Shares, Data Consumers, and Partner Connect.
- Lead the replication of databases and demonstrate database failover/failback procedures.
- Communicate and manage Snowflake releases, ensuring timely adaptation to feature deprecations and enhancements.
- Demonstrate and implement improvements in Snowflake's public and private preview features.
- Collaborate with senior stakeholders on technical matters and provide solutions to complex data challenges.
- Lead a team and oversee the successful execution of multiple data-driven projects.
- ·Contribute to the development and implementation of best practices for Snowflake architecture.
- A minimum of 6+ years of experience in computer science, IT, systems analysis, or other related fields.
- 6+ years of experience in data warehousing and relational databases, with expertise in Snowflake, Oracle, or PostgreSQL.
- Experience managing multiple Snowflake accounts and working with multiple cloud providers.
- Strong knowledge of Snowflake’s architecture, resource monitoring, and warehouse management.
- Expertise in Snowflake’s RBAC system, including the best practices for roles and access patterns.
- Experience with Snowflake Secure Data Shares, Data Consumers, and Partner Connect configurations.
- Proven experience with database replication, failover, and failback.
- Ability to communicate and manage Snowflake release cycles, especially when dealing with deprecated features.
- Proficiency in SQL, Shell Scripting, and Python.
- Solid understanding of AWS and cloud technologies, with a strong grasp of data warehousing concepts.
- At least 2 years of experience in a supervisory or cross-functional team lead role.
- Demonstrated problem-solving abilities and the ability to provide technical solutions for complex data issues.
- Strong knowledge of project management methodologies, particularly Agile.
- Excellent communication skills, both written and verbal, at all levels of the organization.
- A bachelor’s or master’s degree, preferably in Computer Science, Information Systems, Business Administration, or a related field.
- Prior vendor management experience is preferred.
- Ability to manage and prioritize multiple projects simultaneously.
This role offers an exciting opportunity to work on cutting-edge technologies and take ownership of Snowflake architecture and optimization within a collaborative, fast-paced environment. If you are passionate about Snowflake and cloud technologies, we would love to hear from you!