Data Engineer – Snowflake / AWS / Oil & Gas Midstream

Full-time
On-site
$130,000-140,000/yr
Houston, TX
No visa sponsorship

Job description

Job Title: Data Engineer – Snowflake / AWS / Oil & Gas Midstream


Location: Houston, TX
Job Type: Full Time
Experience: 12–18 Years
Work Authorization: USC / GC / GC EAD / H4 EAD / L2 only


Job Summary


We are looking for a highly experienced Data Engineer / Data Architect with strong expertise in Snowflake, AWS, Data Governance, Ontology/Semantic Modeling, and Generative AI.


The ideal candidate must have hands-on experience working within the Oil & Natural Gas Midstream domain, including pipeline, transportation, storage, LNG, natural gas, or related midstream operations.


Must-Have Requirements


  • Strong Snowflake Data Architecture experience, including:
    • Data modeling
    • Data warehouse/lakehouse design
    • Performance optimization
    • Security and access controls
    • Enterprise-scale Snowflake implementations


  • Strong Data Governance & Metadata Management experience:
    • Data cataloging
    • Metadata management
    • Data lineage
    • Data quality
    • Governance frameworks
    • Policy-driven data access


  • Understanding of Ontology & Semantic Modeling.


  • Strong working knowledge of AWS data services, including:
    • S3
    • Glue
    • Lambda
    • Athena
    • EMR
    • Redshift
    • Cloud-based data architectures


  • Oil & Natural Gas Midstream domain experience – Mandatory
    • Pipeline operations
    • Transportation
    • Storage
    • LNG
    • Natural Gas
    • Midstream operations and data environments


  • Claude AI / Generative AI experience – Mandatory
    • Claude / Anthropic
    • LLM-based solutions
    • RAG architectures
    • Generative AI implementations
    • AI-ready data platforms


  • Stable employment history / No frequent job hopping.


Preferred Experience


  • Snowflake Catalog
  • Snowflake Horizon
  • Informatica
  • Apache Iceberg
  • Data lineage and observability
  • Data quality frameworks
  • Semantic layers
  • Knowledge graphs
  • RDF / OWL / SHACL / SPARQL
  • Python
  • SQL
  • Git / CI/CD
  • Enterprise data platforms
  • AI/ML data architecture


Ideal Candidate


The ideal candidate will combine strong enterprise data architecture expertise with deep Oil & Gas Midstream domain knowledge and practical experience implementing GenAI/LLM solutions.


Core Skills:


Snowflake, Snowflake Architecture, AWS, S3, Glue, Lambda, Athena, EMR, Redshift, Data Governance, Metadata Management, Data Catalog, Data Lineage, Data Quality, Ontology, Semantic Modeling, Knowledge Graph, Claude AI, Anthropic, Generative AI, LLM, RAG, AI Data Platform, Oil & Gas, Midstream, Pipeline, LNG, Natural Gas, Gas Transportation, Gas Storage.

More information

Experience level

Expert and leadership (8+years)

Job skills

Snowflake

AWS

Data Warehousing

ETL Processes

SQL

Data Modeling

Big Data Technologies

Data Governance

Semantic Modeling

Ontology

Company overview

company-logo
Acerra Consulting Jobs

1-10 employees

Finding the right talent isn’t just about filling positions—it’s about building successful teams that drive business growth. At Acerra Consulting, we specialize in end-to-end recruitment and staffing solutions across IT, Non-IT, Healthcare, and BFSI industries, both domestically and internationally. With a deep understanding of industry trends and hiring challenges, we connect top-tier professionals with organizations that value expertise, innovation, and long-term success. Whether it's executive search, permanent staffing, or project-based hiring, we tailor our approach to meet your business needs. What we offer: ✅ Strategic talent acquisition across India, USA & UAE ✅ A vast pre-screened candidate network ✅ Industry-specific hiring solutions for startups & enterprises ✅ Commitment to quality, speed, and efficiency At Acerra Consulting, we don’t just find talent—we build futures and strengthen businesses. Let’s connect and explore how we can collaborate to drive your hiring success!