Data Migration Test Analyst

Purpose of the Job
Were seeking a meticulous and analytical Data Migration & Reconciliation Test Analyst to support the modernization of ETIs legacy securitization systems and the migration of deal processing onto EMPIREour nextgeneration Azure-based platform supporting MBS and ABS (RMBS CMBS consumer ABS) structuredfinance processing cashflow analytics and investor reporting.

This role is deeply embedded within the transformation team and will work crossfunctionally with developers ETI analysts and business stakeholders to ensure data accuracy reconciliation completeness and smooth migration execution. You will be the connective layer between data technology and operations.

Main Responsibilities

• Execute detailed datalevel and filelevel testing between ETI legacy MS Foxpro systems and EMPIRE.
• Perform structured reconciliations for MBS/ABS datasets including loanlevel files poolgroup aggregations cashflow waterfalls and remittance/investor reports.
• Conduct fieldbyfield comparisons across CSV Excel fixedwidth text and other structured formats.
• Work directly with ETI analysts to clarify business rules validate exceptions and confirm expected results.
• Partner with EMPIRE developers to provide clear actionable defect reports reproduction steps annotated deltas and validation notes.
• Maintain a curated library of golden datasets expected outputs test cases and regression packs.
• Support migration governance by preparing reconciliation summaries variance logs and go/nogo evidence packs.
• Participate in recurring stakeholder meetings to report testing progress risks blockers timelines and confidence levels.
• Track issues through resolution and retesting ensuring accurate endtoend validation.
  
  #LI-JM1
  #LI-Hybrid

Qualifications :

Knowledge Skills and Experience

• 37 years of experience in data testing data QA reconciliation UAT or migration validation.
• Strong analytical skills with deep attention to detail especially in structured finance or dataheavy workflows.
• Solid Excel proficiency and comfort working with large datasets.
• Strong SQL skills and ability to query filter or isolate data subsets.
• Experience interacting with software developers and functional SMEs translating findings into precise defect documentation.
• Ability to manage multiple test cycles prioritize effectively and communicate results clearly.
• Experience with securitization reporting (MBS/ABS) or structuredfinance data models (Nice to have not essential). 
• Basic scripting (Python/C#) to automate comparisons or generate exception reports (Nice to have not essential).
• Exposure to legacysystem modernization or platform migrations (Nice to have not essential).

Additional Information :

All your information will be kept confidential according to EEO guidelines.

Remote Work :

No

Employment Type :

Full-time