Sr. ETL & Data Migration Engineer - 176383

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

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

• Salary Range: $140,000-$150,000 annually, depending on experience.
• Comprehensive Benefits: PTO, Paid Holidays, Medical, Dental, Vision, 401k, Tuition Reimbursement, and Sick Leave as Required by Law.

Zachary Piper Solutions is seeking a Senior ETL & Data Migration Engineer to join a federal IT consulting organization supporting an FBI modernization program in Huntsville, Alabama. 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.