Senior Data Engineer: AI/GenAI & Secure ETL (TS)

The Amatriot Group; Chantilly (VA); On-site; USD 160,000 - 180,000; Full time

Job summary

The Amatriot Group is seeking a Senior Software Developer to design and deliver advanced data-intensive applications in secure environments. You will build data pipelines, design large relational databases, and enable high-performance analytics across structured and semi-structured data.

The role requires guiding AI/GenAI features, ETL, and cross-team standards while mentoring junior engineers and contributing to enterprise infrastructure and cross-domain solutions in a TS-cleared environment.

Qualifications

• Bachelor’s degree required.
• 8+ years in data engineering or DB design.
• Experience with structured and semi-structured data.
• Experience with high-performance computing environments.
• Experience improving data workflows, performance, and security.

Responsibilities

• Develop data-processing workflows and analytics for desktop- and web-based visual analytic tools.
• Support large-scale relational data analysis using visualization and high-performance computing.
• Build secure data-ingestion pipelines using open-source, COTS, and GOTS technologies.
• Design and optimize enterprise relational databases and establish standards for operations and security.
• Integrate new data systems with existing data warehouses and improve performance and functionality.
• Contribute to system optimization, secure posture improvements, and cross-team technical standards.
• Support advanced AI, GenAI, and multi-model engineering capabilities.
• Implement multi-model and multi-modality orchestration across reasoning, perception, memory, and tool-execution components.
• Support temporal, spatial, geographic, quantitative, and computer-vision AI implementations.
• Implement Named Entity Recognition, contextual entity extraction, and entity resolution.
• Support multi-step retrieval and structured-output generation.
• Perform complex data parsing and streamlined ingestion.
• Support deep source citation and traceable analytic outputs.
• Develop, schedule, and optimize automated ETL pipelines.
• Implement Attribute-Based Access Control at the data layer.
• Support provenance and end-to-end data lineage tracking.
• Perform schema-aligned ingestion and normalization of diverse data.

Skills

SQL

Data engineering

ETL/ELT

Relational DB design

TypeScript

Python

React

Docker

Kubernetes

PostgreSQL

Education

Bachelor’s degree

Tools

LanceDB

Lance Graph

Temporal.io

Docker

Kubernetes

PostgreSQL

Job description

The Amatriot Group is seeking a Senior Software Developer to design and deliver advanced data-intensive applications in secure environments. You will build data pipelines, design large relational databases, and enable high-performance analytics across structured and semi-structured data.

The role requires guiding AI/GenAI features, ETL, and cross-team standards while mentoring junior engineers and contributing to enterprise infrastructure and cross-domain solutions in a TS-cleared environment.