Senior Data Migration Engineer - 177579

Zachary Piper, LLC

Virginia

On-site

USD 155,000 - 175,000

Full time

3 days ago
Be an early applicant

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

Medical benefits
Dental benefits
Vision benefits
401(k)
PTO
Paid Holidays

Job summary

Zachary Piper Solutions is seeking a Senior Data Migration Engineer to lead large-scale data migration, integration, and modernization for a federal program in Quantico, VA. On-site role requiring an active Top Secret clearance.

You will design ETL/ELT pipelines, manage data transformations, and collaborate with Cloud Engineering, DevSecOps, QA, and Data Engineering teams to ensure secure, accurate migrations.

Qualifications

  • Active Top Secret clearance is required.
  • Bachelor's degree in Computer Science, Information Technology, Data Engineering, or related field.
  • 8+ years of hands-on experience in data migration, ETL/ELT development, or large-scale data engineering.
  • Strong experience designing, developing, and maintaining complex ETL/ELT pipelines.
  • Expertise in structured and unstructured data extraction, transformation, cleansing, and validation.
  • Experience developing data mapping specifications, transformation logic, and data integration workflows.
  • Experience supporting large-scale data migrations involving high-volume datasets and multiple source systems.
  • Familiarity with cloud-based data migration environments, preferably AWS.
  • Experience with data pipeline automation, performance optimization, and troubleshooting.
  • Strong analytical, problem-solving, technical documentation, and communication skills.

Responsibilities

  • Design, develop, and optimize ETL/ELT pipelines for large-scale data migration and integration.
  • Lead data extraction, transformation, cleansing, and loading across structured and unstructured datasets.
  • Develop data mapping frameworks, transformation logic, and migration strategies for legacy-to-cloud environments.
  • Support high-volume migrations, ensuring data accuracy, completeness, integrity, and performance.
  • Implement automated data validation, reconciliation, anomaly detection, and error remediation processes.
  • Collaborate with Cloud Engineering, DevSecOps, QA, and Data Engineering teams for migration readiness and testing.
  • Mentor mid-level engineers and contribute to data migration best practices and standards.
  • Produce data dictionaries, migration procedures, and technical documentation.

Skills

ETL/ELT development
Data migration
Data extraction
Data transformation
Data cleansing
Data validation
Data mapping specs
Data integration workflows
Cloud migration (AWS)
Analytical thinking

Education

Bachelor's degree in CS / IT / Data Eng

Tools

AWS
AWS Glue
AWS DMS
Python
SQL
PySpark
Apache Spark

Job description

Zachary Piper Solutions is seeking a Senior Data Migration Engineer to support large-scale data migration, integration, and modernization initiatives for a mission-critical federal program in Quantico, VA. The Senior Data Migration Engineer will design and optimize ETL/ELT pipelines, lead complex data transformation and validation efforts, and support the migration of structured and unstructured datasets from legacy systems to modern cloud environments. This individual will collaborate with Cloud Engineering, DevSecOps, QA, and Data Engineering teams to ensure secure, accurate, and efficient data migrations. This position will be onsite in Quantico, VA and requires an active Top Secret clearance!

Responsibilities of the Senior Data Migration Engineer:
  • Design, develop, and optimize ETL/ELT pipelines supporting large-scale data migration and integration initiatives
  • Lead data extraction, transformation, cleansing, and loading activities across structured and unstructured datasets
  • Develop data mapping frameworks, transformation logic, and migration strategies for legacy-to-cloud environments
  • Support high-volume data migrations, ensuring data accuracy, completeness, integrity, and performance
  • Implement automated data validation, reconciliation, anomaly detection, and error remediation processes
  • Optimize data pipelines for scalability, reliability, throughput, and repeatability
  • Collaborate with Cloud Engineering, DevSecOps, QA, and Data Engineering teams to support migration readiness and integration testing
  • Troubleshoot complex data migration issues, identify root causes, and implement corrective actions
  • Support cloud migration activities, legacy system decommissioning, and data integration initiatives
  • Participate in Agile development activities, including sprint planning, backlog refinement, and technical design reviews
  • Mentor mid-level engineers and contribute to data migration best practices and technical standards
  • Develop and maintain data mapping specifications, data dictionaries, migration procedures, and technical documentation
  • Identify migration risks, recommend mitigation strategies, and ensure compliance with federal data security and governance requirements
