Data Migration Lead
New
T
Tria FederalFederal Digital Services
100% Remote within the United StatesFull-TimeLead
Salary not disclosed
Apply NowOpens the employer's application page
Job Details
- Experience
- 8+ years of data migration experience, with at least 4 years leading enterprise-scale data migration programs for federal government clients.
- Required Skills
- PythonSQLETL
Requirements
- 8+ years of data migration experience.
- 4+ years leading enterprise-scale data migration programs for federal government clients.
- Expertise in full-lifecycle migration methodology including discovery, profiling, mapping, ETL development, validation, and cutover planning.
- Strong SQL and ETL development skills.
- Experience with Python, SSIS, Talend, Informatica, or equivalent data integration tooling.
- Experience migrating data from federal legacy systems.
- Familiarity with data governance principles, data lineage documentation, and migration audit trail requirements.
- Experience developing and executing data validation frameworks to certify migration completeness and accuracy.
- Bachelor's degree in Computer Science, Information Systems, or related technical field.
- Ability to obtain and maintain government security clearance.
Responsibilities
- Lead the end-to-end data migration workstream, including source system analysis, data mapping, ETL design, migration execution, validation, and cutover.
- Develop the Data Migration Strategy and Plan, including phased migration approach, risk assessment, rollback procedures, and cutover readiness criteria.
- Conduct source system data profiling across VA legacy contract repositories, documenting data quality issues, structural inconsistencies, and transformation requirements.
- Design and implement the data mapping and transformation logic that converts legacy contract records into the Appian target data model.
- Develop and execute a comprehensive data validation framework, certifying that migrated records are complete, accurate, and audit-traceable.
- Ensure migrated data preserves provenance metadata, enabling traceability back to the exact source record, version, and extraction date.
- Partner with the Financial Systems SME to ensure accurate representation of LOA data, obligation records, and financial history in migrated contract records.
- Coordinate with the Enterprise Architect to ensure migration architecture aligns with target system design and does not introduce downstream integration risks.
- Lead migration rehearsal activities and document lessons learned, refining the cutover plan ahead of each production migration event.
- Provide knowledge transfer documentation enabling the program's O&M team to manage ongoing incremental data loads and ad hoc migration requests.
View Full Description & ApplyYou'll be redirected to the employer's site
