Data Migration Test Analyst

Ocorian • Philadelphia, PA

2h • Hybrid

About The Position

Ocorian is a global provider of fund services, corporate, capital markets, private client, and regulatory & compliance solutions. The company helps clients succeed by unlocking new value through expertise, trust, and scale, delivering specialist, tech-enabled solutions for complex challenges faced by asset managers, financial institutions, corporates, high net-worth individuals, and family offices. With over 1,500 colleagues operating across 20+ countries, Ocorian fosters a culture of curiosity, collaboration, support, and recognition. The Data Migration & Reconciliation Test Analyst role is a key part of the transformation team, focused on modernizing ETI’s legacy securitization systems and migrating deal processing onto EMPIRE, Ocorian's next-generation Azure-based platform for MBS and ABS structured-finance processing, cashflow analytics, and investor reporting. This position requires cross-functional collaboration with developers, ETI analysts, and business stakeholders to ensure data accuracy, reconciliation completeness, and smooth migration execution, serving as the crucial link between data, technology, and operations.

Requirements

• 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.

Nice To Haves

• Experience with securitization reporting (MBS/ABS) or structured‑finance data models
• Basic scripting (Python/C#) to automate comparisons or generate exception reports
• Exposure to legacy‑system modernization or platform migrations

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.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed
• Number of Employees: 501-1,000 employees