AOB Recruitment

Snowflake Architect or Data Architect - Texas Houston

Houston, Harris County

Sponsorship not specified$130k-$140kDetected 20 hours ago

PythonData StructuresGitSQLSnowflakeRedshiftAWSCI/CDMachine LearningdbtData EngineeringLLMsRAGTest AutomationEHR/EMRCommunicationProblem Solving

About the role

3) Understanding of Ontology & Semantic Modeling 4) Working knowledge of AWS services such as S3, Glue, Lambda, Athena, EMR, Redshift, and cloud-based data architectures.
5) Oil & Natural Gas Midstream domain experience (Mandatory) - Experience supporting pipeline, transportation, storage, LNG, natural gas, or other midstream operations and data environments.

Design, build, and maintain scalable data pipelines for structured, semi-structured, and unstructured data.
Develop data ingestion and extract-load (EL) processes using Informatica or comparable enterprise data integration tools.
Build transformation logic using dbt, including modular models, testing, documentation, and deployment workflows.
Design, optimize, and manage data structures within Snowflake as the organization's strategic cloud data platform.
Develop and support data solutions within AWS cloud environments.
Implement data architectures using Apache Iceberg managed tables, leveraging open table formats, interoperability, cataloging, and governed access patterns.
Utilize Snowflake Catalog and Snowflake Horizon to support metadata management, data 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 business concepts, entities, relationships, and terminology.
Support ontology-driven data modeling, including semantic models, taxonomies, business glossaries, and metadata management.

Strong experience in data engineering, data modeling, ETL/ELT development, and cloud-based data platforms.
Hands-on experience with Snowflake, including data modeling, performance optimization, security, access controls, and scalable warehouse/lakehouse architectures.
Experience working in AWS cloud environments.
Experience with Informatica or similar enterprise data integration platforms.
Experience with dbt for data transformations, testing, documentation, and analytics engineering workflows.
Familiarity with data cataloging, governance, metadata management, lineage, and policy-based data access.
Strong SQL skills and proficiency in Python or another modern programming language used for data engineering.

Experience with Snowflake Catalog and Snowflake Horizon.
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 deployment practices for data engineering.
Experience implementing data observability, lineage tracking, data contracts, and data quality frameworks.
Experience working within large-scale enterprise data environments supporting multiple business domains and stakeholder groups.
Ideal Candidate Profile

This listing is sourced directly from AOB Recruitment's careers page and normalized into a canonical job model.