Sr. ETL & Data Migration Engineer - - 176818

About the role

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 Senior ETL & Data Migration Engineer will develop reliable migration pipelines and help modernize critical systems used to store, manage, and analyze mission-sensitive data.

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.

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.

Compensation

Salary Range: $140,000–$150,000 annually, depending on experience.

Benefits

• PTO
• Paid Holidays
• Medical
• Dental
• Vision
• 401k
• Tuition Reimbursement
• Sick Leave as Required by Law

This job opens for applications October 19, 2026. Applications will be accepted for at least 30 days from the posting date.