Senior Data Architect: Oracle & Metadata for GenAI

SMARTFOX; Plano (TX); On-site; USD 140,000 - 210,000; Full time

Job summary

SMARTFOX is seeking a Senior Data Architect to shape enterprise data architecture, modeling, and metadata governance in a fast-paced environment. You will design data models, catalogs, and semantic structures to enable GenAI and analytics across the organization.

You will lead metadata onboarding, establish standards, and collaborate with data SMEs while leveraging Oracle databases, Toad tooling, and Git-based CI/CD for automation.

Qualifications

• 8+ years of enterprise data architecture experience.
• Strong Oracle relational databases and enterprise data models.
• Advanced Oracle SQL and PL/SQL proficiency.
• Experience with metadata onboarding, data catalogs, and semantic modeling.
• Familiar with Git, CI/CD, and metadata extraction tools.
• Working knowledge of Python for metadata automation is preferred.

Responsibilities

• Design and maintain enterprise data architecture and Oracle data models.
• Identify and document database schemas, tables, views, columns, keys, relationships, and constraints for analytics.
• Manage metadata onboarding, data catalogs, business glossaries, and semantic modeling.
• Extract, validate, and organize Oracle metadata using SQL scripts, Toad, or dictionary queries.
• Establish metadata standards and collaborate with data SMEs to validate data accuracy.
• Support database scripts and metadata assets using Git, CI/CD practices, and automation tools.

Skills

Data architecture

Data modeling

Metadata management

Oracle SQL

PL/SQL

Git

CI/CD

Python

Semantic modeling

Metadata onboarding

Tools

Toad

Git

CI/CD tools

Job description

SMARTFOX is seeking a Senior Data Architect to shape enterprise data architecture, modeling, and metadata governance in a fast-paced environment. You will design data models, catalogs, and semantic structures to enable GenAI and analytics across the organization.

You will lead metadata onboarding, establish standards, and collaborate with data SMEs while leveraging Oracle databases, Toad tooling, and Git-based CI/CD for automation.