Data Engineer

a { text-decoration: none; color: #464feb; } tr th, tr td { border: 1px solid #e6e6e6; } tr th { background-color: #f5f5f5; }

Data Engineer

Location: Houston, TX | Onsite
Interview Process: 2 Virtual Rounds + 1 Onsite Round

Job Summary

STAFFXPERT LLC is seeking a Data Engineer / Data Architect on behalf of our client in Houston, Texas. We are looking for an experienced data professional to help design, build, and scale a modern cloud data platform leveraging Snowflake, AWS, Apache Iceberg, Informatica, and dbt.

The ideal candidate will bring strong expertise in data engineering, architecture, data governance, metadata management, and ontology-driven/semantic data modeling. Experience within the Oil & Gas Midstream domain, along with working knowledge of Claude, is required for this role.

Key Responsibilities

• Design, build, and maintain scalable data pipelines across structured, semi-structured, and unstructured data sources.

• Architect and optimize enterprise data solutions using Snowflake as a strategic data platform.

• Develop ingestion and ETL/ELT workflows using Informatica and transformation models using dbt.

• Work with AWS cloud services and infrastructure to support enterprise data products and applications.

• Build and manage data architectures using Apache Iceberg, including schema evolution, interoperability, cataloging, and governed access.

• Support data governance, metadata management, lineage, data discovery, and policy enforcement using Snowflake Catalog, Snowflake Horizon, and related governance tools.

• Develop ontology-driven and semantic data models, including entities, relationships, taxonomies, business glossaries, and semantic mappings.

• Translate business requirements into logical and physical data models and reusable data products.

• Implement data quality, validation, observability, security, and access-control standards.

• Collaborate with architects, governance teams, analysts, application teams, and business stakeholders.

• Support data products and use cases across analytics, business intelligence, applications, and AI.

Required Qualifications

• Strong experience in Data Engineering, Data Architecture, ETL/ELT, and enterprise data modeling.

• Hands-on expertise with Snowflake, including data modeling, performance optimization, access controls, and scalable data platform patterns.

• Strong working experience with AWS cloud environments.

• Experience with Apache Iceberg or similar open table formats.

• Experience with Informatica or comparable enterprise data integration tools.

• Hands-on experience with dbt for transformations, testing, documentation, and deployment.

• Strong understanding of data governance, cataloging, lineage, metadata management, and policy-driven data access.

• Experience or strong understanding of ontologies, semantic modeling, taxonomies, business glossaries, or knowledge graphs.

• Strong SQL skills with experience in Python or another data engineering language.

• Working knowledge of Claude is required.

• Oil & Gas Midstream domain experience is required.

• Strong communication, documentation, stakeholder management, and problem-solving skills.

Preferred Qualifications

• Experience with Snowflake Catalog and Snowflake Horizon.

• Experience building governed data products for analytics, AI, BI, or enterprise applications.

• 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 CI/CD, Git, automated testing, and deployment workflows.

• Experience with data observability, data contracts, lineage tracking, and data quality frameworks.

• Experience working in complex enterprise environments with multiple data domains and stakeholder groups.