Data Engineer

Robotics Technologies; Houston (TX); On-site; USD 120,000 - 160,000; Full time

Job summary

Robotics Technologies in Houston, TX, is hiring a Data Engineer to build a cloud-based data platform centered on Snowflake and AWS. You will design scalable pipelines, ingestion workflows with Informatica, and dbt transformations, while collaborating with data architects and stakeholders to produce trusted data products.

You'll work onsite in Houston, contributing to ontology-driven modeling, data governance, and observability practices to ensure quality and reliability across analytics, AI, and

Qualifications

• Proven experience in data engineering and cloud data platform development.
• 2
• Strong data modeling and ETL/ELT skills for scalable pipelines.
• 3
• Hands-on Snowflake expertise including modeling and access controls.
• 4
• Experience in AWS cloud environments and enterprise data tools.
• 5
• Proficient in dbt for transformations, testing, and analytics workflows.
• 6
• Solid SQL and Python programming abilities.
• 7
• Knowledge of ontology/semantic modeling concepts is a plus.

Responsibilities

• Design, build, and maintain scalable data pipelines across sources.
• 2
• Develop ingestion and ETL/ELT processes using Informatica.
• 3
• Create modular dbt models with testing, doc, and deployment workflows.
• 4
• Design and manage Snowflake data structures as the central platform.
• 5
• Support AWS-based data services and infrastructure for data products.
• 6
• Collaborate with data architects, governance, and stakeholders to define trusted data products.

Skills

Data engineering

Data modeling

ETL/ELT

SQL

Python

Stakeholder collaboration

Communication

Education

Bachelor's degree in Computer Science or related field

Tools

Snowflake

AWS

Informatica

dbt

Iceberg

Snowflake Catalog

Snowflake Horizon

CI/CD

Git

Job description

Data Engineer role focused on building a modern cloud data platform in Houston, TX (onsite), centered on Snowflake and AWS.

Responsibilities

• Design, build, and maintain scalable data pipelines across structured, semi-structured, and unstructured sources.
• Develop data ingestion and extract-load processes using Informatica, aligned to enterprise standards and in-house capabilities.
• Build transformation logic with dbt, including modular models, testing, documentation, and deployment workflows.
• Design and manage data structures in Snowflake, with Snowflake as the central strategic platform.
• Support AWS-based data services and infrastructure for applications and data products running in the organization’s AWS environment.
• Support data architecture with Iceberg managed tables and open table formats, covering interoperability, cataloging, and governed access patterns.
• Use Snowflake Catalog and Snowflake Horizon for metadata management, data discovery, governance, lineage, policy enforcement, and trusted data sharing.
• Collaborate with data architects, governance teams, analysts, application teams, and business stakeholders to define trusted data products.
• Work with domain experts to understand business concepts, entities, relationships, and terminology.
• Support ontology-driven modeling, including entity definitions, taxonomies, relationships, business glossaries, and semantic mappings.
• Translate business and domain concepts into logical data models, physical data models, and reusable data products.
• Implement data quality checks, validation rules, lineage, observability, and governance controls.
• Support data products and applications including news intelligence, asset intelligence, analytics, and AI-enabled use cases.
• Ensure solutions meet enterprise requirements for security, privacy, access control, performance, and reliability.

Requirements

• Strong experience in data engineering, data modeling, and ETL/ELT for cloud data platform development.
• Hands-on experience with Snowflake, including data modeling, performance optimization, access controls, and scalable warehouse/lakehouse patterns.
• Experience working in AWS cloud environments.
• Experience with Informatica or similar enterprise data integration tools for extract-load and ingestion patterns.
• Experience with dbt for transformations, testing, documentation, and analytics engineering workflows.
• Understanding of Apache Iceberg or open table formats, including managed tables, schema evolution, interoperability, and catalog-based access.
• Familiarity with data cataloging, governance, lineage, metadata management, and policy-driven data access.
• Understanding of ontology and semantic modeling concepts such as taxonomies, business glossaries, or knowledge graph ideas.
• Strong SQL skills and experience with Python or another data engineering language.
• Ability to work with business stakeholders to define data entities, relationships, metrics, and data product requirements.
• Strong communication, documentation, and problem-solving skills.

Technologies

• Snowflake, AWS, Iceberg, Apache Iceberg, Snowflake Catalog, Snowflake Horizon
• Informatica, dbt, Ingestion, ETL/ELT, SQL, Python
• Open table formats
• Ontology-driven modeling: RDF, OWL, SHACL, SPARQL, graph databases, knowledge graph platforms
• CI/CD, Git
• Data observability, lineage tracking, data contracts, data quality frameworks, semantic layers
• Metadata models, domain ontologies
• Additional noted item: Claude

Preferred Skills

• Experience with Snowflake Catalog and Snowflake Horizon.
• Experience building governed data products for analytics, AI, or application use cases.
• Experience with enterprise governance tooling, including Informatica governance capabilities.
• Experience with RDF, OWL, SHACL, SPARQL, graph databases, or knowledge graph platforms.
• Experience designing semantic layers, business glossaries, metadata models, or domain ontologies.
• Experience with CI/CD, Git, automated testing, and deployment workflows for data pipelines.
• Experience with data observability, lineage tracking, data contracts, and data quality frameworks.
• Experience working in complex enterprise data environments with multiple systems, domains, and stakeholder groups.