Snowflake Infra Architect

Dice is the leading career destination for tech experts at every stage of their careers. Our client, Lorven Technologies, Inc., is seeking the following. Apply via Dice today!

Job Title : Snowflake Infra Architect

Location : Chicago, IL/Atlanta, GA/Minneapolis, MN – (First 2months should be present in Chicago

Job Description:

Bachelor's degree in Computer science or equivalent, with minimum 12+ Years of relevant experienceMust have experience in Azure Private Link & VNet. Configure private endpoints and DNS so Snowflake traffic stays off the public internet.Must have experience in Entra ID SSO & SCIM. Wire up SAML/OAuth auth and automate user provisioning via SCIM from Azure AD.Must have experience in Terraform modules. Own Snowflake + AzureRM provider modules with remote state in Azure Blob and storage-lease locking.Must have experience in CI/CD for infra. Build Azure DevOps or GitHub Actions pipelines with PR-gated Terraform plan/apply across environments.Must have experience in Key Vault & secrets rotation. Store and auto-rotate Snowflake credentials in Azure Key Vault; inject into pipelines securely.Must have experience in ADLS Gen2 & external stages. Configure storage integrations, managed identity access, and Snowflake external stage permissions.Must have experience in NSG & firewall rules. Manage network security groups and Snowflake network policies for least-privilege ingress/egress.Good to have : Observability via Azure Monitor. Stream Snowflake audit logs and metrics to Log Analytics via Event Hub; build alerts and dashboards.Good to have :ADF & Event Hub ingestion. Support and troubleshoot Azure Data Factory pipelines and Event Hub consumers landing data into Snowflake.Good to have :Policy-as-code . Enforce tagging, naming, and cost controls via Sentinel/OPA policies embedded in the Terraform pipeline.Strong troubleshooting, analytical, and problem-solving skills.Excellent communication and stakeholder management abilities.Excellent problem-solving, communication, and stakeholder management skills.Ability to lead technical discussions, architecture reviews, and cross-functional initiatives.