ETL Engineer

About the role

VTG is seeking a detail-oriented and experienced ETL Engineer to join our data engineering team. The ideal candidate will design, build, and maintain 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.

Responsibilities

• Design, develop, and maintain ETL/ELT pipelines that support data warehouse, analytics, and application needs (experience 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.

Requirements

• 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 preferred).
• 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 ETL experience 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.