Qualifications for the Senior Data Migration Engineer:
  • Active Top Secret clearance
  • Bachelor's degree in Computer Science, Information Technology, Data Engineering, or a related discipline
  • 8+ years of hands-on experience in data migration, ETL/ELT development, or large-scale data engineering
  • Strong experience designing, developing, and maintaining complex ETL/ELT pipelines
  • Expertise in structured and unstructured data extraction, transformation, cleansing, and validation
  • Experience developing data mapping specifications, transformation logic, and data integration workflows
  • Experience supporting large-scale data migrations involving high-volume datasets and multiple source systems
  • Strong understanding of data quality, data integrity, reconciliation, and automated validation processes
  • Familiarity with cloud-based data migration environments, preferably AWS
  • Experience with data pipeline automation, performance optimization, and troubleshooting
  • Strong analytical, problem-solving, technical documentation, and communication skills
Compensation for the Senior Data Migration Engineer includes:
  • Salary: $155,000 - $175,000
  • Comprehensive Benefits Package including Medical, Dental, Vision, 401(k), PTO, and Paid Holidays

#LI-MM1 #LI-ONSITE

Keywords:

Senior Data Migration Engineer, Data Migration Engineer, Data Engineer, Senior Data Engineer, ETL Developer, ETL Engineer, Data Integration Engineer, Data Migration, ETL, ELT, ETL Pipelines, ELT Pipelines, Data Extraction, Data Transformation, Data Loading, Data Cleansing, Data Validation, Data Reconciliation, Data Mapping, Data Integration, Data Quality, Data Integrity, Data Governance, Structured Data, Unstructured Data, Big Data, Petabyte Scale Data Migration, Legacy System Migration, Cloud Migration, AWS, Amazon Web Services, Cloud Data Engineering, AWS Glue, AWS DMS, Data Pipelines, Pipeline Automation, Python, SQL, PySpark, Apache Spark, Distributed Computing, Data Warehousing, Data Lake, Data Modernization, Data Architecture, DevSecOps, CI/CD, Agile, Scrum, Automated Testing, Performance Optimization, Federal IT, Top Secret Clearance, Active Top Secret, Huntsville AL, Alabama, Onsite Jobs, Federal Data Engineering

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Data Migration Engineer - 177579
Senior Data Migration Engineer - 177579

Piper Companies • Quantico (VA)

On-site
USD 155,000 - 175,000
Medical
Dental
Vision
+3
Senior Data Migration Engineer - 177736
Senior Data Migration Engineer - 177736

Piper Companies • Huntsville (AL)

On-site
USD 155,000 - 175,000
Medical insurance
Dental insurance
Vision insurance
+3
Senior Data Migration Engineer - 177736
Senior Data Migration Engineer - 177736

Zachary Piper, LLC • Huntsville (AL)

On-site
USD 155,000 - 175,000
Medical, Dental, Vision
401(k)
PTO
+1
Data Migration Engineer - Senior
Data Migration Engineer - Senior

Zachary Piper, LLC • Huntsville (AL)

On-site
USD 165,000 - 175,000
PTO
Paid Holidays
Medical insurance
+4
Data Migration Engineer
Data Migration Engineer

Piper Companies • Quantico (VA)

On-site
USD 165,000 - 175,000
Full benefits package
Data Migration Engineer - Senior - 175304 - 176093 - 177039
Data Migration Engineer - Senior - 175304 - 176093 - 177039

Zachary Piper, LLC • Huntsville (AL)

On-site
USD 165,000 - 175,000
PTO
Paid Holidays
Medical
+5
Data Migration Engineer - Senior - 175304 - 176093 - 177039
Data Migration Engineer - Senior - 175304 - 176093 - 177039

Piper Companies • Huntsville (AL)

On-site
USD 165,000 - 175,000
Full benefits package
401K plan
Tuition reimbursement
Sr. Data Migration Engineer (Top Secret)
Sr. Data Migration Engineer (Top Secret)

Piper Companies • Quantico (VA)

On-site
USD 155,000 - 175,000
Sr. Data Migration Engineer (Top Secret)
Sr. Data Migration Engineer (Top Secret)

Zachary Piper, LLC • Virginia

On-site
USD 155,000 - 175,000
Full Benefits: PTO/Holidays, Medical, 
401k
Mid-Level Data Migration Engineer
Mid-Level Data Migration Engineer

Piper Companies • Quantico (VA)

On-site
USD 125,000 - 145,000