Data Architect - Snowflake

YO AI Labs; Houston (TX); On-site; USD 140,000 - 190,000; Full time

Job summary

YO AI Labs in Houston is seeking a Snowflake Architect or Data Architect to design, build, and scale a cloud data platform centered on Snowflake and AWS. The ideal candidate has strong data engineering fundamentals, experience with enterprise data platforms, and the ability to work with ontologies, semantic models, metadata, and governed data products.

You will collaborate with governance, analytics, and business teams, implement data quality, lineage, and access controls, and drive

Qualifications

• Strong Snowflake Data Architecture experience including data modeling and enterprise-scale Snowflake implementations.
• Hands-on Data Governance, metadata management, data lineage, data quality, governance frameworks, and policy-driven data access.
• Understanding of Ontology & Semantic Modeling.
• Experience with AWS services (S3, Glue, Lambda, Athena, EMR, Redshift) and cloud-based data architectures.
• Midstream Oil & Gas domain experience is mandatory.
• Claude AI / Generative AI experience is mandatory.

Responsibilities

• Design, build, and maintain scalable data pipelines across structured, semi-structured, and unstructured data sources.
• Develop data ingestion and extract-load processes using Informatica, aligning with enterprise standards and existing in-house capabilities.
• Build transformation logic using dbt, including modular models, testing, documentation, and deployment workflows.
• Design and manage data structures in Snowflake, with Snowflake positioned as the central strategic data platform.
• Work with AWS-based data services and infrastructure, supporting applications and data products running in the organization's AWS environment.
• Support data architecture using Iceberg managed tables, including open table formats, interoperability, cataloging, and governed access patterns.
• Use Snowflake Catalog and Snowflake Horizon to support metadata management, data discovery, governance, lineage, policy enforcement, and trusted data sharing.
• Collaborate with data architects, governance teams, analysts, application teams, and business stakeholders to define trusted data products.
• Work with domain experts to understand business concepts, entities, relationships, and terminology.
• Support ontology-driven modeling, including entity definitions, taxonomies, relationships, business glossaries, and semantic mappings.
• Translate business and domain concepts into logical data models, physical data models, and reusable data products.
• Implement data quality checks, validation rules, lineage, observability, and governance controls.
• Support data products and applications such as news intelligence, asset intelligence, analytics, and AI-enabled use cases.
• Ensure data solutions meet enterprise requirements for security, privacy, access control, performance, and reliability.

Skills

Snowflake data architecture

Data governance & metadata management

Ontology & semantic modeling

AWS data services

Midstream oil & gas domain experience

Claude AI / Generative AI

Tools

Informatica

dbt

Iceberg

Snowflake Catalog

Snowflake Horizon

Job description

Job Description

Role: Snowflake Architect or Data Architect -

Domain : Information technology (IT)

Job Type : Full Time

Location : Houston

Experience : 12 - 18 Years

Role Summary:

We are looking for a Data Engineer to help design, build, and scale a modern cloud data platform centered on Snowflake and AWS. The ideal candidate has strong data engineering fundamentals, experience with enterprise data platforms, and the ability to work with ontologies, semantic models, metadata, and governed data products.

Key Responsibilities:

• Design, build, and maintain scalable data pipelines across structured, semi-structured, and unstructured data sources.
• Develop data ingestion and extract-load processes using Informatica, aligning with enterprise standards and existing in-house capabilities.
• Build transformation logic using dbt, including modular models, testing, documentation, and deployment workflows.
• Design and manage data structures in Snowflake, with Snowflake positioned as the central strategic data platform.
• Work with AWS-based data services and infrastructure, supporting applications and data products running in the organization's AWS environment.
• Support data architecture using Iceberg managed tables, including open table formats, interoperability, cataloging, and governed access patterns.
• Use Snowflake Catalog and Snowflake Horizon to support metadata management, data discovery, governance, lineage, policy enforcement, and trusted data sharing.
• Collaborate with data architects, governance teams, analysts, application teams, and business stakeholders to define trusted data products.
• Work with domain experts to understand business concepts, entities, relationships, and terminology.
• Support ontology-driven modeling, including entity definitions, taxonomies, relationships, business glossaries, and semantic mappings.
• Translate business and domain concepts into logical data models, physical data models, and reusable data products.
• Implement data quality checks, validation rules, lineage, observability, and governance controls.
• Support data products and applications such as news intelligence, asset intelligence, analytics, and AI-enabled use cases.
• Ensure data solutions meet enterprise requirements for security, privacy, access control, performance, and reliability.

Must-Have Requirements:

• Strong Snowflake Data Architecture experience – Data modeling, data warehouse/lakehouse design, performance optimization, security, access controls, and enterprise-scale Snowflake implementations.
• Data Governance & Metadata Management expertise – Hands-on experience with data cataloging, metadata management, data lineage, data quality, governance frameworks, and policy-driven data access.
• Understanding of Ontology & Semantic Modeling.
• Working knowledge of AWS services such as S3, Glue, Lambda, Athena, EMR, Redshift, and cloud-based data architectures.
• Oil & Natural Gas Midstream domain experience (Mandatory) – Experience supporting pipeline, transportation, storage, LNG, natural gas, or other midstream operations and data environments.
• Claude AI / Generative AI experience (Mandatory) – Experience working with Claude, LLM-based solutions, AI-ready data platforms, RAG architectures, or GenAI implementations.