Snowflake Architect / Data Architect
Venturatalents
Get a reply from this employer
Your resume and cover letter, tailored to exactly what they’re hiring for.
Job summary
Venturatalents seeks a Snowflake Architect / Data Architect in Houston to design, build, and scale a modern cloud data platform centered on Snowflake and AWS. This hands-on role blends architecture with engineering, delivering trusted, reusable data products that power analytics, AI, and business intelligence across the enterprise.
You will own pipelines, governance, and semantic layers, collaborate with data governance teams and business stakeholders, and apply GenAI capabilities to enterprise
Qualifications
- 8+ years in data engineering or architecture.
- Proven Snowflake data architecture and enterprise-scale design.
- Experience with Claude AI / GenAI in production.
- Oil & Natural Gas Midstream domain experience is mandatory.
- Strong data governance, metadata management, and semantic modeling.
- Hands-on with AWS data services and data pipelines.
Responsibilities
- Design, build, and scale a cloud data platform centered on Snowflake and AWS.
- Develop data ingestion and ELT processes using Informatica.
- Build modular dbt transformation models with testing.
- Implement data quality checks, lineage, and governance controls.
- Collaborate with data stakeholders to deliver trusted data products.
Skills
Tools
Job description
Location: Houston, Texas (Onsite/Hybrid - Relocation considered)
Employment Type: Full-time / Enterprise Data Platform
Work Authorization: USC / GC / GC EAD / H4 EAD / L2 ONLY
Experience: 8+ years in Data Engineering / Architecture
Domain: Oil & Natural Gas Midstream Mandatory + GenAI
We are seeking a Snowflake Architect / Data Architect to design, build, and scale a modern cloud data platform centered on Snowflake and AWS.
You will be part of strategic data initiatives building trusted, reusable, governed data products that power analytics, AI, and business intelligence across the enterprise. This is a hands-on architecture + engineering role - not just modeling, but building pipelines, governance, and semantic layers at enterprise scale.
This is an excellent opportunity for a hands-on Data Architect who understands that data engineering is not only about moving data, but about making data trusted, discoverable, governed, and meaningful.
- Design, build, and maintain scalable data pipelines across structured, semi-structured, and unstructured data sources
- Develop data ingestion and ELT processes using Informatica, aligning with enterprise standards
- Build transformation logic using dbt - modular models, testing, documentation, deployment workflows
- Design and manage data structures in Snowflake as the central strategic data platform - modeling, performance optimization, security, access controls
- Work with AWS data services: S3, Glue, Lambda, Athena, EMR, Redshift and cloud-based architectures
- Support data architecture using Iceberg managed tables - open table formats, interoperability, cataloging, governed access patterns
- Use Snowflake Catalog and Snowflake Horizon for metadata management, data discovery, governance, lineage, policy enforcement, trusted sharing
- Collaborate with data architects, governance teams, analysts, application teams, business stakeholders to define trusted data products
- Work with domain experts to understand business concepts, entities, relationships, terminology in Oil & Gas Midstream domain
- Support ontology-driven modeling: entity definitions, taxonomies, relationships, business glossaries, semantic mappings
- Translate business/domain concepts into logical data models, physical models, and reusable data products
- Implement data quality checks, validation rules, lineage, observability, and governance controls
- Support data products for analytics and AI-enabled use cases (e.g., asset intelligence, news intelligence)
- Ensure solutions meet enterprise requirements for security, privacy, access control, performance, reliability
- Strong Snowflake Data Architecture experience - Data modeling, data warehouse/lakehouse design, performance optimization, security, access controls, enterprise-scale implementations
- Data Governance & Metadata Management expertise - Hands-on with data cataloging, metadata management, data lineage, data quality, governance frameworks, policy-driven access
- Understanding of Ontology & Semantic Modeling - taxonomies, business glossaries, semantic mappings, RDF/OWL/SHACL/SPARQL, knowledge graphs
- Working knowledge of AWS services: S3, Glue, Lambda, Athena, EMR, Redshift and cloud architectures
- Oil & Natural Gas Midstream domain experience (Mandatory) - pipeline, transportation, storage, LNG, natural gas, midstream operations data
- Claude AI / Generative AI experience (Mandatory) - Claude, LLM-based solutions, AI-ready data platforms, RAG architectures, GenAI implementations
- Stable work history - No job hoppers (consistent 2-4 year or 4+ year tenures preferred)
- Experience with Snowflake Catalog and Snowflake Horizon
- Experience building governed data products for analytics, AI, or applications
- Enterprise governance tooling, especially Informatica governance
- RDF, OWL, SHACL, SPARQL, graph databases, knowledge graph platforms
- Semantic layers, business glossaries, metadata models, domain ontologies
- CI/CD, Git, automated testing, deployment workflows for data pipelines
- Data observability, lineage tracking, data contracts, data quality frameworks
Snowflake | AWS (S3, Glue, Lambda, Athena, EMR, Redshift) | Iceberg | Snowflake Catalog & Horizon | Informatica | dbt | SQL | Python | Data Governance | Ontology & Semantic Modeling | Claude AI / GenAI / RAG
- 1. What is your work authorization / visa status? (USC/GC/GCEAD/H4EAD/L2 only)
- 2. Do you have direct professional experience with Claude AI or LLM-based solutions in production?
- 3. Do you have working knowledge of AWS services including S3, Glue, Lambda, Athena, EMR, Redshift? (Yes/No)
- 4. Rate your Snowflake security and access controls experience: No experience / Basic RBAC / Hands-on enterprise policies / Expert-level design
- 5. Rate your data lineage and data quality management experience
- 6. Rate your GenAI and RAG architecture experience
- 7. Describe your tenure history - multiple <1 year roles will be auto-rejected per client
- 8. Describe your Oil & Gas Midstream domain experience - pipeline, transportation, storage, LNG?
- 9. Describe your Ontology & Semantic Modeling experience
- 10. Are you currently in Houston, TX or open to relocation?
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
