Sr. Data Migration Engineer (Top Secret)

Zachary Piper, LLC; Virginia; On-site; USD 155,000 - 175,000; Full time

Benefits offered by this job

Full Benefits: PTO/Holidays, Medical, 

401k

Job summary

Zachary Piper Solutions is seeking a Senior Data Migration Engineer to support a critical FBI data migration project in Huntsville, AL or Quantico, VA. You will architect, operate, validate, and optimize ETL/ELT pipelines for large-scale migrations in a 100% onsite environment.

The role requires 8+ years of data engineering experience, proficiency with ETL tools, cloud ingestion, and scalable workflows. You will collaborate with Cloud, Data, DevSecOps teams to ensure alignment with cloud

Qualifications

• Bachelor’s degree required plus 8+ years in data engineering, ETL, and large-scale migrations.
• Active Top Secret clearance required.
• Strong experience with ETL tools, automation (Python, PowerShell, Bash), and high-volume pipelines.

Responsibilities

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

Skills

ETL

ELT

Python

PowerShell

Bash

AWS

Cloud

Data Pipelines

SQL

Databricks

Terraform

Education

Bachelor’s degree in a related discipline

8+ years data engineering, ETL, migrations

Tools

Azure Data Factory (ADF)

Azure Synapse Analytics

Databricks

Snowflake

NIFI

Kubernetes

Docker

Git

Terraform

CI/CD

Job description

Location: Huntsville, AL or Quantico, VA (100% onsite)

Zachary Piper Solutions is seeking a Senior Data Migration Engineer to support a data migration project for the FBI in Huntsville, AL or Quantico, VA. The team is seeking an engineer with expertise architecting, operating, validating, and optimizing data migration pipelines for a critical project. Details below:

This job opens for applications on 11/9/2026. Applications for this job will be accepted for at least 30 days from the posting date

Responsibilities of the Data Migration Engineer:

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

Qualifications of the Data Migration Engineer:

• Bachelor’s degree in a related discipline and 8+ years of data engineering, ETL development, and large scale migrations
• Active Top Secret clearance
• Strong experience with ETL tools, automation frameworks (Python, Powershell, Bash), and high volume data pipelines.
• Experience with legacy system extraction, cloud ingestion, and multi format data transformation
• Ability to operate in a fast past environment
• Experience operating ETL pipelines within AWS or other cloud environment

Compensation of the Data Migration Engineer:

• Total compensation based on experience level - $155,000-$175,000+ **based on experience level and total years of experience**
• Full Benefits: PTO/Holidays, Medical, Dental, and Vision, 401k
• Brand-new, long term contract

#LI-MK1 #LI-Onsite

Keywords: Data Engineering, ETL Development, ELT Architecture, Data Pipelines, Data Integration, Data Migration, Data Warehousing, Data Modeling, Data Transformation, Data Validation, Data Quality Management, Data Governance, Big Data, Cloud Data Platforms, Azure Data Factory (ADF), Azure Synapse Analytics, Microsoft Fabric, Top secret, ts/sci, polygraph, Federal, Intelligence, Government, W2, opentowork, hiring, Apache, NIFI, python, ansible, terraform, Databricks, Apache Spark, Hadoop, Kafka, Snowflake, AWS Glue, Amazon Redshift, Google BigQuery, SQL, T-SQL, Python, PySpark, Scala, API Integration, REST APIs, Batch Processing, Real-Time Data Processing, Streaming Data, CI/CD Pipelines, DevOps, DevSecOps, Workflow Automation, Performance Tuning, Query Optimization, Data Lake Architecture, Data Lakehouse, Metadata Management, Master Data Management (MDM), Database Administration, Relational Databases, NoSQL Databases, Data Security, Data Encryption, Monitoring and Alerting, Root Cause Analysis, Troubleshooting, Error Handling, Scalability, High Availability, Migration Planning, Cloud Modernization, Data Reconciliation, Data Lineage, Data Mapping, Change Data Capture (CDC), Agile Methodologies, Scrum, Technical Documentation, Cross-Functional Collaboration, Business Intelligence, Power BI, Reporting and Analytics, Machine Learning Data Preparation, Infrastructure as Code (IaC), Terraform, Git, Version Control, Kubernetes, Docker, Enterprise Data Solutions.