What are the responsibilities and job description for the Snowflake Infra Architect position at Reqroute, Inc?
Job title: Snowflake Infra Architect
Location:- Chicago/Atlanta/Minneapolis (first 2months should be present in Chicago)
Type: Contract
Job Description:
Required
Azure Private Link & VNet. Configure private endpoints and DNS so Snowflake traffic stays off the public internet.
Entra ID SSO & SCIM. Wire up SAML/OAuth auth and automate user provisioning via SCIM from Azure AD.
Terraform modules. Own Snowflake AzureRM provider modules with remote state in Azure Blob and storage-lease locking.
CI/CD for infra. Build Azure DevOps or GitHub Actions pipelines with PR-gated Terraform plan/apply across environments.
Key Vault & secrets rotation. Store and auto-rotate Snowflake credentials in Azure Key Vault; inject into pipelines securely.
ADLS Gen2 & external stages. Configure storage integrations, managed identity access, and Snowflake external stage permissions.
NSG & firewall rules. Manage network security groups and Snowflake network policies for least-privilege ingress/egress.
Preferred :
Observability via Azure Monitor. Stream Snowflake audit logs and metrics to Log Analytics via Event Hub; build alerts and dashboards.
ADF & Event Hub ingestion. Support and troubleshoot Azure Data Factory pipelines and Event Hub consumers landing data into Snowflake.
Policy-as-code . Enforce tagging, naming, and cost controls via Sentinel/OPA policies embedded in the Terraform pipeline.