Data Architect

Immediate need for a talented Data Architect . This is a 12- 18+ months contract opportunity with long-term potential and is located in Plano, TX, Charlotte, NC, Jersey City, NJ(Hybrid) . Please review the job description below and contact me ASAP if you are interested. Job ID:26-22627 Pay Range: $65 - $70/hour. Employee benefits include, but are not limited to, health insurance (medical, dental, vision), 401(k) plan, and paid sick leave (depending on work location). Key Responsibilities: Data and Metadata Onboarding Identify 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. Data Modeling and Materialized View Design Analyze SPI data structures to determine where direct source access may be inefficient for natural-language query workloads. Design optimized database views or materialized views to improve performance for GenAI query execution. Define aggregation, denormalization, join, and filtering strategies for commonly used SPI data access paths. Ensure materialized views preserve semantic correctness and do not introduce ambiguity into business reporting. Define refresh frequency, dependency management, and operational ownership for materialized views. Integration with Semantic and Knowledge Layers Provide canonical source-to-target mapping between Oracle data structures and business concepts. Support the Knowledge / Data Engineer in mapping business terminology to physical Oracle tables and columns. Identify authoritative source fields for core SPI business terms, metrics, dimensions, and identifiers. Define reusable data access patterns that can be reflected in the semantic layer and AI context artifacts. Governance and Quality Validate data quality, completeness, referential consistency, and metadata accuracy. Identify sensitive, restricted, or regulated data elements that require access controls or masking. Document known data limitations, latency, interpretation caveats, and usage constraints. Ensure data onboarding artifacts are versioned and traceable. Key Requirements and Technology Experience: Must have skills: 8+ 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. Our client is a leading Banking Industry and we are currently interviewing to fill this and other similar contract positions. Pyramid Consulting, Inc. provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws. By applying to our jobs you agree to receive calls, AI-generated calls, text messages, or emails from Pyramid Consulting, Inc. and its affiliates, and contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can reply STOP to cancel and HELP for help. You can access our privacy policy here. #J-18808-Ljbffr Pyramid Consulting, Inc