Hybrid Dallas: Senior Oracle Data Modeler & Erwin Expert

Yoh, A Day & Zimmermann Company; 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

401K Retirement Savings Plan

Direct Deposit & weekly epayroll

Referral Bonus Programs

Certification and training

Job summary

Yoh, a Day & Zimmermann company, seeks a Senior Oracle Data Modeler for a 12+ month contract in Downtown Dallas, with hybrid work and onsite interview.

You will design, develop, and maintain enterprise data models using erwin Data Modeler and work with Oracle and SQL Server, ensuring normalization, data governance, and scalable performance.

Experience with 3+ years, DDL scripting, and collaboration with DBAs and analytics teams is required.

Qualifications

• 3+ years of hands‑on data modelling experience in enterprise environments.
• Expert proficiency with Erwin Data Modeler (version 9.x or higher preferred) – including subject areas, model templates, and DDL generation.
• Advanced SQL skills and deep understanding of Oracle (11g/12c/19c/21c) and Microsoft SQL Server (2016+).
• Strong command of DDL – creating and modifying tables, indexes, constraints, sequences, synonyms, and materialized views.
• Solid grasp of database internals: indexing strategies, partitioning, clustering, and query execution plans.
• Experience with data modeling best practices: normalization, denormalization, surrogate keys, slowly changing dimensions (SCD), and data vault (a plus).
• Familiarity with version control (e.g., Git) and model comparison/diff tools.
• Excellent communication skills – ability to document models clearly and present to technical and non‑technical audiences.
• Self‑Motivated, with an ability to multi‑task
• Capable of presenting to all levels of audiences
• Works well in a team environment
• Experience with Hadoop/MongoDB a plus

Responsibilities

• Design and develop conceptual, logical, and physical data models using erwin Data Modeler (required).
• Generate, review, and optimize DDL (Data Definition Language) 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).
• <b>A</b>ssist 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

Data Modeling

DDL scripting

Normalization

Git/version control

Tools

erwin Data Modeler 9.x+

Job description

Yoh, a Day & Zimmermann company, seeks a Senior Oracle Data Modeler for a 12+ month contract in Downtown Dallas, with hybrid work and onsite interview.

You will design, develop, and maintain enterprise data models using erwin Data Modeler and work with Oracle and SQL Server, ensuring normalization, data governance, and scalable performance.

Experience with 3+ years, DDL scripting, and collaboration with DBAs and analytics teams is required.