JOBSEARCHER

Data Architect

SmartfoxPlano, TXL6 LeadSeptember 24th, 2026
Job Title: Data ArchitectLocation: Hybrid at Plano, TX Duration: 12+ Months ContractPosition Type: ContractMain Skills:Data ArchitectureData ModelingMetadataPL/SQLMaterialized Views/DesigningAs a Data Architect, you will:Required Qualifications8+ years of experience in enterprise data architecture, database architecture, or data platform architecture.Strong experience with Oracle relational databases and enterprise data models.Experience designing performant data access patterns for analytics, reporting, or AI-enabled query systems.Experience with metadata onboarding, data catalogs, business glossaries, and semantic modeling.Advanced SQL, especially Oracle SQL.Data and Metadata OnboardingIdentify and document the required SPI Oracle database schemas, tables, views, columns, keys, relationships, and constraints needed for GenAI.Define the onboarding scope for structured data, including source systems, subject areas, entities, and key data products.Extract, validate, and organize technical metadata from Oracle using tools such as Toad, SQL scripts, catalog exports, or database dictionary queries.Establish metadata standards for table descriptions, column definitions, data types, keys, data classifications, and business relevance.Work with business and data SMEs to validate whether the onboarded data accurately represents the enterprise process management business domain.Toad for Oracle or equivalent Oracle metadata extraction tools.Data catalog or metadata management platforms.Git or enterprise source control.CI/CD awareness for database scripts and metadata assets.Strong understanding of PL/SQL concepts.Working knowledge of Python for metadata extraction, profiling, or automation is preferred.Familiarity with YAML / JSON metadata formats is useful.