Data Architect - Knowledge Graph & Data Pipelines

Socket.dev; New York, Austin, Miami (NY, TX, FL); On-site; USD 140,000 - 190,000; Full time

Job summary

Appnovation in New York, NY seeks a Data Architect/Engineer to own the data structures behind our graph-RAG platform and to design pipelines that ingest content from SharePoint and the Microsoft stack at scale.

You will define schema, taxonomy, and graph models for knowledge domains, ensure data quality and governance, and drive architecture decisions with cross-team collaboration to deliver reliable data products.

Qualifications

• Bachelor’s Degree in Computer Science or a related field.
• 5+ years of experience in data engineering / architecture roles.
• Deep data modeling across relational and graph paradigms; graph databases (Neo4j) and Postgres/Supabase at scale.
• Strong ETL / data pipeline engineering in Python, including large-scale, incremental, and change-data ingestion.
• Experience with enterprise content ecosystems: SharePoint, ideally Power Platform / Power Automate.
• Knowledge representation, taxonomies/ontologies, and versioned/temporal data.
• Understanding of how data structures feed RAG and LLM retrieval quality.
• SQL proficiency; experience with orchestration tools (e.g., Airflow) and cloud data services.
• Familiarity with data governance, security, and privacy practices.
• Strong documentation and cross-team communication skills.

Responsibilities

• Define the schema, taxonomy, and graph modeling for the knowledge domains.
• Design how documents, versions, and their machine-readable representations are structured, and how facts evolve over time (including temporal replay).
• Build ingestion/ETL pipelines from enterprise content sources (e.g., SharePoint and the wider Microsoft stack), handling multimodal content.
• Keep the knowledge graph in sync as source documents change frequently.
• Advise on backend architecture and validate ingested content quality with QA.
• Establish data quality, lineage, and governance standards across pipelines.
• Build monitoring, alerting, and error-handling for ingestion jobs.
• Document data models, schemas, and pipeline architecture.
• Optimize pipeline cost, throughput, and reliability over time.

Skills

Data modeling

Graph databases

Python ETL

SQL

Airflow

Data governance

Security & privacy

Cross-team communication

Education

Bachelor's degree in CS or related field

Tools

Neo4j

Postgres/Supabase

SharePoint

Power Platform/Power Automate

Airflow

Job description

Appnovation in New York, NY seeks a Data Architect/Engineer to own the data structures behind our graph-RAG platform and to design pipelines that ingest content from SharePoint and the Microsoft stack at scale.

You will define schema, taxonomy, and graph models for knowledge domains, ensure data quality and governance, and drive architecture decisions with cross-team collaboration to deliver reliable data products.