What are the responsibilities and job description for the Data Solution Architect position at Pyramid Technology Solutions, Inc.?
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.