Senior Data Migration Engineer - ETL & Cloud Modernization

Piper Companies; Quantico (VA); On-site; USD 155,000 - 175,000; Full time

Job summary

Zachary Piper Solutions is seeking a Senior Data Migration Engineer to design and operate large-scale ETL/ELT pipelines for a high-profile FBI migration project in Huntsville, AL or Quantico, VA. The role is 100% onsite in these locations, with collaboration across Cloud Engineers, DBAs, and DevSecOps to ensure successful migrations.

The position requires 8+ years of data engineering and ETL experience, a Top Secret clearance, and strong proficiency in Python, SQL, and cloud data platforms.

Qualifications

• Bachelor’s degree in a related discipline with 8+ years of data engineering and ETL experience.
• Active Top Secret clearance.
• Experience architecting and operating large-scale data migration pipelines in AWS or similar cloud.
• Proficient in Python, PowerShell, Bash and high-volume data processing.

Responsibilities

• Design, develop, and maintain scalable ETL/ELT pipelines for large-scale data migrations.
• Build and optimize extraction, transformation, and loading processes for structured and unstructured data sources.
• Develop automated workflows maximizing performance, reliability, and error recovery.
• Collaborate with Cloud Engineers, Data Engineers, DevSecOps, DBAs, QA/Test Engineers, and Product Owners to support migration objectives.
• Develop and maintain technical documentation including data mappings and workflow diagrams.

Skills

ETL development

Data engineering

Large-scale migrations

Security clearance

Education

Bachelor’s degree in a related discipline

Tools

Python

PowerShell

Bash

AWS

Azure

SQL

T-SQL

Databricks

Apache Spark

Hadoop

Kafka

Job description

Zachary Piper Solutions is seeking a Senior Data Migration Engineer to design and operate large-scale ETL/ELT pipelines for a high-profile FBI migration project in Huntsville, AL or Quantico, VA. The role is 100% onsite in these locations, with collaboration across Cloud Engineers, DBAs, and DevSecOps to ensure successful migrations.

The position requires 8+ years of data engineering and ETL experience, a Top Secret clearance, and strong proficiency in Python, SQL, and cloud data platforms.