Principal Snowflake Architect

Summary Of Position

We are seeking an exceptional Principal Snowflake Architect to architect and lead our enterprise Snowflake ecosystem as the cornerstone of our PULSE platform modernization. This role will design and implement a secure, multi-tenant data platform that serves multiple departments and workloads across our telehealth organization, while establishing governance frameworks and leveraging cutting-edge Snowflake capabilities to drive innovation in healthcare analytics and AI.

As the technical authority for our Snowflake environment, you will architect a robust platform that balances security, accessibility, and innovation—enabling teams across the organization to leverage data safely while maintaining HIPAA compliance. You'll work closely with the VP of Data Science to establish our organization as a leader in modern cloud data architecture within the healthcare sector.

This is a hands-on, high-impact role with real ownership over architecture, standards, and platform evolution.

Essential Duties And Responsibilities

Architect & Scale the Snowflake Platform

• Design an enterprise, multi-tenant Snowflake architecture supporting analytics, reporting, data science, and ML workloads.
• Define workload isolation, cost governance, and performance patterns using warehouses, resource monitors, and replication/failover.
• Create reference architectures for clinical analytics, operational reporting, and AI-driven use cases.

Security, Governance & Compliance

• Design a robust RBAC model with Azure AD SSO, least-privilege access, and automated provisioning.
• Implement data classification, tagging, masking, row/column-level security, and audit reporting aligned with HIPAA.
• Establish enterprise data governance including cataloging, lineage, and data quality monitoring.

Enable Secure Data Sharing

• Architect internal and external data sharing using Snowflake Shares, reader accounts, and clean rooms.
• Support secure collaboration with partners and vendors without data duplication.
• Define standards for publishing curated internal data products.

Modern Snowflake Capabilities & AI

• Leverage Snowflake Cortex for in-platform ML, LLM use cases, semantic search, and feature stores.
• Enable Streamlit, Notebooks, Dynamic Tables, Iceberg tables, and Git-based development workflows.
• Evaluate and pilot new Snowflake features and platform innovations.

Platform Leadership

• Own architecture decisions, standards, and best practices for the Snowflake ecosystem.
• Mentor engineers and act as a trusted advisor to stakeholders.
• Partner with Snowflake product and solution teams on roadmap and early-access features.

Required Qualifications

• 10+ years in database or data platform engineering, including 5+ years designing Snowflake at enterprise scale.
• Deep expertise in Snowflake architecture, RBAC, multi-tenant design, and data sharing.
• Strong Azure experience (Azure AD, networking, Private Link, security).
• Hands-on experience with Terraform (or similar IaC), SQL, and Python.
• Proven experience designing secure, governed platforms for sensitive or regulated data.

Bonus Qualifications

• SnowPro Core (Advanced Architect or Data Engineer preferred).
• Experience with Snowflake Cortex, ML/AI workloads, or vector search.
• Healthcare or telehealth data experience.
• Experience with dbt, data products, or data marketplace integrations.

Key skills/competency

• Snowflake Architecture
• Data Platform Engineering
• RBAC Security
• Multi-tenant Design
• HIPAA Compliance
• Azure Cloud
• Terraform IaC
• SQL
• Python
• Data Governance