Data Migration Analyst
Integral•Tysons, VA
•$130,000 - $140,000
About The Position
The Data Migration Analyst translates legacy BOSS-E, MBMS, and related data into approved VA-EISS source-to-target mappings, business rules, and reconciliation criteria. The role uses AI-assisted analysis only where authorized by the VA and validates generated mappings and SQL against authoritative records to support VA-EISS modernization.
Requirements
- Bachelor’s degree in computer science or an IT-related field and 3–6 years of experience; additional years of experience may substitute for a degree for the right candidate.
- Strong SQL, data profiling, source-to-target mapping, data quality, and reconciliation experience.
- Experience interpreting complex legacy relational data and translating business rules into testable conversion specifications.
- Ability to independently validate AI-generated mappings, SQL queries, and analytical results against source evidence.
- Strong facilitation skills with technical and business stakeholders.
- Public Trust.
Nice To Haves
- Experience with BOSS-E, MBMS, EISS, or cemetery/memorial case data, and Oracle, Salesforce, or SQL Server data structures.
- Experience with large-scale federal data migration, record retention, and personally identifiable information controls.
- Python, data catalog or lineage methods, and approved AI-assisted data analysis.
Responsibilities
- Profile legacy data and document source-to-target field mappings, lineage, reference codes, relationships, and exceptions for VA-EISS conversion.
- Collaborate with NCA subject matter experts, Functional Architects, developers, and data engineers to confirm data meaning, retention, and migration acceptance rules.
- Review AI-generated mapping drafts, profiling SQL, and reconciliation scripts for correctness, completeness, and unsupported assumptions.
- Define and execute data quality checks, sampling, exception queues, and migration rehearsal acceptance criteria.
- Track mapping decisions and data defects, and verify converted records and audit evidence with the pod QA engineer.
Benefits
- Paid parental leave
- Immediate vesting in the 401(k)
- Medical, dental, and vision insurance
- Flexible spending accounts
- Short-term and long-term disability insurance
- Life insurance
- Paid time off and holidays
- Earned bonuses and awards
- Professional training reimbursement
- Employee Assistance Program
- Potential eligibility for overtime, shift differential, and/or discretionary bonuses
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
Upload and Match Resume
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
