Data Solution Architect

About

Dice is the leading career destination for tech experts at every stage of their careers. Our client, Pyramid Technology Solutions, Inc., is seeking the following.

Position

Data Solution Architect

Locations

New York, NY - Onsite

Duration

6+Months with possible extensions

Responsibilities

• Responsible for identifying and integrating structured, unstructured, and semi-structured data sources.
• This person will design role-based access control (RBAC) and develop logical data models, ensuring compliance and data lineage.
• This role involves documenting business transformations, establishing data quality approaches and rules,
• create a comprehensive data catalog.
• This architect registers data assets with metadata, focusing on sensitivity and security.
• This role designs the architectural blueprint for the Data Factory, encompassing acquisition, preparation, and consumption, ensuring robust data management and quality to support automated investment processes and AI-driven analytics.
• This person will be responsible for designing and implementing agents and agentic harness and reasoning harness.
• Graph RAG and Graph Data Layer
• Design and implement a Neo4j-powered Knowledge Graph as the central data layer for investment intelligence.
• Ensure investment decision traceability by linking research, strategies, and portfolio actions into a lineage graph.
• Develop and maintain a multi-dimensional asset ontology, enabling flexible categorization and cross-dimensional analysis.
• Architect adaptive schema evolution using AI-driven feedback loops and genetic algorithm principles.
• Integrate temporal versioning to support time-aware queries and historical context preservation.
• Enable thin-pointer architecture for scalable integration with large datasets without duplication.
• Incorporate GraphRAG for transforming unstructured documents into queryable graph entities with source attribution.
• Implement property-based access control for secure, multi-tenant data visibility and query-level protection.
• Oversee real-time data ingestion pipelines for structured, unstructured, and operational data sources.

Requirements

• Snowflake
• Airflow
• Deep knowledge on Graph RAG and Graphs DS
• Data Architecture
• Experience working with various Market data sources
• Had experience in integrating with heavy AI driven and assisted architecture.
• Nice to have AWS skills
• Can teach and share knowledge with Client team on Cypher, Graph and RAG traversals.