Structured Finance Data Analyst (MBS/ABS)

Ocorian • Philadelphia, PA

11h • Hybrid

About The Position

Ocorian is a global provider of fund services, corporate, capital markets, private client, and regulatory & compliance solutions. They aim to help clients succeed by unlocking new value through expertise, trust, and scale, delivering specialist, tech-enabled solutions to 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 support, recognition, and collaboration. The company is seeking a meticulous and analytical Structured Finance Data Analyst to support the modernization of ETI’s legacy securitization systems and the migration of deal processing onto EMPIRE, their next-generation Azure-based platform. This platform supports 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, serving as the connective layer 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

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