Lead Data Modeler: Erwin & Oracle Expert (Onsite)

Cbase Inc.; Dallas (TX); On-site; USD 90,000 - 150,000; Full time

Job summary

Cbase Inc. is seeking an experienced Lead Data Modeler to design and govern enterprise data models using Erwin Data Modeler and Oracle databases. You will translate business needs into conceptual, logical, and physical models and ensure consistent implementation across Oracle environments.

The role requires hands-on experience with 3NF transactional models and dimensional designs, collaboration with stakeholders, and a focus on data governance and metadata management.

Qualifications

• 5+ years of hands-on experience in Data Modeling, Data Architecture, or Database Design.
• Strong proficiency with Erwin Data Modeler (Version 9.x or higher preferred).
• Strong experience with Oracle Database (11g/12c/19c/21c).
• Advanced SQL and PL/SQL skills.

Responsibilities

• Design, develop, and maintain enterprise-grade conceptual, logical, and physical data models.
• Translate business and analytical requirements into scalable and efficient database designs.
• Use Erwin Data Modeler for subject areas, model templates, DDL generation, forward/reverse engineering, model versioning, and model comparisons.
• Design normalized (3NF) transactional models and dimensional models (Star/Snowflake schemas).
• Develop and maintain Oracle database objects, including tables, indexes, constraints, sequences, synonyms, and materialized views.
• Collaborate with business stakeholders, architects, developers, and data engineering teams.
• Support data governance, metadata management, and enterprise data architecture initiatives.

Skills

Data Modeling

Data Architecture

SQL/PLSQL

Requirements translation

Tools

Erwin Data Modeler (v9.x+)

Oracle Database

Job description

Cbase Inc. is seeking an experienced Lead Data Modeler to design and govern enterprise data models using Erwin Data Modeler and Oracle databases. You will translate business needs into conceptual, logical, and physical models and ensure consistent implementation across Oracle environments.

The role requires hands-on experience with 3NF transactional models and dimensional designs, collaboration with stakeholders, and a focus on data governance and metadata management.