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

Zachary Piper Solutions; Huntsville, Northern (AL, KY); Hybrid; USD 140,000 - 150,000; Full time

Benefits offered by this job

PTO

Medical Insurance

Dental Insurance

Job summary

Zachary Piper Solutions is seeking a Senior ETL & Data Migration Engineer to join a federal IT team 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 and developing reliable migration pipelines.

You will collaborate with Cloud, DevSecOps, DBA, and QA teams to ensure data mappings, transformation documentation, and migration status reporting, while delivering scalable ETL/ELT

Qualifications

• 8+ years of hands-on 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.
• Must have an active Top Secret security clearance.

Responsibilities

• Design, build, and optimize scalable ETL/ELT pipelines to migrate legacy data 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 with engineering teams.
• Validate migrated data for accuracy and completeness, investigate defects, and implement data quality checks.
• Partner with Cloud, DevSecOps, DBA, and QA teams while maintaining data mappings, transformation documentation, and migration status reports.

Skills

ETL Development

Data Migration

Python

Bash

PowerShell

DevSecOps/CI-CD

Cloud Ingestion

SQL

Data Quality

Big Data Tools

Education

Bachelor’s degree

Tools

AWS

Data Integration Tools

Job description

Zachary Piper Solutions is seeking a Senior ETL & Data Migration Engineer to join a federal IT team 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 and developing reliable migration pipelines.

You will collaborate with Cloud, DevSecOps, DBA, and QA teams to ensure data mappings, transformation documentation, and migration status reporting, while delivering scalable ETL/ELT