GenAI Data Architect - Oracle & Metadata Strategy

Apex Systems; Plano (TX); Hybrid; USD 130,000 - 180,000; Full time

Benefits offered by this job

Health benefits

401k with match

HSA

EAP with counseling

Training & certification discounts

Job summary

Everforth Apex is seeking a Data Architect to prepare the SPI data estate for a GenAI platform. The role involves defining onboarding approaches, identifying source structures, and designing performant access patterns.

This is a hybrid position with three days onsite across Plano, TX and other listed locations. The candidate will document SPI Oracle schemas, validate metadata, and collaborate with data SMEs to ensure data accuracy for downstream AI context layers.

Qualifications

• 8+ years in enterprise data architecture or related fields.
• Experience with Oracle databases and analytics/AI-enabled queries.
• Expertise in metadata onboarding, data catalogs, and semantic modeling.

Responsibilities

• Document SPI Oracle schemas, tables, views, and columns for GenAI.
• Define onboarding scope for structured data across source systems.
• Extract and validate technical metadata from Oracle with SQL scripts.
• Maintain metadata standards for descriptions, definitions, data types.
• Collaborate with SMEs to validate data accuracy.
• Design optimized views or materialized views for GenAI queries.
• Define aggregation and join strategies for common access paths.
• Map Oracle data structures to business concepts.
• Support mapping of business terminology to tables and columns.
• Validate data quality and referential integrity.
• Identify sensitive data elements and access controls.

Skills

Advanced SQL (Oracle SQL)

PL/SQL concepts

Metadata onboarding

Semantic modeling

Data architecture

Tools

Oracle Database

Starburst

Toad for Oracle

Data catalogs

Git

Job description

Everforth Apex is seeking a Data Architect to prepare the SPI data estate for a GenAI platform. The role involves defining onboarding approaches, identifying source structures, and designing performant access patterns.

This is a hybrid position with three days onsite across Plano, TX and other listed locations. The candidate will document SPI Oracle schemas, validate metadata, and collaborate with data SMEs to ensure data accuracy for downstream AI context layers.