Senior Data Engineer / Data Architect – Snowflake, AWS, dbt, Informatica

Job Description

We are seeking an experienced Senior Data Engineer / Data Architect to design, build, and scale a modern cloud data platform centered on Snowflake and AWS. The ideal candidate will have strong hands-on experience in enterprise data engineering, data governance, metadata management, and ontology-driven data modeling.

The role involves building scalable data pipelines and governed data products using Snowflake, AWS, Apache Iceberg, Informatica, and dbt. Candidates should also have experience with semantic modeling, ontologies, taxonomies, business glossaries, and knowledge graph concepts.

Key Responsibilities

• Design, develop, and maintain scalable ETL/ELT data pipelines.

• Build and optimize data models and transformations using Snowflake and dbt.

• Develop data ingestion processes using Informatica.

• Work with AWS cloud services and infrastructure.

• Support Apache Iceberg managed tables and open table formats.

• Implement data governance, cataloging, lineage, metadata management, and access controls.

• Work with Snowflake Catalog and Snowflake Horizon.

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

• Translate business requirements into logical and physical data models.

• Implement data quality checks, validation, and governance controls.

• Collaborate with data architects, business stakeholders, and engineering teams.

Required Skills

• 5+ years of hands-on experience with Snowflake.

• 5+ years of AWS experience.

• 3+ years of dbt experience.

• 3+ years of Informatica experience.

• 5+ years of SQL experience.

• Strong data engineering, ETL/ELT, and data modeling experience.

• Experience with Apache Iceberg or open table formats.

• Knowledge of data governance, metadata management, and data lineage.

• Understanding of ontology, semantic modeling, taxonomies, and knowledge graphs.

• Strong Python or other data engineering programming experience.

• Hands-on experience using Claude is mandatory.

• Working knowledge of the Oil & Gas Midstream domain.

Preferred Skills

• Snowflake Catalog and Snowflake Horizon.

• Informatica governance capabilities.

• RDF, OWL, SHACL, SPARQL, and graph databases.

• Data observability, CI/CD, Git, and automated testing.

• Experience building governed data products for AI and analytics.

Interview Process: 3 rounds.
Industry: Oil & Gas – Midstream.
Position Type: Contract / Full-time (as applicable).