Data Engineer - Data Modeler

Robotics Technologies is hiring a Data Engineer - Data Modeler for an onsite contract role in Houston, TX. In this position, you will design and govern enterprise data models that keep mission-critical business processes running reliably across Oracle environments, using Erwin Data Modeler to translate requirements into consistent conceptual, logical, and physical structures.

This contract role is ideal for experienced data modeling professionals who enjoy turning business and analytical needs into well-governed models, with strong hands-on skills in SQL, PL/SQL, and Oracle database design and performance fundamentals.

Responsibilities

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

Requirements

• 5+ years of hands-on experience in data modeling, data architecture, or database design roles
• Expert proficiency in Erwin Data Modeler (version 9.x or higher preferred), including:
  • subject areas
  • model templates
  • DDL generation
  • forward and reverse engineering
  • model versioning
  • complete compare functionality
• Advanced SQL skills and deep understanding of Oracle (11g/12c/19c/21c), including SQL, PL/SQL, schema design, and performance tuning fundamentals as they relate to data model design
• Proven experience building normalized transactional models (3NF) 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 (ER/Studio, PowerDesigner, Collibra, Alation)
• Exposure to cloud and hybrid on-prem/cloud modeling scenarios (Oracle Cloud, AWS, Azure, Snowflake, Databricks)
• Working knowledge of ETL/ELT tools and data integration patterns
• Experience supporting master data management (MDM) or data governance initiatives
• Experience working with Microsoft SQL Server
• Experience working with PostgreSQL
• Data vault experience
• Experience with Hadoop/MongoDB

Location: Houston, TX (onsite)

Compensation: USD 67 per hour

Job type: Contract