Staff Data Architect

Warner Media, LLC.; Burbank (CA); On-site; USD 146,440 - 271,960; Full time

Benefits offered by this job

Health insurance

Wellness program

Paid holidays and sick time

Job summary

Warner Media, LLC. is seeking a Staff Data Architect to join their Enterprise Data & Analytics Group. This role requires expertise in designing robust enterprise data architectures to support business objectives and advance modernization efforts on cloud data platforms.

Key responsibilities include establishing data governance frameworks, designing ETL processes, and collaborating closely with data engineers and stakeholders. Candidates should have extensive experience with Snowflake, advanced SQL, and AI integration.

Competitive salary range from $146,440 to $271,960 per year, along with comprehensive benefits.

Qualifications

• 8+ years of enterprise data architecture experience.
• Proven track record deploying large-scale Snowflake ecosystems.
• Minimum 3 years of hands-on experience with Snowflake.

Responsibilities

• Design and implement enterprise data architectures.
• Collaborate with stakeholders to define data strategies.
• Provide technical leadership and mentorship.

Skills

Data Architecture

Snowflake

SQL

AI Orchestration

Data Governance

Education

Bachelor's degree in computer science or related field

Tools

Snowflake Semantic Views

Cortex AI

Job description

Your New Role

We are expanding our Enterprise Data & Analytics Group by adding a Staff Data Architect professional that will be a data-driven leader with deep experience designing robust enterprise data architectures that support business objectives. This role will help advance the company’s modernization efforts on cloud data platform, enabling a next-generation enterprise AI ecosystem that moves beyond basic chat interfaces and analytics workloads to support Agentic AI systems capable of autonomous reasoning.

Your Role Accountabilities

As a Data & Semantic Architect, you will design and implement the Context Layer across the data products. You will be responsible for creating canonical models in the Silver layer, defining enterprise ontologies, and native Semantic Views. Your work will ensure that autonomous AI agents have a rock-solid, governed framework to accurately query, traverse, and reason against our data.

Data and Semantic Architecture

• Snowflake Lakehouse Architecture: Architect, build, and scale our Medallion data pipeline (Bronze-to-Silver-to-Gold) using Snowflake Dynamic Tables, Streams, and Tasks for optimized canonical processing.

• Canonical Modeling & Semantic Mapping: Build consolidated, clean entity tables (e.g., Unified Customer Identity, Orders) in the Silver layer from completely mismatched raw source data schemas.

• Snowflake Semantic Views Design: Design native Snowflake Semantic Views to establish the authoritative business definitions of entities, dimensions, facts, metrics, and relationships directly inside the warehouse.

• AI Grounding with Cortex: 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.

• Ontology & Graph-Native Modeling in SQL: Build PoCs to show lightweight ontology tracking and entity-relationship traversing within Snowflake using advanced SQL techniques.

• Data Governance & Contracts: Leverage Snowflake Horizon capabilities to enforce column/row-level security, data quality guardrails, and version-controlled metric schemas so that updates to the semantic plane do not break downstream AI workflows.

Data Strategy & Governance

• Collaborate with stakeholders to define data strategies and roadmaps.
• Establish and maintain data governance frameworks to ensure data quality and compliance. Implement re-usable data quality frameworks.
• Stay up to date with the latest cloud data technologies and trends.
• Evaluate and recommend new data technologies and tools.
• Come up with best practices, well architected guidance to improve the quality, performance and scalability of the solutions built on Snowflake platform.
• Change how we think, act, and utilize our data by performing exploratory and quantitative analytics, data mining, and discovery.
• Ensure data security and privacy through appropriate access controls and encryption.

Data Integration & Management

• Design ETL/ELT processes for data integration from various sources.
• Build software across our data platform, including event driven data processing, storage, and serving through scalable and highly available APIs, with cutting-edge technologies.
• Optimize data storage and retrieval for efficient data access.

Collaboration & Communication

• Help us stay ahead of the curve by working closely with data engineers, stream processing specialists, API developers, our DevOps team, and analysts to design systems which can scale elastically.
• Work closely with business analysts & business users to understand data requirements.
• Provide technical leadership and mentorship to junior team members.
• Help build and maintain foundational data products such as Finance, Titles, Content Sales, Theatrical, Consumer Products etc.
• Collaborate with data engineering, data platform, and data strategy teams to achieve organizational objectives.

Qualifications & Experiences

• Bachelor's degree in computer science, information systems, or information technology or similar major.
• 8+ years of enterprise data architecture experience with a proven track record of deploying large-scale Snowflake ecosystems with a focus on Domain Modeling, AI Orchestration, & Semantic Governance.
• Minimum 3 years of experience with advanced, hands‑on architectural experience with Snowflake in enterprise data space is highly preferred. Experience in the competent tech stack is also preferred.
• Proven experience or deep working knowledge of Snowflake Semantic Views, Cortex AI (Analyst/Search), Snowflake Horizon, and Dynamic Tables.
• Data Modeling: Expert-level command of relational modeling, dimensional (Kimball) design, and building canonical enterprise schemas.
• Advanced SQL & Processing: Mastery of complex SQL (including recursive CTEs, analytical window functions, and semi-structured VARIANT parsing) alongside Snowpark (Python).
• AI Context Integration: Clear understanding of how LLM-driven agents utilize structured enterprise data, APIs, and metadata catalogs to execute complex operational workflows.

Compensation & Benefits

Pay Range: $146,440.00 - $271,960.00 per year. Other rewards may include annual bonuses, short- and long-term incentives, and program-specific awards. Warner Bros. Discovery provides a variety of benefits to employees, including health insurance coverage, an employee wellness program, life and disability insurance, a retirement savings plan, paid holidays and sick time and vacation.

Championing Inclusion at WBD

Warner Bros. Discovery embraces the opportunity to build a workforce that reflects a wide array of perspectives, backgrounds and experiences. Being an equal opportunity employer means that we take seriously our responsibility to consider qualified candidates on the basis of merit, without regard to race, color, religion, national origin, gender, sexual orientation, gender identity or expression, age, mental or physical disability, and genetic information, marital status, citizenship status, military status, protected veteran status or any other category protected by law.

If you are a qualified candidate with a disability and you require adjustments or accommodations during the job application and/or recruitment process, please visit our accessibility page for instructions to submit your request.

In compliance with local law, we are disclosing the compensation, or a range thereof, for roles in locations where legally required. This is included above. If you are a qualified candidate with an arrest or conviction record, please know that your application will be considered in accordance with the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act.