Senior ETL & Data Migration Engineer - Onsite (Top Secret)

Piper Companies; Huntsville (AL); 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 Huntsville, Alabama. This 100% onsite role focuses on moving high-volume legacy datasets into a secure AWS cloud environment.

You will design and implement scalable ETL/ELT pipelines, automate workflows, validate data, and collaborate with Cloud, DevSecOps, DBA, and QA teams while maintaining data mappings and migration status reports.

Qualifications

• Bachelor’s degree and 8+ years hands-on experience in ETL development, data migration, or large-scale data engineering.
• 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

AWS

Python

Bash

PowerShell

DevSecOps/CI/CD

Education

Bachelor's degree

Tools

SQL

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 Huntsville, Alabama. This 100% onsite role focuses on moving high-volume legacy datasets into a secure AWS cloud environment.

You will design and implement scalable ETL/ELT pipelines, automate workflows, validate data, and collaborate with Cloud, DevSecOps, DBA, and QA teams while maintaining data mappings and migration status reports.