Data Engineer - TS/SCI w/ Poly | Hybrid (Chantilly)

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

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

Life Insurance

401(k)

Paid Time Off

Job summary

Suvi, an Akima company, seeks a Data Engineer to design, build, and optimize high-performance data pipelines and ETL processes powering a web-based search and analytics application. The role requires TS clearance and experience with MySQL, PostgreSQL, SQL Server, Python, and Elasticsearch.

This hybrid position is onsite in Chantilly, VA, one day per week. You will develop data adapters, write efficient SQL, and collaborate in an Agile team to ensure scalable, reliable data systems with CI/CD 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 experience in Python development, with a focus on ETL processes.
• 3-5 years of experience writing SQL queries.
• Proficiency in working with relational databases, specifically MySQL, Microsoft SQL Server, and PostgreSQL.
• Strong understanding of data transformation, cleansing, and normalization concepts.
• Experience designing and managing Elasticsearch clusters for indexing and searching data.
• Familiarity with version control systems (e.g. GIT) and collaborative coding practices.
• Experience with data warehousing, big data frameworks, and API-based data integration from enterprise source systems.
• Knowledge of data quality, validation and monitoring frameworks, along with data governance, metadata management, and data lineage best practices.
• Excellent problem-solving skills and attention to detail.
• Experience working in an Agile Scrum environment.
• Experience with scripting languages (e.g., Bash).
• Proficiency with containerization technologies (e.g., Docker).
• Experience working in Linux environments.

Responsibilities

• Extract data from a variety of structured and semi-structured data sources including MySQL, Microsoft SQL Server, and PostgreSQL databases; delimited text; and JSON.
• Develop logic to cleanse, transform and normalize data into a standard data model.
• Write and optimize SQL queries for efficient data extraction and manipulation.
• Collaborate as a member of an Agile Scrum team, participating in sprint planning, daily stand-ups, and retrospectives.
• Perform rigorous testing and debugging to ensure the stability and performance of data adapters.
• Optimize ETL pipelines for scalability and efficiency.
• Prepare and maintain comprehensive technical documentation for all development work.
• Tune performance of large-scale data workflows for cost efficiency, low latency, and high availability.
• Design and manage Elasticsearch/OpenSearch clusters for fast search, indexing and retrieval of large datasets.
• Integrate new systems with existing data warehouse structures, enhancing performance and functionality.
• Implement CI/CD pipelines for data systems, automate monitoring/alerting and apply infrastructure-as-code best practices.
• Participate in Program Increment (PI) and Agile Release Train (ART) activities.

Skills

Python ETL

SQL queries

MySQL

PostgreSQL

MS SQL Server

Elasticsearch

Data warehousing

Big data

APIs

CI/CD

DevSecOps

Agile Scrum

Bash

Docker

Git

Linux

AWS

RabbitMQ

Celery

Education

Bachelor’s Degree in an IT related field

Tools

Docker

AWS

RabbitMQ

Celery

Git

Linux

Job description

Suvi, an Akima company, seeks a Data Engineer to design, build, and optimize high-performance data pipelines and ETL processes powering a web-based search and analytics application. The role requires TS clearance and experience with MySQL, PostgreSQL, SQL Server, Python, and Elasticsearch.

This hybrid position is onsite in Chantilly, VA, one day per week. You will develop data adapters, write efficient SQL, and collaborate in an Agile team to ensure scalable, reliable data systems with CI/CD and