Senior ETL & Data Migration Engineer — Onsite (FBI)

Zachary Piper, LLC

Huntsville (AL)

On-site

USD 140,000 - 150,000

Full time

9 days ago

Get a reply from this recruiter

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

PTO & 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 program in Huntsville, Alabama. This 100% onsite role focuses on moving high‑volume legacy datasets into a secure AWS cloud, developing reliable migration pipelines and ensuring data integrity for mission‑critical systems.

The ideal candidate has 8+ years in ETL/data engineering, is proficient with AWS and CI/CD, and holds an active Top Secret security clearance.

Qualifications

8+ years hands-on ETL development, data migration, or large-scale data engineering.
Experience with advanced ETL/ELT pipelines and automation.
Proficiency in structured/unstructured data transformation, cleansing, mapping, and validation.
Experience extracting data from legacy systems, cloud ingestion, AWS preferred.
Security clearance: active Top Secret required.

Responsibilities

Design, build, and optimize scalable ETL/ELT pipelines to migrate data into cloud environments.
Automate extraction, transformation, and ingestion workflows with error handling and monitoring.
Troubleshoot pipeline failures and resolve data anomalies with engineering teams.
Validate migrated data for accuracy and completeness; implement data quality checks.
Collaborate with Cloud, DevSecOps, DBA, and QA teams; maintain mappings and migration reports.