Senior Data Migration Engineer

Type of Requisition:
Pipeline
Clearance Level Must Currently Possess:
None
Clearance Level Must Be Able to Obtain:
None Public Trust/Other Required:
None
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
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.

GDIT is your place to make meaningful contributions to challenging projects and grow a rewarding career. The Sr. Data Migration Engineer will work as part of the CMM Data Modernization and Governance team responsible for delivering an integrated data governance, engineering, data platform, reporting, analytics, and Artificial Intelligence (AI)/Machine Learning (ML) capabilities that support operational decision-making and fulfill AO's data and analytics objectives in support of the CMM program.

The successful candidate will be responsible for planning, coordinating, and executing enterprise data migration, conversion, transformation, and archival activities in support of the CMM Data Modernization & Governance program. The role develops migration scripts and pipelines, performs data profiling and mapping, executes data migration and transformation activities, and validates migrated data to ensure that data is accurately and securely transitioned between source and target modern cloud data platforms.

The Sr. Data Migration Engineer will execute the following 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, c