Cloud Data Migration Lead - ETL & Automation

General Dynamics IT

United States

On-site

USD 120,000 - 180,000

Full time

5 days ago

Be an early applicant

Application generator

A complete application in a minute — tailored resume and cover letter, ready to send.

Get past ATS filters

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.