Senior Data Migration Engineer

General Dynamics Information Technology•USA DC Home Office (DCHOME), DC

2d•$122,275 - $165,431•Remote

About The Position

The Senior Data Migration Engineer will support GDIT’s Case Management Modernization (CMM) Program for the Administrative Office of the U.S. Courts. As part of the CMM Data Modernization and Governance team, the role supports integrated data governance, engineering, data platform, reporting, analytics, and AI/ML capabilities. The position plans and executes enterprise migration, conversion, transformation, and archival activities, transitioning data securely and accurately between source systems and modern cloud data platforms. The engineer develops and maintains migration scripts and ETL/ELT pipelines; profiles, maps, cleanses, transforms, and validates data; coordinates testing, rehearsals, cutovers, and rollback procedures; and documents procedures, mappings, logs, and runbooks. The role also supports cloud data platform operations, including configuration, scaling, performance and cost optimization, access governance, monitoring, security audits, disaster recovery, and operational readiness. Collaboration with data, platform, application, architecture, business, and governance teams is central to the work.

Requirements

MA/MS degree with at least 5 years of general experience, or BS/BA degree with at least 7 years of general experience, in information systems, and at least 5 years of specialized experience.
Strong data engineering and architecture background with deep ETL/ELT and data migration experience, including tools such as Informatica, Talend, AWS DMS, or ADF.
Proficiency 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.
Strong SQL performance tuning and query optimization skills, including indexing, partitioning, and execution-plan analysis.
Proficiency with Terraform, dbt, infrastructure as code, and automation frameworks supporting scalable migrations.
Experience with CI/CD, GitOps, DevSecOps, and enterprise build and release pipelines.
Ability to troubleshoot complex migration issues under tight cutover windows with attention to detail.
Experience with containerized application workflows and cloud platform operations.
Familiarity with federal security, compliance, and governance frameworks such as FedRAMP, NIST, and JISF.
Skill in log and metric analysis and cloud performance tuning, with strong analytical and problem-solving abilities.
Ability to collaborate across data, platform, and governance teams.
Experience with FinOps, cost modeling, and cloud optimization to support modernization initiatives.

Nice To Haves

Hands-on experience with Snowflake, Databricks, Redshift, SQL Server, Oracle, PostgreSQL, and large-scale analytical workloads.
Experience supporting Federal Government programs or regulated environments.
Experience optimizing large-scale analytical workloads.
Certified Data Management Professional (CDMP).
Snowflake SnowPro Advanced certification.
Databricks Certified Data Professional certification.
AWS Certified Data Analytics - Specialty certification.
AWS Certified Solutions Architect - Professional certification.
AWS Certified Data Engineer certification.
Docker Certified Associate certification.
Certified Kubernetes Administrator certification.
Certified Professional DevSecOps Certification Course.
ITIL, AWS SysOps, or Google Cloud DevOps Engineer certification.

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, including defining source-to-target mappings.
Validate migrated data through reconciliation, completeness checks, and quality assurance 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; maintain migration logs, issue registers, and execution reports.
Work with governance, quality, and business teams to validate data against standards and rules.
Tune migration jobs and optimize migration performance for large-scale, high-volume datasets to maximize throughput and minimize downtime.
Participate in planning, risk assessments, and rollback strategy development.
Support archival and retention activities with Data Governance and Records Management.
Collaborate with DBAs, platform engineers, architects, application teams, and governance groups.
Ensure compliance with security, privacy, classification, retention, and governance requirements.
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 role-based access control in alignment with AO security, identity and access management, and compliance policies.
Monitor and troubleshoot pipelines, queries, concurrency, and resource utilization for uptime and cost efficiency.
Implement cost-optimization strategies and support financial reporting, forecasting, and total cost of ownership analysis.
Automate and document provisioning, access management, data loading, and monitoring using Terraform, dbt, SQL, Python, or similar tools.
Partner with data engineers, business intelligence teams, and architects to design efficient data models and optimize ELT workflows.
Support security audits, authorization-to-operate artifacts, incident response, disaster recovery/high availability testing, and operational runbooks for modern cloud data platform services.

Benefits

Medical plan options, including options with Health Savings Accounts.
Dental plan options.
Vision plan.
401(k) plan with pre-tax and post-tax contribution options and company match.
Full flex work weeks where possible.
Paid time off plans, including vacation, sick and personal time.
Paid holidays.
Paid parental, military, bereavement, and jury duty leave.
Typically 15 days of paid leave per calendar year for new employees, prorated based on hire date.
An additional 10 paid holidays per year, prorated based on hire date.
Paid Family Leave of up to 160 hours in a rolling 12-month period for eligible employees.
Short- and long-term disability benefits.
Life, accidental death and dismemberment, personal accident, critical illness, and business travel and accident insurance, provided or available.