Senior Oracle Data Modeler

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

Senior Oracle Data Modeler

12+ month contract

Downtown Dallas (Hybrid w/ onsite interview)

Expert proficiency with Erwin Data Modeler (version 9.x or higher preferred) - including subject areas, model templates, and DDL generation.

Primary responsibilities of the Data Modeler include designing, developing, and maintaining enterprise-grade data models that support critical business initiatives, analytics, and operational systems. The ideal candidate is proficient in industry-standard data modeling tools (with hands‑on expertise in erwin Data Modeler) and has deep experience with Oracle and SQL Server databases. The candidate will also translate complex business requirements into robust, scalable, and normalized data models while ensuring alignment with data governance, performance, and integration standards.

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

Qualifications

• 3+ years of hands‑on data modeling 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

Estimated Min Rate: $61.60

Estimated Max Rate: $95.00

Benefits

• Medical, Prescription, Dental & Vision Benefits (for employees working 20+ hours per week)
• Health Savings Account (HSA) (for employees working 20+ hours per week)
• Life & Disability Insurance (for employees working 20+ hours per week)
• MetLife Voluntary Benefits
• Employee Assistance Program (EAP)
• 401K Retirement Savings Plan
• Direct Deposit & weekly epayroll
• Referral Bonus Programs
• Certification and training opportunities

Note: Any pay ranges displayed are estimations. Actual pay is determined by an applicant's experience, technical expertise, and other qualifications as listed in the job description.

Yoh, a Day & Zimmermann company, is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.

Visit https://www.yoh.com/applicants-with-disabilities to contact us if you are an individual with a disability and require accommodation in the application process.

For California applicants, qualified applicants with arrest or conviction records will be considered for employment in accordance with the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act. All of the material job duties described in this posting are job duties for which a criminal history may have a direct, adverse, and negative relationship potentially resulting in the withdrawal of a conditional offer of employment.

It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.