Snowflake Architect with Cortex AI

Role name: Snowflake Architect with Cortex AI

Work site: New York, US (Remote)



Job Description:

Looking for strong Snowflake Certified Architect with 5 years of Snowflake experience in managing the Platform and strong experience in Cortex AI



**Semantic Modelling** :Build and maintain Snowflake AI Semantic Models to ground Cortex Analyst queries in governed business definitions. Define entity relationships, metric logic, and dimension hierarchies in YAML. Partner with data owners to ensure semantic layer accuracy and lineage.



**Data Modelling**: Architect and support Bronze/Silver/Gold medallion datasets across Snowflake, and Iceberg.



**CI/CD for Snowflake** : Design and maintain CI/CD pipelines (GitHub Actions, Terraform, dbt) for AI model promotion across dev/staging/prod. Automate Snowflake object deployment (UDFs, Cortex functions, semantic models) and Databricks job/cluster configurations.



**Monitoring & Observability** : Instrument AI workloads with end-to-end observability: model latency, token throughput, error rates, hallucination signals. Configure Snowflake Query History and Databricks MLflow tracking for full auditability. Build dashboards with Streamlit, Cortex Agents for real-time AI health monitoring.



**Usage Governance & FinOps** : Implement resource monitors, Snowflake credit budgets, to control AI compute spend. Tag all AI workloads with cost centers and track Cortex token consumption by team/product.