Structured Finance Data Analyst (MBSABS)

Please note that we do not offer visa sponsorship for this role.

Purpose of the Job
Were seeking a meticulous and analytical Structured Finance Data 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 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 were 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 theres anything we can do to make the process easier for you. You can reach us at .

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

Remote Work :

No

Employment Type :

Full-time