ETL Engineer

VTG Defense; Chantilly (VA); On-site; USD 110,000 - 165,000; Full time

Job summary

VTG Defense in Chantilly, VA is an on-site role seeking an experienced ETL Engineer to design, build, and maintain data pipelines for enterprise analytics. You will work with large data sets across sources, warehouse, and applications, delivering timely, high-quality data delivery.

The ideal candidate has 6–8 years in Linux, Python, SQL, and cloud experience in AWS/C2S, plus ETL tool expertise (Informatica, Talend, SSIS, Glue). An active TS/SCI with Poly is required on day one.

Qualifications

• Bachelor's degree in CS / IS / Eng or equivalent experience.
• 6-8 years Linux experience with large-scale data processing.
• 6-8 years OO programming; Python preferred.
• 6-8 years in AWS/C2S environment; Azure/Google considered.
• 4-6 years ETL with large structured/unstructured data; experience with Informatica, Talend, SSIS, AWS Glue, or Azure Data Factory.
• Proficient in SQL with complex queries and optimization.
• 6-8 years AWS experience including EC2.
• Strong data warehousing, data modeling, and schema design knowledge.
• Hands-on scripting with Python, Bash, or PowerShell.
• TS/SCI with poly required on day one.

Responsibilities

• Design, develop, and maintain ETL/ELT pipelines for data warehouse and analytics.
• Extract, transform, and load data from diverse sources into centralized storage.
• Enhance search and discovery across large data volumes.
• Ingest, ETL, and integrate data across multi-source environments.
• Optimize ETL workflows for performance and reliability.
• Perform data validation, profiling, and quality checks.
• Troubleshoot data issues and pipeline bottlenecks.
• Build cloud-native solutions on AWS and ensure secure architecture.
• Collaborate with mission operators and stakeholders to define requirements.
• Deliver analytics visuals and executive briefings.
• Provide technical leadership and code reviews.

Skills

Linux

Python

SQL

Data warehousing

Data modeling

ETL pipelines

Git

Bash/PowerShell

AWS

Communication

Education

Bachelor's degree in Computer Science / Information Systems / Engineering

Tools

Informatica

Talend

SSIS

AWS Glue

Azure Data Factory

Job description

Overview

VTG is currently seeking a detail-oriented and experienced ETL Engineer to join our data engineering team. The ideal candidate will be responsible for designing, building, and maintaining data pipelines and integration processes that enable reliable, timely, and high-quality data delivery across the organization. This role requires strong technical capabilities, a deep understanding of data architecture, and the ability to collaborate effectively with cross-functional stakeholders.

What will you do?

• Design, develop, and maintain ETL/ELT pipelines that support data warehouse, analytics, and application needs. Must be experienced with large data sets [hundreds of thousands of records, GB and TB size data sets]
• Extract, transform, and load data from various sources into centralized storage solutions.
• Design and enhance search and discovery platforms across large volumes of structured and unstructured data
• Perform data ingestion, ETL, and integration across enterprise and multi-source environments
• Optimize ETL workflows for performance, scalability, and reliability.
• Conduct data validation, profiling, and quality checks to ensure accuracy and completeness.
• Troubleshoot and resolve data inconsistencies, pipeline failures, or performance bottlenecks.
• Build and maintain cloud-native solutions (AWS) aligned to secure and resilient architecture patterns
• Partner with mission operators, analysts, and senior stakeholders to define requirements and deliver mission-relevant analytics
• Translate mission needs into technical designs, architectures, and implementation roadmaps, ensuring alignment to operational objectives
• Deliver clear, compelling visualizations, dashboards, and executive-level briefings that communicate analytic insights and recommendations
• Provide technical leadership and mentorship, including hands‑on development, code review, and team development
• Own delivery of analytic capabilities from concept through deployment, accreditation, and sustainment
• Support system accreditation, data governance, and security architecture, ensuring data integrity and compliance within classified environments

Do you have what it takes?

• Bachelor's degree in Computer Science, Information Systems, Engineering, or related field (or equivalent experience).
• Minimum 6-8 years working in Linux Operating system with updating the system for efficient parallel processing, understanding memory, storage and processing data at scale
• Minimum 6-8 years in Object Oriented programming. Python is preferred software development language
• Minimum 6-8 years of demonstrated experience with applications in the Commercial Cloud Services (C2S) environment or an Amazon Web Services cloud environment. Willing to consider substituting C2S if candidate has a minimum 4-6 years of cloud computing technology to include Azure, Oracle, Google, etc.
• Minimum 4-6 years of demonstrated (Extract, Transform, Load - ETL) with large structured and unstructured raw data sets. Strong experience with ETL tools such as Informatica, Talend, SSIS, AWS Glue, or Azure Data Factory.
• Proficiency in SQL, including complex queries and query optimization.
• 6-8 Years of experience with AWS platform including understanding EC2, RCS instance types
• Strong understanding of data warehousing concepts, data modeling, and schema design.
• Hands‑on experience with scripting languages such as Python, Bash, or PowerShell.
• Familiarity with relational and NoSQL databases.
• Experience using version control systems such as Git.
• *Must possess an active TS/SCI clearance with Poly on day one of employment