Senior Oracle Data Modeler (Erwin Expert)

Peyton Resource Group; Dallas (TX); Presencial; USD 110 000 - 140 000; Tempo integral

Resumo da oferta

Peyton Resource Group is seeking a Data Modeler with deep expertise in Oracle database platforms and Erwin data modeling to design, govern, and evolve enterprise data models that support mission-critical business processes.

You will translate business and analytical requirements into conceptual, logical, and physical models, ensuring consistency across our Oracle environments and collaboration with DBAs and analytics teams.

Qualificações

• 5+ years of hands-on data modeling, data architecture, or database design experience.
• Expert proficiency with Erwin Data Modeler (v9.x or higher).
• Advanced SQL skills and deep Oracle knowledge (11g/12c/19c/21c).
• Experience building both normalized (3NF) and dimensional models.

Responsabilidades

• Model, design, and maintain enterprise-grade data models for critical business initiatives.
• Design conceptual, logical, and physical models using Erwin and ensure alignment with standards.
• Reverse engineer existing Oracle databases into Erwin to document legacy structures.
• Ensure models meet 3NF standards, data integrity, and referential integrity.
• Support dimensional modeling for data warehousing and analytics.
• Develop and manage Oracle schemas, including tables, views, indexes, and constraints.
• Generate and optimize DDL scripts for forward engineering and deployments.
• Collaborate with DBAs and engineering teams on migrations and deployments.
• Establish data modeling standards, governance, and metadata management.
• Document data models with dictionaries, ER diagrams, and supporting artifacts.
• Participate in design reviews and guidance from Data Architecture team.

Conhecimentos

Erwin Data Modeler

Advanced SQL

Oracle Database

Dimensional modeling

3NF normalization

Data dictionaries

Version control

Communication

Team collaboration

DDL scripting

Ferramentas

Erwin Data Modeler

ER/Studio

PowerDesigner

Collibra

Alation

Git

Descrição da oferta de emprego

Peyton Resource Group is seeking a Data Modeler with deep expertise in Oracle database platforms and Erwin data modeling to design, govern, and evolve enterprise data models that support mission-critical business processes.

You will translate business and analytical requirements into conceptual, logical, and physical models, ensuring consistency across our Oracle environments and collaboration with DBAs and analytics teams.