Data Solution Architect

Pyramid Technology Solutions
New York, United States of America
2 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English

Job location

New York, United States of America

Tech stack

Artificial Intelligence
Airflow
Amazon Web Services (AWS)
Big Data
Data Architecture
Genetic Algorithm
Graph Database
Logical Data Models
Metadata
Neo4j
Role-Based Access Control
Systems Integration
Management of Software Versions
Data Ingestion
Snowflake
Data Layers
Data Lineage
Real Time Data
Data Management

Job description

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

Apply for this position