Snowflake Architect or Data Architect - Texas Houston

AOB Recruitment•Houston, TX

About The Position

The Data Engineer will help design, build, and scale a modern cloud data platform centered on Snowflake and AWS. The role supports strategic data initiatives using Apache Iceberg managed tables, Snowflake Catalog, Snowflake Horizon, Informatica, and dbt, creating trusted and reusable data assets for applications, analytics, AI, and business intelligence. The position combines hands-on data engineering with enterprise data architecture, governance, metadata management, and ontology-driven modeling. The successful candidate will build scalable pipelines and governed data products, work with business and domain experts to define concepts and relationships, and help ensure data is reliable, discoverable, secure, and useful across business domains.

Requirements

Strong experience in data engineering, data modeling, ETL/ELT development, and cloud-based data platforms.
Hands-on Snowflake experience, including data modeling, performance optimization, security, access controls, and scalable warehouse or lakehouse architectures.
Experience working in AWS cloud environments.
Experience with Informatica or similar enterprise data integration platforms.
Experience with dbt for transformations, testing, documentation, and analytics engineering workflows.
Understanding of Apache Iceberg or similar open table formats, including managed tables, schema evolution, interoperability, and catalog-based access.
Familiarity with data cataloging, governance, metadata management, lineage, and policy-based data access.
Understanding of ontology modeling, semantic data models, taxonomies, business glossaries, or knowledge graph concepts.
Strong SQL skills and proficiency in Python or another modern programming language used for data engineering.
Ability to collaborate with business stakeholders to define data entities, relationships, metrics, and data product requirements.
Excellent communication, documentation, analytical, and problem-solving skills.
Strong Snowflake data architecture experience, including data modeling, warehouse/lakehouse design, performance optimization, security, access controls, and enterprise-scale implementations.
Data governance and metadata management expertise, including cataloging, lineage, data quality, governance frameworks, and policy-driven access.
Working knowledge of AWS services such as S3, Glue, Lambda, Athena, EMR, and Redshift.
Oil and natural gas midstream domain experience supporting pipeline, transportation, storage, LNG, natural gas, or other midstream operations and data environments (mandatory).
Claude AI or generative AI experience, such as Claude, LLM-based solutions, AI-ready data platforms, RAG architectures, or GenAI implementations (mandatory).

Nice To Haves

Experience with Snowflake Catalog and Snowflake Horizon.
Experience building governed data products for analytics, AI, machine learning, or operational applications.
Experience with enterprise data governance platforms, particularly Informatica governance capabilities.
Knowledge of RDF, OWL, SHACL, SPARQL, graph databases, or knowledge graph technologies.
Experience designing semantic layers, metadata models, business glossaries, or domain ontologies.
Familiarity with Git, CI/CD pipelines, automated testing, and data engineering deployment practices.
Experience implementing data observability, lineage tracking, data contracts, and data quality frameworks.
Experience in large-scale enterprise data environments supporting multiple business domains and stakeholder groups.

Responsibilities

Design, build, and maintain scalable pipelines for structured, semi-structured, and unstructured data.
Develop data ingestion and extract-load processes using Informatica or comparable enterprise data integration tools.
Build dbt transformation logic, including modular models, tests, documentation, and deployment workflows.
Design, optimize, and manage data structures in Snowflake.
Develop and support data solutions in AWS cloud environments.
Implement data architectures using Apache Iceberg managed tables, including open-format interoperability, cataloging, and governed access patterns.
Use Snowflake Catalog and Snowflake Horizon to support metadata management, discovery, lineage, governance, policy enforcement, and trusted data sharing.
Collaborate with data architects, governance teams, analysts, application developers, and business stakeholders to design trusted data products.
Partner with business and domain experts to define concepts, entities, relationships, and terminology.
Support ontology-driven modeling, including semantic models, taxonomies, business glossaries, and metadata management.
Translate business requirements into logical and physical data models and reusable enterprise data products.
Implement data quality validation, lineage, observability, governance controls, and monitoring.
Support data products for analytics, artificial intelligence, business intelligence, and operational applications.
Ensure solutions meet enterprise requirements for security, privacy, access control, scalability, performance, and reliability.