Data and Software Engineer (TS/SCI w/ Poly)
About the role
Chantilly, VA 20151. JTEC Consulting LLC focuses on successfully delivering solutions to meet our clients’ most critical needs. Our founding members have decades of experience delivering a wide range of solutions to Air Force and DoD clients. We are a Veteran-Owned Small Business dedicated to bridging complex operational challenges with modern data solutions. Security Clearance Requirement: Current TS/SCI with polygraph. Location Note: 100% On‑Site. Relocation: Relocation support for candidates outside the commuting area will be considered. Position Description: JTEC Consulting is seeking an experienced Data and Software Engineer to join a focused, agile engineering team building high‑throughput, mission‑critical data flows for a custom enterprise application. The Data and Software Engineer will design, implement, and optimize end‑to‑end data architectures, robust ETL/ELT pipelines, and cloud‑native infrastructure at scale. Qualified candidates will demonstrate advanced software engineering fundamentals in Python with deep distributed systems expertise, rigorous data governance standards, and modern Lakehouse tooling. A current security clearance with agency‑specific polygraph is strictly required for consideration.
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
Qualifications
- U.S. citizenship
- Current TS/SCI with agency‑specific polygraph required for consideration
- Bachelor’s degree in Computer Science, Information Systems, or a related technical discipline (