Mission-Critical Data & Software Engineer (TS/SCI) — On-Site

JTEC Consulting; Chantilly (VA); On-site; USD 170,000 - 210,000; Full time

Job summary

JTEC Consulting LLC seeks a Data and Software Engineer with a TS/SCI clearance and poly to design, implement, and optimize end-to-end data architectures for a high-throughput enterprise application in Chantilly, VA. You’ll build ETL/ELT pipelines, leverage Spark, Airflow, and modern Lakehouse tooling while ensuring governance, security, and robust cloud infrastructure.

The role emphasizes collaboration with data science, operations, and security teams, with 100% on-site work and relocation

Qualifications

• Bachelor’s degree in Computer Science, Information Systems, or a related technical discipline (equivalent years of direct experience considered in lieu of a degree)
• 5+ years of progressive experience in data engineering, software engineering, or distributed backend systems
• Current TS/SCI with agency-specific polygraph required for consideration
• Effective written and verbal communication skills to support a collaborative, cross-functional team including engineering peers and operational stakeholders

Responsibilities

• Pipeline Architecture and Orchestration: Architect, build, and maintain production-grade data pipelines and ETL/ELT workflows using Python, Apache Spark, and workflow orchestration frameworks (e.g., Apache Airflow)
• Lakehouse and Analytics Engineering: Deploy and optimize open table formats (Apache Iceberg) and federated query engines (Trino) to support low-latency analytical queries and large-scale data processing
• Database Design and Performance Tuning: Design relational schemas, maintain indexes, and execute query optimization on MySQL and PostgreSQL for complex analytical workloads
• Geospatial and Complex Data Handling: Ingest, structure, and analyze non-traditional and spatial data formats utilizing indexing systems and spatial extensions like Uber H3 and PostGIS
• Cloud and Infrastructure as Code (IaC): Containerize microservices and batch jobs using Docker or Podman, provisioning and managing scalable AWS resources (S3, Lambda, Step Functions) via Terraform or CloudFormation
• Data Governance, Lineage and Metadata: Implement cataloging and end-to-end operational lineage tracking using Unity Catalog OSS, Apache Polaris, and OpenLineage to satisfy strict compliance, privacy, and security mandates
• AI/ML Model Integration: Collaborate with data science and engineering peers to integrate AI/ML services and operationalize inference models into upstream and downstream data workflows
• Modernization and Migration: Lead technical strategy for large-scale data migrations, schema evolutions, and platform modernization initiatives with minimal system downtime
• Stakeholder Collaboration and Best Practices: Translate ambiguous operational requirements into technical specifications with minimal oversight; author comprehensive technical documentation, establish testing standards, and mentor team members on data engineering design patterns

Skills

Python

PySpark

Apache Spark

Airflow

SQL

PostgreSQL

MySQL

AWS

Terraform

Docker

PostGIS

H3

Unity Catalog

OpenLineage

Education

Bachelor’s degree in CS/IS or related field

Tools

Terraform

CloudFormation

PostgreSQL

Job description

JTEC Consulting LLC seeks a Data and Software Engineer with a TS/SCI clearance and poly to design, implement, and optimize end-to-end data architectures for a high-throughput enterprise application in Chantilly, VA. You’ll build ETL/ELT pipelines, leverage Spark, Airflow, and modern Lakehouse tooling while ensuring governance, security, and robust cloud infrastructure.

The role emphasizes collaboration with data science, operations, and security teams, with 100% on-site work and relocation