Find similar career opportunities

Sr. Data Migration Engineer

Category: Database Administration

Main location: United States, Alabama, Huntsville

Position ID:J0926-2488

Employment Type: Full Time

Position Description:

CGI Federal is seeking a Senior Data Migration Engineer to lead complex data extraction, transformation, validation, and migration activities within a major federal modernization program. The engineer will support petabyte scale data transition efforts, ensuring accuracy, completeness, security, and performance in moving structured and unstructured datasets from legacy environments to modern cloud based architectures. This senior role provides technical leadership, develops advanced migration strategies, mentors mid level engineers, and ensures alignment with architecture, security, and mission requirements.
This position is located in Huntsville, AL.

Your future duties and responsibilities:

Advanced Data Migration & ETL Leadership
. Lead development, enhancement, and optimization of ETL/ELT pipelines for large scale, multi source data migration.
. Perform complex data extraction, transformation, governance, and cleansing activities supporting high volume data flows.
. Design data mapping frameworks and transformation logic for legacy to cloud migration.
. Guide automation improvements to increase pipeline throughput, resiliency, and repeatability.
Data Quality, Validation & Issue Resolution
. Conduct advanced data integrity analysis, completeness checks, anomaly detection, and error remediation.
. Support and lead quality verification for incoming and migrated datasets.
. Collaborate with QA/test engineering teams to embed automated validation within pipeline operations.
Technical Collaboration & Integration
. Coordinate with Cloud Engineers, DevSecOps teams, Data Engineers, Product Owners, and Scrum Masters to ensure alignment across technical workstreams.
. Support readiness testing for migration events, legacy system retirements, and cloud landing zone configuration.
. Participate in technical design reviews, sprint planning, backlog refinement, and integration checkpoints.
Migration Strategy & Leadership
. Provide guidance to mid level engineers on data migration methods, ETL tools, best practices, and troubleshooting.
. Develop and refine reusable templates, mapping documents, and procedural artifacts.
. Proactively identify risks impacting migration success and propose mitigation strategies.
Documentation, Reporting & Compliance
. Create detailed migration documentation, including mapping specifications, data dictionaries, flow diagrams, and SOPs.
. Contribute to migration status reporting, dashboard updates, and operational metrics.
. Ensure alignment with federal data governance, security, and handling requirements.

Required qualifications to be successful in this role:

. Must have Active Top Secret Security Clearance.
. U.S. Citizenship.
. Bachelor's degree and 8+ years of hands on experience in data migration, ETL development, or large scale data engineering.
. Expertise in structured/unstructured data transformation, cleansing, and validation.
. Experience designing and operating advanced ETL/ELT pipelines.
. Familiarity with cloud migration (AWS preferred), big data tooling, and automation.
. Strong problem solving skills and ability to support complex, high volume migration operations.
Desired qualifications/non essential skills required:
. Experience with petabyte scale data migrations or multi system consolidation.
. Background supporting DOJ, FBI, IC, or national security modernization programs.
. Experience with DevSecOps pipelines, CI/CD workflows, or automated testing frameworks.
. Advanced knowledge of scripting languages, distributed compute tools, or cloud native ETL services.
CGI is required by law in some jurisdictions to include a reasonable estimate of the compensation range for this role. The determination of this range includes various factors not limited to skill set, level, experience, relevant training, and licensure and certifications. To support the ability to reward for merit based performance, CGI typically does not hire individuals at or near the top of the range for their role. Compensation decisions are dependent on the facts and circumstances of each case. A reasonable estimate of the current range for this role in the U.S. is $89,600.00 $198,400.00.
CGI Federal's benefits are offered to eligible professionals on their first day of employment to include:
. Competitive compensation
. Comprehensive insurance options
. Matching contributions through the 401(k) plan and the share purchase plan
. Paid time off for vacation, holidays, and sick time
. Paid parental leave
. Learning opportunities and tuition assistance
. Wellness and Well being programs
#CGIFederalJob
#LI DD1

Skills:

• Communication
• Data Mapping
• Data Migration
• ETL
• DevOps Security