Data Modeler (Oracle & Erwin) - 10 Month Engagement

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

Job summary

Ethereum Technologies in Houston, TX is seeking a Data Engineer - Data Modeler to design and maintain enterprise-grade data models supporting analytics and mission-critical business processes. The role focuses on translating business requirements into conceptual, logical, and physical models across Oracle environments.

You will leverage Erwin Data Modeler with advanced SQL skills, work with 3NF transactional designs and star/snowflake dimensional models, and ensure robust DDL across our data

Qualifications

• 5+ years in data modeling, data architecture, or database design.
• Expert with Erwin Data Modeler 9.x+ incl. model templates, DDL, forward/reverse engineering, versioning.
• Advanced SQL with Oracle (11g/12c/19c/21c), schema design and tuning.
• Experience modeling both 3NF transactional and star/snowflake dimensional models.
• Strong DDL skills: tables, indexes, constraints, sequences, synonyms, materialized views.

Responsibilities

• Design, develop, and maintain enterprise-grade data models for analytics and operations.
• Ensure models are consistent across Oracle environments.
• Translate business and analytical requirements into conceptual, logical, and physical models.

Skills

Data modeling

Data architecture

Database design

Erwin Data Modeler

SQL

PL/SQL

Oracle

3NF modeling

Dimensional modeling

DDL

Tools

Erwin Data Modeler

Oracle

ER/Studio

PowerDesigner

Collibra

Alation

Snowflake

Databricks

Job description

Ethereum Technologies in Houston, TX is seeking a Data Engineer - Data Modeler to design and maintain enterprise-grade data models supporting analytics and mission-critical business processes. The role focuses on translating business requirements into conceptual, logical, and physical models across Oracle environments.

You will leverage Erwin Data Modeler with advanced SQL skills, work with 3NF transactional designs and star/snowflake dimensional models, and ensure robust DDL across our data