Data Migration Engineer — Onsite ETL Architect (Top Secret)

Zachary Piper, LLC; Huntsville (AL); On-site; USD 155,000 - 175,000; Full time

Benefits offered by this job

PTO/Holidays

Medical, Dental, Vision insurance

401k

Job summary

Zachary Piper Solutions seeks a Senior Data Migration Engineer to support a data migration project for the FBI in Huntsville, Alabama. The role focuses on architecting, operating, validating, and optimizing data migration pipelines across cloud and on-prem environments.

You will design scalable ETL/ELT workflows, collaborate with cross-functional teams, and ensure robust performance, reliability, and security. This is a 100% onsite, long-term contract opportunity with competitive compensation.

Qualifications

• Bachelor’s degree in a related discipline and 8+ years of data engineering, ETL development, and large scale migrations.
• Active Top Secret clearance.
• Experience with ETL tools, automation frameworks (Python, Powershell, Bash), and high volume data pipelines.
• Experience operating ETL pipelines within AWS or other cloud environment.

Responsibilities

• Design, develop, and maintain scalable ETL/ELT pipelines to support large-scale data migration initiatives.
• Build and optimize extraction, transformation, and loading processes for structured and unstructured data sources.
• Develop automated workflows that maximize performance, reliability, scalability, and error recovery.
• Ensure pipeline architectures align with cloud modernization strategies and landing zone standards.
• Collaborate with Cloud Engineers, Data Engineers, DevSecOps teams, DBAs, QA/Test Engineers, and Product Owners to support migration objectives.
• Ensure seamless integration of ETL processes with cloud infrastructure, data models, monitoring platforms, and downstream applications.
• Develop and maintain technical documentation, including data mappings, workflow diagrams, transformation specifications, SOPs, and issue logs.

Skills

ETL development

Data pipelines

Python

Shell scripting

Education

Bachelor’s degree in a related discipline

Tools

AWS

Azure Data Factory (ADF)

Azure Synapse Analytics

Databricks

Apache Spark

Terraform

Kubernetes

Docker

Job description

Zachary Piper Solutions seeks a Senior Data Migration Engineer to support a data migration project for the FBI in Huntsville, Alabama. The role focuses on architecting, operating, validating, and optimizing data migration pipelines across cloud and on-prem environments.

You will design scalable ETL/ELT workflows, collaborate with cross-functional teams, and ensure robust performance, reliability, and security. This is a 100% onsite, long-term contract opportunity with competitive compensation.