Snowflake architect
Persistent
Persistent
Join our team as a Snowflake Architect and spearhead the design and optimization of enterprise data platforms. You will leverage your deep expertise in Snowflake architecture, cloud data engineering, and multi-tenant platform design to build secure, scalable, and high-performing data solutions.
This role is pivotal in shaping end-to-end Snowflake-native architectures, ensuring adherence to regulatory compliance, robust security, and exceptional operational excellence for large-scale, multi-tenant data environments.
We are committed to fostering a values-driven, people-centric, and inclusive work environment. We encourage applications from diverse backgrounds and offer hybrid work options with flexible hours to accommodate various lifestyles. Our accessible office spaces are equipped to support all employees.
Architect and lead the design of end-to-end Snowflake-native solutions for Proof of Concepts and enterprise deployments. Define optimal multi-tenant data isolation strategies, including schema-based isolation and Row-Level Security, to support numerous tenants.
Implement diverse ingestion patterns like MySQL CDC using Openflow and REST API integrations via Snowpark. Design and manage Dynamic Table refresh strategies and point-in-time snapshot architectures for reporting needs.
Ensure compliance with regulatory requirements (PIPEDA, OSFI, SOC 2 Type II) by establishing secure credential management and robust networking architectures using AWS services. Drive architectural reviews, platform standardization, and cloud modernization initiatives, creating comprehensive documentation and roadmaps.
A minimum of 10 to 15 years of experience in Data Architecture, Cloud Data Platforms, or Enterprise Analytics is essential. You must possess profound expertise in Snowflake architecture, including its core components and RBAC, alongside hands-on experience with Dynamic Tables, Tasks, Streams, and ingestion frameworks.
Demonstrated knowledge of multi-tenant architecture patterns, SQL optimization, performance engineering, and data modeling is crucial. Proficiency with AWS services such as S3, Aurora MySQL, PrivateLink, and IAM is required.
Familiarity with data residency regulations and security best practices, including encryption and auditability, is expected. Experience with Snowpark, API integrations, and Agile methodologies will be highly beneficial. Strong leadership and communication skills are key to influencing technical strategy and mentoring engineering teams.
Persistent Systems
IT Consulting