Data Architect

Creative Solutions Services, LLC; Plano (TX); Hybrid; USD 89,544 - 96,432; Full time

Job summary

Creative Solutions Services, LLC is seeking a Data Architect for a 12-18+ month contract in Plano, TX (Hybrid). The role focuses on onboarding Oracle data and metadata, designing materialized views, and enabling GenAI-ready data access patterns. Strong governance and data quality are essential.

Ideal candidates have 8+ years in enterprise data architecture, deep Oracle expertise, and experience with semantic modeling and data catalogs. This is a long-term engagement with competitive benefits.

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

• Onboard data and metadata from Oracle, identifying schemas, tables, views, keys, and constraints.
• Design materialized views and optimized data access patterns for GenAI workloads.
• Define data onboarding scope, sources, entities, and key data products.
• Ensure data quality, governance, and documentation across the data platform.

Skills

Oracle

Metadata onboarding

Data modeling

Performance optimization

Tools

Toad

SQL scripts

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

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.