TS/SCI Data Engineer — ETL, Python & OpenSearch (Hybrid)

Akima, LLC; Chantilly (VA); Hybrid; USD 150,000 - 170,000; Full time

Benefits offered by this job

Medical, dental, vision insurance

401(k) and PTO

Job summary

Suvi, an Akima company, seeks a Software/Data Engineer to design, build, and optimize high‑performance data pipelines and ETL processes powering a web‑based search and analytics application. The role involves extracting data from multiple sources, developing Python data adapters, and tuning workflows for speed and scale.

This hybrid position requires on-site work in Chantilly, VA, one day per week, and includes collaboration within an Agile Scrum team, SQL optimization, data warehousing, and

Qualifications

• Active Top Secret clearance and SCI eligibility with the ability to pass a CI polygraph.
• Bachelor’s Degree in an IT related field.
• 3–5 years of Python development with a focus on ETL processes.
• 3–5 years of experience writing SQL queries.
• Proficiency with MySQL, SQL Server and PostgreSQL.
• Experience with data warehousing, big data frameworks, and API-based data integration.
• Familiarity with Git and collaborative coding practices.
• Experience with Linux, Docker and AWS.

Responsibilities

• Extract data from structured and semi-structured sources including databases and files.
• Develop, cleanse, transform, and normalize data into a standard model.
• Write and optimize SQL queries for data extraction and manipulation.
• Collaborate in an Agile Scrum team, participate in sprint activities.
• Test and debug data adapters to ensure stability and performance.
• Optimize ETL pipelines for scalability and cost efficiency.
• Document development work comprehensively.
• Design and manage Elasticsearch/OpenSearch clusters for fast search and retrieval.
• Implement CI/CD pipelines and infrastructure-as-code practices.

Skills

Python ETL

SQL

Data modeling

Git

Linux

Docker

AWS

Elasticsearch/OpenSearch

CI/CD

Agile/Scrum

Education

Bachelor’s Degree in IT-related field

Tools

MySQL

Microsoft SQL Server

PostgreSQL

CI tools

ETL tools

Job description

Suvi, an Akima company, seeks a Software/Data Engineer to design, build, and optimize high‑performance data pipelines and ETL processes powering a web‑based search and analytics application. The role involves extracting data from multiple sources, developing Python data adapters, and tuning workflows for speed and scale.

This hybrid position requires on-site work in Chantilly, VA, one day per week, and includes collaboration within an Agile Scrum team, SQL optimization, data warehousing, and