Senior ETL & Data Migration Engineer: Onsite FBI

Zachary Piper Solutions; Virginia; 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. 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.

As part of the role, you will design and implement scalable ETL/ELT pipelines, automate data workflows, and collaborate with Cloud, DevSecOps,

Qualifications

• 8+ years of hands-on ETL development and data migration experience.
• Experience building scalable ETL/ELT pipelines in cloud environments.
• Active Top Secret security clearance required.
• Experience with Python, Bash, PowerShell and CI/CD workflows.
• Familiarity with federal modernization projects and large-scale data migration.

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

Big data tools

Python

Bash

PowerShell

DevSecOps/CI/CD

Security clearance

AWS

SQL

Education

Bachelor’s degree

Tools

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. 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.

As part of the role, you will design and implement scalable ETL/ELT pipelines, automate data workflows, and collaborate with Cloud, DevSecOps,