Data Migration Lead

About the role

The Data Migration Lead is responsible for planning, designing, and executing the full-scope historical data migration that transforms VA's legacy contract and acquisition records into the structured, normalized data model of the modernized Appian platform.

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.
• Cook up 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.
• Develop and maintain document and data normalization deliverables that bring historical contract actions into a consistent structured dataset.
• Support post-migration data monitoring, resolving data quality issues identified during production operations.
• Provide knowledge transfer documentation enabling the program's O&M team to manage ongoing incremental data loads and ad hoc migration requests.

Qualifications

• 8+ years of data migration experience, with at least 4 years leading enterprise-scale data migration programs for federal government clients.
• Demonstrated expertise in full-lifecycle migration methodology including discovery, profiling, mapping, ETL development, validation, and cutover planning.
• Strong SQL and ETL development skills, with experience in Python, SSIS, Talend, Informatica, or equivalent data integration tooling.
• Experience migrating data from federal legacy systems, with understanding of common data quality and normalization challenges in government environments.
• 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 required.
• Ability to obtain and maintain government security clearance.

Why Tria?

What defines the Tria brand is more than just our dedication to excellence in our craft; it’s our incredible team of dedicated, talented, and passionate people that make Tria so exceptional. As people powering possible, we are all partners in our team’s shared success. As a company that cares about people, we seek to cultivate a culture in which all can thrive personally and professionally. We offer a top-tier benefits package to invest in your physical, mental, and financial health and wellness so that you can be your best self - at work and in life.