Data Solution Architect
Pyramid Technology Solutions, Inc.
TEMPORARY
Remote ยท US
New York, NY, United States, NY, US
Posted: 2026-05-11
Until: 2026-07-11
Apply Now โ
You will be redirected to the original job posting on BeBee.
Apply directly with the employer.
Job Description
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.