Data Architect

Pyramid Consulting, Inc; Plano (TX); Hybrid; USD 89,544 - 96,432; Full time

Job summary

Pyramid Consulting, Inc. seeks a Data Architect for a 12-18+ month contract in a hybrid arrangement (Plano, TX; other locations). You will lead data onboarding, metadata cataloging, and semantic modeling for AI-enabled analytics, designing efficient Oracle-based data access and materialized views.

Strong collaboration with business SMEs is required. Responsibilities include defining data scope, documenting schemas, and ensuring data quality and governance across the SPI environment.

Qualifications

• 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.

Responsibilities

• Data and Metadata Onboarding and documentation of required Oracle schemas, tables, views, and keys.
• Define onboarding scope for structured data, including source systems and key data products.
• Extract, validate, and organize technical metadata from Oracle using SQL scripts and catalog queries.
• Establish metadata standards for descriptions, definitions, data types, keys, and business relevance.
• Collaborate with business SMEs to validate onboarded data represents enterprise processes.
• Design materialized views to optimize GenAI query performance.
• Define refresh frequency and ownership for materialized views.
• Provide mappings between Oracle structures and business concepts.

Skills

Oracle

Enterprise data architecture

Data modeling

Metadata onboarding

Knowledge semantics

Semantic modeling

Analytics/AI query

Toad

SQL scripts

Tools

Toad

SQL

Job description

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.