Senior Oracle Data Modeler | ERwin Expert | Hybrid Dallas

Yoh Services LLC; Dallas (TX); Hybrid; USD 85,000 - 131,000; Full time

Benefits offered by this job

Medical, Prescription, Dental & Vision

Health Savings Account

Life & Disability Insurance

MetLife Voluntary Benefits

Employee Assistance Program

401K Retirement Savings Plan

Direct Deposit & weekly epayroll

Referral Bonus Programs

Certification and training

Job summary

The position is hybrid with onsite interviews, offering collaboration with data architects, DBAs, ETL developers, and business stakeholders to translate complex requirements into scalable data models. Strong communication and team work are essential.

Qualifications

• 3+ years of hands-on enterprise data modeling experience.
• Expert in Erwin Data Modeler (v9.x+), including templates and DDL generation.
• Strong SQL skills with Oracle and SQL Server.
• Familiarity with data governance, normalization, and dimensional modeling.
• Experience with Git and model comparison tools.
• Excellent communication and teamwork.

Responsibilities

• Design and develop conceptual, logical, and physical data models using erwin Data Modeler (required).
• Generate and optimize DDL scripts for database objects (tables, views, indexes, constraints, partitions, etc.).
• Perform forward and reverse engineering of data models from existing Oracle and SQL Server databases.
• Collaborate with data architects, DBAs, ETL developers, and business stakeholders to gather and refine requirements.
• Ensure data models adhere to normalization standards (3NF/BCNF), data integrity, and referential integrity.
• Support dimensional modeling (star/snowflake schemas) for data warehousing and analytics use cases.
• Conduct model reviews, impact analysis, and version control using erwin or comparable tools.
• Participate in data governance initiatives, including metadata management, naming standards, and lineage documentation.
• Optimize models for performance, scalability, and maintainability across large-scale environments.
• Assist in database migrations, schema comparisons, and synchronization between environments (Dev/QA/Prod).
• Assist in optimizing existing Data Solutions.
• Follow Oncor's Data Governance Policy and Information Classification and Protection Policy.
• Participate in design reviews and take guidance from the Data Architecture team members.

Skills

Erwin Data Modeler

Oracle

SQL Server

DDL scripting

Normalization

Data governance

Team collaboration

Git

Performance tuning

Job description

The position is hybrid with onsite interviews, offering collaboration with data architects, DBAs, ETL developers, and business stakeholders to translate complex requirements into scalable data models. Strong communication and team work are essential.