Talent.com
Oracle Data Modeler
Oracle Data ModelerYoh, A Day & Zimmermann Company • Dallas, Texas
Oracle Data Modeler

Oracle Data Modeler

Yoh, A Day & Zimmermann Company • Dallas, Texas
[job_card.30_days_ago]
[job_preview.job_type]
  • [job_card.temporary]
[job_card.job_description]

Oracle Data Modeler (Erwin)
6+ month contract (W2 ONLY - NO C-C)
Downtown Dallas, TX (Onsite)

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 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).
  • 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: $63.00
Estimated Max Rate: $90.00


What’s In It for You?
We welcome you to be a part of the largest and legendary global staffing companies to meet your career aspirations. Yoh’s network of client companies has been employing professionals like you for over 65 years in the U.S., UK and Canada. Join Yoh’s extensive talent community that will provide you with access to Yoh’s vast network of opportunities and gain access to this exclusive opportunity available to you. Benefit eligibility is in accordance with applicable laws and client requirements. Benefits include:

  • 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. All qualified applicants are welcome to apply.

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.

By applying and submitting your resume, you authorize Yoh to review and reformat your resume to meet Yoh’s hiring clients’ preferences. To learn more about Yoh’s privacy practices, please see our Candidate Privacy Notice: https://www.yoh.com/privacy-notice
[job_alerts.create_a_job]

Oracle Data Modeler • Dallas, Texas

[internal_linking.similar_jobs]

Technical Architect-Big Data Analytics (Remote)

Jobright.aiDallas, TX, United States
[filters.remote]
[job_card.full_time]

Technical Architect-Big Data Analytics (Remote).Technical Architect-Big Data Analytics (Remote).Technical Architect-Big Data Analytics (Remote).Be among the first 25 applicants.Technical Architect-...[internal_linking.show_more]

 • [job_card.promoted]

GenAI Data Architect - Hybrid (Dallas or KC)

Highbrow LLCDallas, TX, United States
[job_card.full_time]

A tech consulting company is seeking a Data Architect to design and develop data pipelines and lead complex framework implementations.The ideal candidate will have extensive experience in data engi...[internal_linking.show_more]

 • [job_card.promoted]

Senior Oracle ERP Architect: Fusion Cloud & EBS (Remote)

CoSourcing Partners Inc.Dallas, TX, United States
[filters.remote]
[job_card.full_time]

A leading consulting firm is seeking a Senior Enterprise Architect specializing in Oracle Fusion Cloud and E-Business Suite to drive a major ERP modernization initiative for a global retailer.This ...[internal_linking.show_more]

 • [job_card.promoted]

Senior Associate - Modeling Analytics

JPMorgan ChasePlano, TX, United States
[job_card.full_time]

Senior Associate - Modeling Analytics.Bring your expertise to JPMorgan Chase.As part of Risk Management and Compliance, you are at the center of keeping JPMorgan Chase strong and resilient.You help...[internal_linking.show_more]

 • [job_card.promoted]

Architect, Data

CrederaDallas, TX, United States
[job_card.full_time]

Be among the first 25 applicants.Credera is a global consulting firm that combines transformational consulting capabilities, deep industry knowledge, AI and technology expertise to deliver valuable...[internal_linking.show_more]

 • [job_card.promoted]

Data Architect

OscarDallas, TX, United States
[job_card.full_time]

This range is provided by Oscar.Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.Job Title: Databricks Data Engineer.Location: On-Site (Multiple ...[internal_linking.show_more]

 • [job_card.promoted]

Database Engineer

Veloc IncPlano, TX, US
[job_card.full_time]

Data Engineer Key Responsibilities Design, develop, and maintain scalable data pipelines on GCP Build and optimize ETL/ELT workflows using tools like Dataflow, Dataproc, and Cloud Composer Develop ...[internal_linking.show_more]

 • [job_card.promoted]

Business Intelligence Consultant/ Tableau Architect

Pyramid Technology SolutionsDallas, TX, United States
[job_card.full_time]

Business Intelligence Consultant/ Tableau Architect.Malvern, PA, Dallas, TX, or Charlotte, NC - Hybrid.We are looking for a strong Tableau Tech lead with SQL experience.Bachelor's Degree in Compute...[internal_linking.show_more]

 • [job_card.promoted]

Enterprise Data Architect

ConceroAddison, TX, United States
[job_card.full_time]

This range is provided by Concero.Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.Direct message the job poster from Concero.MUST BE ABLE TO GO ...[internal_linking.show_more]

 • [job_card.promoted]

ML Solution Architect

JobotDallas, TX, United States
[job_card.full_time]

Opportunity to join the industry’s top AI consulting firm, building out both traditional machine learning and cutting-edge generative AI projects of the future.We are seeking a dynamic and innovati...[internal_linking.show_more]

 • [job_card.promoted]

Senior Oracle Cloud Payroll Architect

IBMDallas, Texas, US
[job_card.full_time]

A career in IBM Consulting is rooted by long-term relationships and close collaboration with clients across the globe.You'll work with visionaries across multiple industries to improve the hybrid c...[internal_linking.show_more]

 • [job_card.promoted] • [job_card.new]

Oracle Fusion ERP Cloud Tech Architect | Integrations & BI

Simarn, Inc.Dallas, TX, United States
[job_card.full_time]

A technology solutions provider in Texas is looking for an experienced Oracle Fusion Technical Architect to design and implement secure solutions across the Oracle Fusion ERP Cloud.The role involve...[internal_linking.show_more]

 • [job_card.promoted]

Remote Oracle EBS Techno-Functional Consultant

Infovity, Inc.Dallas, TX, United States
[filters.remote]
[job_card.full_time]

A dynamic and experienced Oracle Techno-Functional Consultant is sought by a premier Oracle Applications consulting firm in Dallas, Texas.This role involves optimizing technical solutions for Oracl...[internal_linking.show_more]

 • [job_card.promoted]

Oracle EBS R12 QA

CoforgeDallas, TX, United States
[job_card.full_time]

We at Coforge are hiring Oracle EBS R12 QA with the following skillset :.Order Management, Shipping, Inventory.Transactions, On-hand, Reservations, Sub-inventory movements.Discrete jobs, completion...[internal_linking.show_more]

 • [job_card.promoted]

Data-Centric Software Architect: Observability & Security

Stealth StartupDallas, TX, United States
[job_card.full_time]

A technology-driven company in Fort Worth is looking for a hands-on Software Architect to lead the design and evolution of their platforms.This role involves defining system boundaries, data contra...[internal_linking.show_more]

 • [job_card.promoted]

Oracle Fusion Compensation Cloud

AA2ITRichardson, TX, United States
[job_card.full_time]

Total Rewards Analyst/Compensation Sr.Consultant, you will provide expert guidance and hands-on support for our Oracle Fusion Compensation Cloud module.This contract role is ideal for a seasoned co...[internal_linking.show_more]

 • [job_card.promoted]

Head, AI Semantic Modeling

ScotiabankDallas, TX, United States
[job_card.full_time]

Title: Head, AI Semantic Modeling.Scotiabank is seeking a visionary leader to serve as the Head of AI Semantic Modeling, guiding the development and implementation of semantic capabilities that wil...[internal_linking.show_more]

 • [job_card.promoted]

Data & AI Enterprise Architect — Modeling & AI Enablement

Insight GlobalPlano, TX, United States
[job_card.full_time]

A leading staffing firm in the United States is seeking a Data and AI Enterprise Architect.The role involves designing enterprise-level semantic data models and collaborating with various teams to ...[internal_linking.show_more]