Data Architect

Data Architect Location: Plano, TX/ Charlotte NC/ Jersey City NJ (Hybrid) Duration: 12 months Role Overview The Data Architect will prepare the Strategic Process Inventory (SPI) data estate for use by a GenAI platform. This involves defining the data onboarding approach, identifying required source structures, designing performant access patterns, and ensuring metadata is complete, accurate, and usable by downstream semantic and AI context layers. The role requires a hybrid work model with three days onsite. Key Responsibilities Identify and document required SPI Oracle database schemas, tables, views, and columns needed for GenAI. Define the onboarding scope for structured data, including source systems, subject areas, and key data products. Extract, validate, and organize technical metadata from Oracle using tools like Toad or SQL scripts. Establish and maintain metadata standards for table descriptions, column definitions, data types, and classifications. Collaborate with business and data SMEs to validate data accuracy and representation. Design optimized database views or materialized views to improve performance for GenAI query execution. Define aggregation, denormalization, and join strategies for common data access paths. Provide canonical source-to-target mapping between Oracle data structures and business concepts. Support the mapping of business terminology to physical Oracle tables and columns. Validate data quality, completeness, and referential consistency. Identify sensitive data elements requiring access controls and document data limitations. Required Qualifications Experience: 8+ years of experience in enterprise data architecture, database architecture, or data platform architecture. Strong experience with Oracle relational databases and designing performant data access patterns for analytics, reporting, or AI-enabled query systems. Experience with metadata onboarding, data catalogs, and semantic modeling is also required. Programming / Query Languages: Advanced SQL, particularly Oracle SQL, and a strong understanding of PL/SQL concepts. Systems / Tools: Proficiency with Oracle Database, Starburst, Toad for Oracle (or equivalent), data catalog platforms, and Git or other enterprise source control systems. Awareness of CI/CD for database scripts is necessary. Preferred Qualifications Working knowledge of Python for metadata extraction, profiling, or automation. Familiarity with YAML / JSON metadata formats. Experience with enterprise process management systems such as POP or ARIS. Exposure to GenAI platforms and LLM-based enterprise solutions. Knowledge of regulatory and compliance-driven data environments. Experience with Airflow, dbt, Spark, or enterprise data pipeline tooling. Everforth Apex is a world-class IT services company that serves thousands of clients across the globe. When you join Everforth Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to excellence is reflected in many awards, including ClearlyRateds Best of Staffing® in Talent Satisfaction in the United States and Great Place to Work® in the United Kingdom and Mexico. Apex Systems