Staff Data Architect

Warner Bros Discovery Warner Bros Discovery · Media · Burbank, CA +1 · Technology

Staff Data Architect responsible for designing and implementing enterprise data architectures, focusing on a Context Layer with canonical models and semantic mappings to support Agentic AI systems. This includes architecting Snowflake Lakehouse, designing Snowflake Semantic Views, configuring Snowflake Cortex Analyst and Search, and implementing data governance with Snowflake Horizon to ensure AI agents can accurately query and reason against data.

What you'd actually do

  1. Architect, build, and scale our Medallion data pipeline (Bronze-to-Silver-to-Gold) using Snowflake Dynamic Tables, Streams, and Tasks for optimized canonical processing.
  2. Build consolidated, clean entity tables (e.g., Unified Customer Identity, Orders) in the Silver layer from completely mismatched raw source data schemas.
  3. Design native Snowflake Semantic Views to establish the authoritative business definitions of entities, dimensions, facts, metrics, and relationships directly inside the warehouse.
  4. Configure and tune Snowflake Cortex Analyst and Cortex Search by provisioning clean semantic models and relationship metadata, ensuring AI agents can achieve high accuracy on natural language queries without hallucinations.
  5. Build PoCs to show lightweight ontology tracking and entity-relationship traversing within Snowflake using advanced SQL techniques

Skills

Required

  • Snowflake
  • Data Architecture
  • Canonical Modeling
  • Semantic Mapping
  • Snowflake Semantic Views
  • Snowflake Cortex Analyst
  • Snowflake Cortex Search
  • Snowflake Horizon
  • Snowflake Dynamic Tables
  • Data Governance
  • ETL/ELT
  • SQL

Nice to have

  • Domain Modeling
  • AI Orchestration
  • Semantic Governance
  • Graph-Native Modeling
  • Ontology tracking
  • entity-relationship traversing

What the JD emphasized

  • Agentic AI systems
  • Snowflake Lakehouse Architecture
  • Canonical Modeling & Semantic Mapping
  • Snowflake Semantic Views Design
  • AI Grounding with Cortex
  • Ontology & Graph-Native Modeling in SQL
  • Data Governance & Contracts
  • proven track record of deploying large-scale Snowflake ecosystems with a focus on Domain Modeling, AI Orchestration, & Semantic Governance

Other signals

  • designing robust enterprise data architectures
  • enabling a next-generation enterprise AI ecosystem
  • Agentic AI systems capable of autonomous reasoning
  • building consolidated, clean entity tables
  • ensuring AI agents can achieve high accuracy on natural language queries without hallucinations