Data Migration Test Analyst

Purpose of the Job
We’re seeking a meticulous and analytical Data Migration & Reconciliation Test Analyst to support the modernization of ETI’s legacy securitization systems and the migration of deal processing onto EMPIRE—our next‑generation Azure-based platform supporting MBS and ABS (RMBS, CMBS, consumer ABS) structured‑finance processing, cashflow analytics, and investor reporting.

This role is deeply embedded within the transformation team and will work cross‑functionally 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 data‑level and file‑level testing between ETI legacy MS Foxpro systems and EMPIRE.
• Perform structured reconciliations for MBS/ABS datasets, including loan‑level files, pool‑group aggregations, cashflow waterfalls, and remittance/investor reports.
• Conduct field‑by‑field comparisons across CSV, Excel, fixed‑width 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/no‑go 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 end‑to‑end validation.
  
  #LI-JM1
  #LI-Hybrid

Knowledge, Skills and Experience

• 3–7+ 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 data‑heavy 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 structured‑finance 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 legacy‑system modernization or platform migrations (Nice to have, not essential).

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