Senior Data Migration Engineer Scalable ETL Architect

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

Benefits offered by this job

PTO/Holidays

Medical, Dental, Vision

401k

Job summary

Zachary Piper Solutions seeks a Senior Data Migration Engineer to support a data migration project for the FBI in Huntsville, AL. You will architect, operate, validate, and optimize ETL/ELT pipelines for large-scale migrations, collaborating with Cloud, Data, and DevSecOps teams to ensure secure, scalable delivery.

The role requires a Bachelor’s degree and 8+ years in data engineering with Top Secret clearance, and extensive experience in AWS-based data pipelines, Azure Synapse, and modern data

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

Responsibilities

• Design, develop, and maintain scalable ETL/ELT pipelines for large-scale migrations.
• Build and optimize extraction, transformation, and loading processes for structured and unstructured data sources.
• Develop automated workflows for performance, reliability, and error recovery.
• Align pipeline architectures with cloud modernization and landing zone standards.
• Collaborate with Cloud, Data, DevSecOps teams, DBAs, QA, and Product Owners to meet migrations goals.
• Ensure ETL integration with cloud infrastructure, data models, monitoring, and downstream apps.
• Create and maintain technical documentation including data mappings and SOPs.

Skills

ETL design

Data pipelines

Python

PowerShell

Bash

AWS

Cloud data platforms

Data transformation

Education

Bachelor's degree

Tools

AWS

Azure Data Factory (ADF)

Azure Synapse Analytics

Databricks

SQL/NoSQL databases

Kubernetes

Docker

Job description

Zachary Piper Solutions seeks a Senior Data Migration Engineer to support a data migration project for the FBI in Huntsville, AL. You will architect, operate, validate, and optimize ETL/ELT pipelines for large-scale migrations, collaborating with Cloud, Data, and DevSecOps teams to ensure secure, scalable delivery.

The role requires a Bachelor’s degree and 8+ years in data engineering with Top Secret clearance, and extensive experience in AWS-based data pipelines, Azure Synapse, and modern data