Data Engineer - Data Modeler

Robotics Technologies; Houston (TX); On-site; USD 76,000 - 108,000; Full time

Job summary

Robotics Technologies is seeking a Data Engineer - Data Modeler on a contract basis in Houston, Texas. The role centers on designing, governing, and evolving enterprise data models for Oracle environments, with hands-on work using Erwin Data Modeler to translate business needs into implementable structures.

You will ensure consistent model implementation across Oracle systems and support mission-critical processes through conceptual, logical, and physical modeling.

Qualifications

• 5+ years of hands-on experience in data modeling, data architecture, or database design roles.
• Expert proficiency with Erwin Data Modeler (9.x or higher preferred), including DDL generation and forward/reverse engineering.
• Advanced SQL skills and strong Oracle knowledge (11g/12c/19c/21c).
• Experience building normalized (3NF) transactional models and dimensional models (star/snowflake).
• Strong knowledge of DDL, including creating and modifying tables, indexes, constraints, sequences, synonyms, and materialized views.

Responsibilities

• Design, develop, and maintain enterprise-grade data models supporting critical business initiatives, analytics, and operational systems
• Translate business and analytical requirements into robust conceptual, logical, and physical data models
• Ensure enterprise models are implemented consistently across Oracle environments
• Design, govern, and evolve enterprise data models for mission-critical business processes

Skills

Data modeling

SQL

Oracle

Dimensional modeling

3NF normalization

DDL

Tools

Erwin Data Modeler

Job description

Robotics Technologies is hiring a Data Engineer - Data Modeler on a contract basis in Houston, Texas (onsite). The role centers on designing, governing, and evolving enterprise data models for Oracle environments, with hands‑on work using Erwin Data Modeler to translate business and analytical needs into implementable structures.

You will be responsible for ensuring consistent model implementation across Oracle systems while supporting mission‑critical processes through clear conceptual, logical, and physical modeling. This position is designed for experienced data professionals who can combine strong modeling discipline with advanced SQL and practical Oracle knowledge.

Responsibilities

• Design, develop, and maintain enterprise‑grade data models supporting critical business initiatives, analytics, and operational systems
• Translate business and analytical requirements into robust conceptual, logical, and physical data models
• Ensure enterprise models are implemented consistently across Oracle environments
• Design, govern, and evolve enterprise data models for mission‑critical business processes

Requirements

• 5+ years of hands‑on experience in data modeling, data architecture, or database design roles
• Expert proficiency with Erwin Data Modeler (9.x or higher preferred), including subject areas, model templates, DDL generation, forward/reverse engineering, model versioning, and complete compare functionality
• Advanced SQL skills and strong understanding of Oracle 11g/12c/19c/21c, including SQL, PL/SQL, schema design, and performance tuning fundamentals as they relate to data model design
• Demonstrated experience building both normalized (3NF) transactional models and dimensional models (star/snowflake) for reporting and analytics
• Strong command of DDL, including creating and modifying tables, indexes, constraints, sequences, synonyms, and materialized views

Technologies

• Erwin Data Modeler
• SQL, PL/SQL
• Oracle (11g/12c/19c/21c)
• DDL, Materialized views
• 3NF
• Star/snowflake dimensional modeling

Nice to have

• Experience in a regulated industry (utilities, financial services, insurance, healthcare) with data governance and compliance requirements
• Familiarity with additional modeling or metadata tools such as ER/Studio, PowerDesigner, Collibra, or Alation
• Exposure to cloud data platforms (Oracle Cloud, AWS, Azure, Snowflake, Databricks) and hybrid on‑prem/cloud modeling scenarios
• Working knowledge of ETL/ELT tools and data integration patterns
• Experience supporting master data management (MDM) or data governance initiatives
• Experience with Microsoft SQL Server
• Experience with PostgreSQL
• Data vault experience
• Experience with Hadoop/MongoDB

Location: Houston, TX (onsite). Compensation: USD 67 per hour. Experience: 5+ years. Job type: contract.