Enterprise Data Architect | Oracle On-Prem & Erwin

Yoh; Dallas (TX); On-site; USD 85,000 - 121,000; Full time

Job summary

Yoh is seeking a Data Architect to own enterprise data architecture, governance, and standards on Oracle on-premise platforms. You will mentor data modelers, ensure high-volume performance, and drive MDM and data governance initiatives across the organization. Strong communication with leadership is essential.

Ideal candidates have 10+ years in data architecture, deep Erwin expertise, and experience with Denodo for data virtualization; familiarity with regulated industries is a plus.

Qualifications

• 10+ years of experience in data architecture, data modeling, or database engineering.
• Expertise with Erwin Data Modeler at an enterprise scale.
• Strong Oracle Database (on-premise) know-how with SQL/PL-SQL, partitioning, indexing, performance tuning.
• Experience modeling for GB to multi-TB data volumes in regulated environments.
• Strong data modeling theory and dimensional modeling for analytics.
• Experience defining enterprise data standards, governance and metadata/lineage.
• Knowledge of Data Movement and Processing including Middleware, ETL, API, OLAP.
• Ability to communicate complex architectural concepts to leadership.

Responsibilities

• Define and own enterprise data architecture strategy and reference architectures.
• Establish data modeling standards, naming conventions, and governance.
• Own the enterprise Erwin model repository and ensure cross-model consistency.
• Translate business strategy into a long-term data architecture roadmap.
• Architect for scalability and performance of large Oracle databases.
• Promote Data Virtualization (Denodo) across the enterprise.
• Review data models for alignment with standards and performance.
• Lead reverse-engineering of legacy Oracle schemas.
• Guide OLTP/3NF and dimensional modeling approaches.
• Mentor data modelers, ETL developers, and DBAs.
• Present architecture decisions to senior leadership.

Skills

Data architecture

Erwin Data Modeler

Oracle Database

Data governance

Master Data Management

Leadership

Stakeholder communication

Performance tuning

Data modeling theory

Mentoring teams

Tools

Erwin Data Modeler

Oracle database

Denodo

ER/Studio

Power Designer

Collibra

Alation

Postgres

Job description

Yoh is seeking a Data Architect to own enterprise data architecture, governance, and standards on Oracle on-premise platforms. You will mentor data modelers, ensure high-volume performance, and drive MDM and data governance initiatives across the organization. Strong communication with leadership is essential.

Ideal candidates have 10+ years in data architecture, deep Erwin expertise, and experience with Denodo for data virtualization; familiarity with regulated industries is a plus.