Data Solution Architect

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.