Senior Data Migration Engineer

General Dynamics IT; United States; On-site; USD 120,000 - 180,000; Full time

Job summary

General Dynamics IT seeks a seasoned data engineering professional to support the Case Management Modernization (CMM) program for the Administrative Office of the US Courts. You will lead enterprise data migration efforts to move 204+ federal courts to a modern cloud-based solution, coordinating with governance and security teams.

Responsibilities include designing migration strategies, building ETL/ELT pipelines, validating data, and automating reconciliation.

Qualifications

• MA/MS degree with 5+ years or BS/BA degree with 7+ years in information systems.
• Strong data engineering and architecture background with deep ETL/ELT and migration experience.
• Proficient in Python, Bash, SQL, and automation for migration scripts.

Responsibilities

• Plan, coordinate, and oversee enterprise data migration, conversion, and archival efforts.
• Develop migration strategies, schedules, dependencies, and execution procedures.
• Build and maintain migration scripts, SQL, and ETL/ELT pipelines for legacy-to-cloud data transfers.
• Execute extraction, transformation, loading, and post-load validation activities.
• Perform data profiling, cleansing, mapping, and transformation; define source-to-target mappings.
• Validate migrated data through reconciliation, completeness checks, and QA testing.
• Manage cutover activities, including pre-checks, execution, validation, and sign-off.
• Automate data reconciliation and validation processes.
• Support migration testing, mock runs, rehearsals, cutovers, and rollback procedures.
• Design and implement data archival processes aligned with retention and governance standards.
• Troubleshoot and resolve migration issues and discrepancies.
• Document migration procedures, mappings, and runbooks.
• Work with governance, quality, and business teams to validate data against standards and rules.
• Tune migration jobs to maximize throughput and minimize downtime.
• Participate in planning, risk assessments, and rollback strategy development.
• Maintain migration logs, issue registers, and execution reports.
• Support archival and retention activities with Data Governance and Records Management.
• Collaborate with DBAs, platform engineers, architects, app teams, and governance groups.
• Optimize migration performance for large-scale, high-volume datasets.
• Ensure compliance with security, privacy, classification, retention, and governance requirements.
• Maintain migration runbooks and operational procedures.
• Support production cutovers and post-migration stabilization.
• Contribute to continuous improvement and automation of migration processes.
• Manage and optimize cloud data platforms, including account setup, configuration, scaling, performance tuning, and warehouse / lakehouse operations.
• Govern databases, schemas, roles, and RBAC to align with AO security, IAM, & compliance policies.
• Monitor, troubleshoot pipelines, queries, concurrency, & resource utilization for uptime & cost efficiency.
• Implement cost‑optimization strategies and support financial reporting, forecasting, and TCO analysis.
• Automate and document provisioning, access management, data loading, and monitoring using Terraform, dbt, SQL, Python, or similar tools.
• Partner with data engineers, BI teams, and architects to design efficient data models and optimize ELT workflows.
• Support security audits, ATO artifacts, incident response, DR/HA testing, and operational runbooks for modern cloud data platform services.

Skills

Data migration

ETL design

ETL development

ETL processing

Python

SQL

Bash

Automation

Education

MA/MS degree

BS/BA degree

Tools

Informatica

Talend

AWS DMS

ADF

Job description

Seize your opportunity to make a personal impact supporting the Case Management Modernization (CMM) Program. The CMM program is an initiative to support the Administrative Office of the US Courts (AO) in developing a modern cloud-based solution to support all 204+ federal courts across the United States.

Job Family

Data Science and Data Engineering

Job Qualifications

• Skills: Data Migration Design, ETL Design, ETL Development, ETL Processing
• Certifications: None
• Experience: 5 + years of related experience
• US Citizenship Required: No

Responsibilities

• Plan, coordinate, and oversee enterprise data migration, conversion, and archival efforts.
• Develop migration strategies, schedules, dependencies, and execution procedures.
• Build and maintain migration scripts, SQL, and ETL/ELT pipelines for legacy-to-cloud data transfers.
• Execute extraction, transformation, loading, and post-load validation activities.
• Perform data profiling, cleansing, mapping, and transformation; define source-to-target mappings.
• Validate migrated data through reconciliation, completeness checks, and QA testing.
• Manage cutover activities, including pre-checks, execution, validation, and sign-off.
• Automate data reconciliation and validation processes.
• Support migration testing, mock runs, rehearsals, cutovers, and rollback procedures.
• Design and implement data archival processes aligned with retention and governance standards.
• Troubleshoot and resolve migration issues and discrepancies.
• Document migration procedures, mappings, and runbooks.
• Work with governance, quality, and business teams to validate data against standards and rules.
• Tune migration jobs to maximize throughput and minimize downtime.
• Participate in planning, risk assessments, and rollback strategy development.
• Maintain migration logs, issue registers, and execution reports.
• Support archival and retention activities with Data Governance and Records Management.
• Collaborate with DBAs, platform engineers, architects, app teams, and governance groups.
• Optimize migration performance for large-scale, high-volume datasets.
• Ensure compliance with security, privacy, classification, retention, and governance requirements.
• Maintain migration runbooks and operational procedures.
• Support production cutovers and post-migration stabilization.
• Contribute to continuous improvement and automation of migration processes.
• Manage and optimize cloud data platforms, including account setup, configuration, scaling, performance tuning, and warehouse / lakehouse operations.
• Govern databases, schemas, roles, and RBAC to align with AO security, IAM, & compliance policies.
• Monitor, troubleshoot pipelines, queries, concurrency, & resource utilization for uptime & cost efficiency.
• Implement cost‑optimization strategies and support financial reporting, forecasting, and TCO analysis.
• Automate and document provisioning, access management, data loading, and monitoring using Terraform, dbt, SQL, Python, or similar tools.
• Partner with data engineers, BI teams, and architects to design efficient data models and optimize ELT workflows.
• Support security audits, ATO artifacts, incident response, DR/HA testing, and operational runbooks for modern cloud data platform services.

Qualifications

• MA/MS degree with 5+ years or BS/BA degree with 7+ years of general experience in information systems and 5+ years of specialized experience.
• Strong data engineering and architecture background with deep ETL/ELT and migration experience (Informatica, Talend, AWS DMS, ADF).
• Skilled in Python, Bash, SQL, and automation for migration scripts, validation, and reconciliation.
• Expertise in AWS data migration services, cloud-native data platforms, and hybrid cloud environments.
• Preferred hands‑on experience with