Senior Oracle Data Modeler | Erwin Specialist - Onsite TX

Nava Software Solutions LLC; Dallas (TX); Presencial; USD 120 000 - 150 000; Tempo integral

Resumo da oferta

NAVA Software is seeking a Sr Data Modeler to design, govern, and evolve enterprise data models across Oracle environments. The role emphasizes translating business requirements into conceptual, logical, and physical models and ensuring consistency in implementations with Erwin Data Modeler.

The ideal candidate will have deep Oracle/SQL experience, strong data governance sense, and the ability to collaborate with DBAs, data architects, ETL teams, and stakeholders to deliver scalable,

Qualificações

• 5+ years of hands-on data modeling, data architecture, or database design experience.
• Expert in Erwin Data Modeler (v9.x+), including DDL generation and reverse engineering.
• Advanced Oracle (11g/12c/19c/21c), SQL/PLSQL, and performance tuning basics as they relate to data model design.
• Experience with normalized (3NF) and dimensional (star/snowflake) models for reporting/analytics.
• DDL skills: create/modify tables, indexes, constraints, sequences, synonyms, materialized views.
• Data modeling theory: ER modeling, normalization/denormalization, keys, referential integrity.
• Indexing, partitioning, clustering, and query plans understanding.
• Experience with SCD, metadata, data dictionaries, lineage documentation.
• Version control (Git) and model comparison/diff tools.
• Strong communication and teamwork abilities.

Responsabilidades

• Design, develop, and maintain enterprise data models for OLTP and data warehousing.
• Collaborate with data architects, DBAs, ETL developers, and stakeholders to translate requirements into scalable models.
• Design and maintain conceptual, logical, and physical models using Erwin and align with standards.
• Develop Oracle schemas: tables, views, indexes, partitions, constraints.
• Partner with teams to translate requirements into normalized and dimensional structures.
• Establish and enforce data modeling standards and metadata practices.
• Reverse engineer existing Oracle databases into Erwin to document legacy structures.
• Manage model versioning and merges in Erwin's environment.
• Produce data dictionaries, ER diagrams, and metadata artifacts.
• Ensure normalization and referential integrity and support data governance.

Conhecimentos

Erwin Data Modeler

Oracle

SQL

Data modeling

3NF

Performance tuning

Schema design

Data governance

Metadata

Version control

Ferramentas

Erwin Data Modeler

PowerDesigner

ER/Studio

Collibra

Alation

Descrição da oferta de emprego

NAVA Software is seeking a Sr Data Modeler to design, govern, and evolve enterprise data models across Oracle environments. The role emphasizes translating business requirements into conceptual, logical, and physical models and ensuring consistency in implementations with Erwin Data Modeler.

The ideal candidate will have deep Oracle/SQL experience, strong data governance sense, and the ability to collaborate with DBAs, data architects, ETL teams, and stakeholders to deliver scalable,