Snowflake Infra Architect
Chicago, IL
Date Posted:12-Jun-2026
Work Type:On-Site
Job Number:487781
Job Description
Job Title: Snowflake Infra Architect
Location: Chicago/Atlanta/Minneapolis (first 2months should be present in Chicago)
Duration: 6 months
Must Have:
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
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.
Good to have :
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.
Location: Chicago/Atlanta/Minneapolis (first 2months should be present in Chicago)
Duration: 6 months
Must Have:
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
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.
Good to have :
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.
Applicant Notices & Disclaimers
- For information on benefits, equal opportunity employment, and location-specific applicant notices, click here
At SPECTRAFORCE, we are committed to maintaining a workplace that ensures fair compensation and wage transparency in adherence with all applicable state and local laws. This position's starting pay is: $55.00/hr.