Data Modeler

Peyton Resource Group; Dallas (TX); On-site; USD 110,000 - 140,000; Full time

Job summary

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.

Qualifications

• 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.

Responsibilities

• 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.

Skills

Erwin Data Modeler

Advanced SQL

Oracle Database

Dimensional modeling

3NF normalization

Data dictionaries

Version control

Communication

Team collaboration

DDL scripting

Tools

Erwin Data Modeler

ER/Studio

PowerDesigner

Collibra

Alation

Git

Job description

Data Modeler We are 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. This role is responsible for translating business and analytical requirements into robust conceptual, logical, and physical data models, and for ensuring those models are implemented consistently across our Oracle environments.

Key Responsibilities

• Modeling & Design
  • Design, develop, and maintain enterprise-grade data models supporting critical business initiatives, analytics, and operational systems
  • Design and maintain conceptual, logical, and physical data models using Erwin Data Modeler, ensuring alignment with business requirements and enterprise data standards
  • Perform reverse engineering of existing Oracle databases into Erwin to document and rationalize legacy data structures
  • Ensure data models adhere to normalization standards (3NF), data integrity, and referential integrity
  • Support dimensional modeling (star/snowflake schemas) for data warehousing and analytics use cases
  • Support both OLTP and data warehouse/dimensional modeling efforts as needed
• Database Development & Deployment
  • Develop and manage Oracle database schemas, including tables, views, indexes, partitioning strategies, and constraints derived from approved data models
  • Generate, review, and optimize DDL scripts for database objects (tables, views, indexes, constraints, partitions, etc.) to support forward engineering of physical models, and coordinate schema deployment with DBAs and other engineering teams
  • Optimize data structures for performance, scalability, and maintainability within Oracle, working closely with DBAs on indexing and partitioning strategies
  • Assist in database migrations, schema comparisons, and synchronization between environments (Dev/QA/Prod)
• Governance & Standards
  • Establish and enforce data modeling standards, naming conventions, and metadata management practices across projects
  • Manage model versioning, subject areas, and complex model merges within Erwin's model management/mart environment
  • Lead data governance and data quality initiatives to maintain a business glossary, data lineage, and metadata repository tied to the models
  • Follow the organization's Data Governance Policy and Information Classification and Protection Policy
  • Conduct data model reviews and impact assessments for proposed schema changes, ensuring referential integrity and minimizing downstream disruption
• Collaboration & Documentation
  • Collaborate with data architects, DBAs, ETL developers, and stakeholders to gather complex business requirements and translate them into robust, scalable, normalized data models aligned with governance, performance, and integration standards
  • Partner with business analysts, data architects, application teams, and DBAs to translate requirements into scalable, normalized (and where appropriate, denormalized/dimensional) data structures
  • Document data models thoroughly, producing data dictionaries, ER diagrams, and supporting artifacts for technical and business stakeholders
  • Participate in design reviews and take guidance from the Data Architecture team

Required Qualifications

• 5+ years of hands‑on experience in data modeling, data architecture, or database design roles
• Expert proficiency with Erwin Data Modeler (version 9.X or higher preferred) —including subject areas, model templates, DDL generation, forward/reverse engineering, model versioning, and 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
• Demonstrated experience building both normalized (3NF) transactional models and dimensional models (star/snowflake) for reporting and analytics
• Strong command of DDL —creating and modifying tables, indexes, constraints, sequences, synonyms, and materialized views
• Solid understanding of data modeling theory: entity‑relationship modeling, normalization/denormalization, cardinality, keys, and referential integrity
• Solid grasp of database internals: indexing strategies, partitioning, clustering, and query execution plans
• Experience with data modeling best practices: normalization, denormalization, surrogate keys, and slowly changing dimensions (SCD)
• Experience producing and maintaining data dictionaries, metadata, and data lineage documentation
• Familiarity with version control (e.G., Git) and model comparison/diff tools
• Excellent communication skills, with the ability to clearly explain modeling decisions to both technical and non-technical audiences
• Self‑motivated, with the ability to multitask
• Works well in a team environment

Preferred Qualifications

• Experience in a regulated industry (utilities, financial services, insurance, healthcare) with associated data governance and compliance requirements
• Familiarity with additional modeling or metadata tools (e.G., ER/Studio, PowerDesigner, Collibra, Alation)
• Exposure to cloud data platforms (e.G., Oracle Cloud, AWS, Azure, Snowflake, Databricks) and hybrid on-prem/cloud modeling scenarios
• 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

Team Culture

The Data Management team environment is fast-paced, fun, and highly energetic and motivated. We expect candidates to integrate into our results-driven, solution-oriented culture from the get-go. Our team attains high-quality results on challenging projects, driven by the belief that outcomes are linked to effort rather than chance, and a tendency to set challenging yet realistic goals.