Snowflake Architect

Roles & Responsibilities

Design and manage database, warehouse, user, and role provisioning within Snowflake environments.

Establish and maintain high availability and resiliency architectures to ensure system reliability.

Define inbound and outbound data integration architectures, aligned with Azure best practices.

Integrate Snowflake with enterprise security and monitoring tools such as Falcon and Datadog.

Implement and enforce authentication and access control policies across the platform.

Core (Must-Have) Responsibilities

Configure Azure Private Link and VNet integrations, ensuring all Snowflake traffic remains secure and off the public internet.

Implement Entra ID (Azure AD) SSO and SCIM provisioning for automated user lifecycle management.

Develop and maintain Terraform modules for Snowflake and Azure (AzureRM), including remote state management in Azure Blob Storage with locking mechanisms.

Build and manage CI/CD pipelines for infrastructure using Azure DevOps or GitHub Actions with PR-based approval workflows.

Manage Azure Key Vault for secure secret storage and automated credential rotation, integrating with CI/CD pipelines.

Configure ADLS Gen2 integrations and Snowflake external stages with appropriate access controls and managed identities.

Enforce network security using NSGs and Snowflake network policies, ensuring least-privilege access.

Good-to-Have Responsibilities

Implement observability solutions using Azure Monitor, streaming Snowflake logs and metrics to Log Analytics via Event Hub, and building alerting dashboards.

Support and troubleshoot data ingestion pipelines using Azure Data Factory and Event Hub into Snowflake.

Implement policy-as-code frameworks (Sentinel/OPA) to enforce governance standards such as tagging, naming conventions, and cost optimization within Terraform pipelines.