Principal Snowflake Architect
- Hiring from
- Canada
- Work type
- Remote
- Posted
624,578 remote jobs, straight from company career pages
100% free · New jobs every minute
Show job descriptionHide job description
Job Title: Principal Snowflake Architect
Location: 100% Remote
6-12+months
Experience: 10+ Years
Role Summary
We are looking for a Principal Snowflake Architect to own the end-to-end design, scalability, and governance of our enterprise Snowflake data platform. You will serve as the senior technical authority, bridging business objectives with modern cloud data engineering, legacy data warehouse migrations, and AI-ready data architectures.
Key Responsibilities
- Platform Architecture: Design and implement multi-cluster Snowflake environments, warehouse compute topologies, data sharing, and open table format strategies (e.g., Iceberg).
- Data Modeling & Engineering: Define enterprise data models (Data Vault, Star/Snowflake schemas) and oversee scalable ELT pipelines using dbt, Snowpipe, Streams, and Tasks.
- Legacy Migrations: Lead assessments, workload conversions, and cutover strategies for migrating legacy databases (Oracle, Teradata, SQL Server, SAP) onto Snowflake.
- FinOps & Performance Tuning: Establish credit consumption governance, warehouse sizing standards, query optimization, and clustering strategies to balance speed with cost efficiency.
- Governance & Security: Implement Role-Based Access Control (RBAC), data masking, encryption, lineage tracking, and compliance frameworks across cloud environments.
- AI & Modern Capabilities: Architect data readiness for analytics and AI/ML workloads, utilizing features like Snowflake Cortex.
- Technical Leadership: Mentor data engineers and solution architects, set coding/architectural standards, and partner with executive stakeholders to align data strategy with business goals.
Required Qualifications
- Experience: 10+ years in data engineering/architecture, with 4+ years of deep, hands-on experience architecting enterprise Snowflake solutions.
- Core Stack: Expert-level SQL and Python skills; strong hands-on experience with dbt, CI/CD pipelines, and at least one major cloud provider (AWS, Azure, or GCP).
- Architecture Patterns: Proven track record with Data Lakehouse, Data Mesh, or Data Fabric implementations.
- Communication: Ability to translate complex technical trade-offs into clear business outcomes for non-technical stakeholders.
