Onsite Quantico: Senior ETL & Data Migration Engineer

Zachary Piper Solutions; Quantico (VA); On-site; USD 140,000 - 150,000; Full time

Benefits offered by this job

PTO

Paid Holidays

Medical

Dental

Vision

401k

Tuition Reimbursement

Sick Leave

Job summary

Zachary Piper Solutions is seeking a Senior ETL & Data Migration Engineer to join a federal IT consulting organization supporting an FBI modernization program in Quantico, VA. This 100% onsite role focuses on moving high-volume legacy datasets into a secure AWS cloud environment.

The engineer will develop reliable migration pipelines, automate ETL/ELT workflows, and collaborate with Cloud, DevSecOps, DBA, and QA teams to ensure data quality and secure, scalable data infrastructure for

Qualifications

• Bachelor’s degree and 8+ years of hands-on experience in ETL development, data migration, or large-scale data engineering.
• Strong experience designing and operating advanced ETL/ELT pipelines using data integration tools, scripting languages, and automation frameworks.
• Expertise in structured and unstructured data transformation, cleansing, mapping, and validation.
• Experience extracting data from legacy systems, supporting cloud ingestion, and working with big data tools; AWS experience preferred.
• Proven pipeline diagnostics and root cause analysis skills. Federal modernization, petabyte-scale migration, Python, Bash, PowerShell, and DevSecOps/CI/CD experience preferred.
• Must have an active Top Secret security clearance.

Responsibilities

• Design, build, and optimize scalable ETL/ELT pipelines to migrate structured and unstructured datasets from legacy systems into cloud environments.
• Automate extraction, transformation, and ingestion workflows with effective sequencing, error handling, recovery, and performance monitoring.
• Execute migration cycles, troubleshoot pipeline failures, and resolve data anomalies in collaboration with engineering teams.
• Validate migrated data for accuracy and completeness, investigate defects, and implement repeatable data quality checks.
• Partner with Cloud, DevSecOps, DBA, and QA teams while maintaining data mappings, transformation documentation, operational procedures, and migration status reports.

Skills

ETL development

Data migration

Large-scale data engineering

Python

Bash

PowerShell

DevSecOps/CI/CD

AWS

Education

Bachelor’s degree

Tools

Python

Bash

PowerShell

AWS

Job description

Zachary Piper Solutions is seeking a Senior ETL & Data Migration Engineer to join a federal IT consulting organization supporting an FBI modernization program in Quantico, VA. This 100% onsite role focuses on moving high-volume legacy datasets into a secure AWS cloud environment.

The engineer will develop reliable migration pipelines, automate ETL/ELT workflows, and collaborate with Cloud, DevSecOps, DBA, and QA teams to ensure data quality and secure, scalable data infrastructure for