{"schemaVersion":"jobsearcher.job.v1","id":"3bd9f568cc2ff1ab407bd271","url":"https://jobsearcher.com/jobs/3bd9f568cc2ff1ab407bd271","canonicalUrl":"https://jobsearcher.com/jobs/3bd9f568cc2ff1ab407bd271","title":"Data Architect","description":"Job title: Snowflake Infra ArchitectLocation:- Chicago- HYBRID6-12 Months contractW2 ONLYMust : Azure Private Link & VNet. Configure private endpoints and DNS so Snowflake traffic stays off the public internet.Must : Entra ID SSO & SCIM. Wire up SAML/OAuth auth and automate user provisioning via SCIM from Azure AD.Must : Terraform modules. Own Snowflake + AzureRM provider modules with remote state in Azure Blob and storage-lease locking.Must : CI/CD for infra. Build Azure DevOps or GitHub Actions pipelines with PR-gated Terraform plan/apply across environments.Must : Key Vault & secrets rotation. Store and auto-rotate Snowflake credentials in Azure Key Vault; inject into pipelines securely.Must : ADLS Gen2 & external stages. Configure storage integrations, managed identity access, and Snowflake external stage permissions.Must : 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.","company":"Reqroute","rawCompany":"reqroute","city":"Chicago","state":"IL","isRemote":false,"isActive":false,"createdAt":"2026-06-18T10:45:16.878Z","occupations":[{"code":"15-1243.01","title":"Data Warehousing Specialists","slug":"data-warehousing-specialists"},{"code":"15-1299.08","title":"Computer Systems Engineers/Architects","slug":"computer-systems-engineers-architects"},{"code":"15-1243.00","title":"Database Architects","slug":"database-architects"}],"industries":[{"code":"541512","title":"Computer Systems Design Services","slug":"computer-systems-design-services"},{"code":"541511","title":"Custom Computer Programming Services","slug":"custom-computer-programming-services"},{"code":"518210","title":"Computing Infrastructure Providers, Data Processing, Web Hosting, and Related Services","slug":"computing-infrastructure-providers-data-processing-web-hosting-and-related-services"}],"jobPosting":{"@context":"https://schema.org","@type":"JobPosting","title":"Data Architect","description":"Job title: Snowflake Infra ArchitectLocation:- Chicago- HYBRID6-12 Months contractW2 ONLYMust : Azure Private Link & VNet. Configure private endpoints and DNS so Snowflake traffic stays off the public internet.Must : Entra ID SSO & SCIM. Wire up SAML/OAuth auth and automate user provisioning via SCIM from Azure AD.Must : Terraform modules. Own Snowflake + AzureRM provider modules with remote state in Azure Blob and storage-lease locking.Must : CI/CD for infra. Build Azure DevOps or GitHub Actions pipelines with PR-gated Terraform plan/apply across environments.Must : Key Vault & secrets rotation. Store and auto-rotate Snowflake credentials in Azure Key Vault; inject into pipelines securely.Must : ADLS Gen2 & external stages. Configure storage integrations, managed identity access, and Snowflake external stage permissions.Must : 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.","datePosted":"2026-06-18T10:45:16.878Z","dateModified":"2026-06-18T10:45:16.878Z","hiringOrganization":{"@type":"Organization","name":"Reqroute","sameAs":"https://jobsearcher.com"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"Chicago","addressRegion":"IL","addressCountry":"US"}},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"3bd9f568cc2ff1ab407bd271"},"url":"https://jobsearcher.com/jobs/3bd9f568cc2ff1ab407bd271"}}