Senior Data Engineer (AI/GenAI) with Security Clearance

Linchpin Software LLC; Chantilly (VA); On-site; USD 120,000 - 190,000; Full time

Job summary

Linchpin Software LLC is seeking a Senior Data Engineer to build the data pipelines and architecture for an in-house AI and GenAI analytic platform. You will engineer the vector, graph, and relational data layers to enable multi-model reasoning with traceable provenance and robust security in air-gapped and hybrid environments.

You will design ingestion schemas, enforce governance, and mentor junior engineers while collaborating across teams to set data standards and ensure fast, defensible data

Qualifications

• 8+ years of experience in data engineering, database design, or a related field.
• Strong relational database design, SQL, and ETL/ELT skills.
• Strong Python skills and experience building production data pipelines.
• Experience working with structured, semi-structured, and unstructured data.
• Experience improving data workflows, performance, and security.
• Ability to work full-time, on-site in Chantilly, VA (20151).

Responsibilities

• Build automated ETL pipelines for schema-aligned ingestion and normalization of diverse structured, semi-structured, and unstructured data.
• Engineer and orchestrate vector, graph, and relational databases powering retrieval and reasoning.
• Implement Named Entity Recognition, contextual entity extraction, and entity resolution at scale.
• Support multi-step retrieval, structured output generation, and deep source citation so every analytic result is traceable.
• Enforce Attribute Based Access Control at the data layer and track end-to-end data lineage and provenance.
• Design and optimize enterprise relational databases and set standards for operations, performance, and security.
• Integrate reasoning components, retrieval systems, databases, and GenAI services across the stack.
• Mentor junior engineers and contribute to cross-team data standards.

Skills

SQL

Python

ETL/ELT

Data modeling

Data governance

Security/compliance

Education

Bachelor's degree

Tools

PostgreSQL

LanceDB

lance graph

Claude Code

Codex

GitLab Duo

FastAPI

Docker

Kubernetes

Job description

Build The Data Backbone That Makes AI Actually Work On Mission Data. Linchpin Software Is Growing, And We're Looking For a Senior Data Engineer To Build The Pipelines And Data Architecture Behind An In-house AI And GenAI Analytic Platform. This Is Not a Bolt-on Chatbot. You'll Engineer The Vector, Graph, And Relational Data Layers That Let Multi-model Reasoning, Entity Resolution, And Retrieval Run Against Structured And Unstructured Mission Data, With Full Provenance And Citation Behind Every Answer. The Platform Is Custom-built, Runs In Air-gapped And Hybrid Environments On Locally Hosted GPU Infrastructure, And Serves Analysts Who Need Results They Can Trace Back To The Source. You'll Design The Ingest, Shape The Schemas, And Make Sure The Data Feeding The Models Is Fast, Governed, And Defensible. We Build Software Differently. Our Engineers Use AI-assisted Development Tools (Claude Code, Codex, GitLab Duo) Every Day To Design, Code, Test, And Debug Faster. You'll Spend Your Time Solving Hard Data Problems, Not Writing Boilerplate.

What You'll Do

• Build automated ETL pipelines for schema-aligned ingestion and normalization of diverse structured, semi-structured, and unstructured data
• Engineer and orchestrate vector, graph, and relational databases (LanceDB, lance graph, PostgreSQL) powering retrieval and reasoning
• Implement Named Entity Recognition (NER), contextual entity extraction, and entity resolution at scale
• Support multi-step retrieval, structured output generation, and deep source citation so every analytic result is traceable
• Enforce Attribute Based Access Control (ABAC) at the data layer and track end-to-end data lineage and provenance
• Design and optimize enterprise relational databases and set standards for operations, performance, and security
• Integrate reasoning components, retrieval systems, databases, and GenAI services across the stack
• Mentor junior engineers and contribute to cross-team data standards

Required

• Active Top Secret clearance
• Bachelor's degree
• 8+ years of experience in data engineering, database design, or a related field
• Strong relational database design, SQL, and ETL/ELT skills
• Strong Python skills and experience building production data pipelines
• Experience working with structured, semi-structured, and unstructured data
• Experience improving data workflows, performance, and security
• Ability to work full-time, on-site in Chantilly, VA (20151)

Preferred

• Vector or graph databases and retrieval-augmented generation (RAG) pipelines
• AI/GenAI engineering: multi-model orchestration, computer vision, or temporal, spatial, and geographic analytics
• Backend and middleware development (FastAPI, Temporal.io, TypeScript, React)
• Container orchestration and distributed systems (Docker, Kubernetes)
• Air-gapped, hybrid, or on-premise environments and locally hosted GPU servers
• Multi-tenant Cross-Domain Solutions (CDS)
• Federal or secure multi-enclave environments
• High-performance computing, data modeling, warehousing, and performance tuning

What You'll Gain

• A custom AI platform you help architect, not a legacy system you inherit
• Hands-on GenAI and multi-model engineering experience that is hard to get in a cleared environment
• Real ownership of the data architecture, from ingest through analytic output
• A small, collaborative team on a stable, long-term mission program
• Competitive compensation and benefits