Data Migration Test Analyst

Company Description

Fund services | Corporate | Capital markets | Private client | Regulatory & Compliance

We help clients succeed by unlocking new value through expertise, trust and scale. We deliver solutions that solve complex challenges faced by asset managers, financial institutions, corporates, high net-worth individuals and family offices.

With a curious mindset, we ask the right questions to get to the right solution, faster. We collaborate to win together, sharing successes and shaping the future of our global business. Our culture of support and recognition provides the tools and opportunities for you to grow, while unlocking the most value for our clients and making your mark with Ocorian.

Expertise: We deliver specialist, tech-enabled solutions for our clients grounded on deep industry expertise.

Trust: We’re a trusted partner to over 8,000 clients globally. We are proud to have long-lasting partnerships with our clients.

Scale: With more than 1,500 colleagues, we operate across 20 countries, our scale enables us to support our clients globally and locally, providing a seamless client experience across borders and service lines.

Job Description

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

Qualifications

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

Additional Information

All staff are expected to embody our core values that underpin everything that we do and that reflect the skills and behaviours we all need to be successful. These are:

• We are CLIENT CENTRIC – Clients are at the centre of our world, and we’re committed to providing expertise and specialist solutions to meet their most complex challenges.
• We are AMBITIOUS – We aim high. We think and act globally, seizing every opportunity to delight our clients and support our colleagues - wherever in the world they may be.
• We are AGILE – We act on our initiative to get things done for our clients. Our independence gives us the flexibility and freedom to keep things simple, efficient and effective.
• We are COLLABORATIVE – With a curious mindset, we ask the right questions to get to the right solution, for our clients faster. We collaborate to win together and share our successes.
• We are ETHICAL – We behave with integrity at all times and assume positive intent, building trust through responsible actions and honest relationships.

Equal Opportunities for Everyone

Please let us know if there’s anything we can do to make the process easier for you. You can reach us at [email protected].

We’re an equal opportunity employer. All applicants will be considered for employment without attention to age, ethnicity, religion, sex, sexual orientation, gender identity, family or parental status, national origin, or veteran, neurodiversity or disability status.