Analyst – Due Diligence, Securitized Products (U.S. Assets & Consumer)
About the role
SitusAMC is seeking an Experienced Analyst to join the Due Diligence team within Securitized Products, focusing on U.S. residential mortgage and consumer asset diligence.
Responsibilities
- Conduct independent due diligence reviews on residential mortgage and consumer loan portfolios, including credit, collateral, compliance, and data integrity assessments.
- Perform advanced data analysis to identify trends, concentrations, and credit or data risks across large datasets.
- Lead data tape reviews, exception analysis, and diligence summaries for financing and securitization transactions.
- Build, maintain, and enhance Excel-based analytical tools and contribute to automation efforts using SQL, Python, or VBA where applicable.
- Review and challenge third-party diligence outputs, ensuring alignment with internal standards.
- Prepare and review investor-facing diligence materials and transaction memos.
- Interact directly with traders, structurers, bankers, and external diligence providers.
- Support process improvements across mortgage and consumer diligence workflows.
Qualifications
- Bachelor’s degree in a quantitative or technical discipline; advanced degree is a plus.
- 2–3 years of relevant experience in mortgage finance, consumer lending, securitized products, or loan-level analytics.
- Advanced proficiency in Microsoft Excel, including complex formulas, pivot tables, and large dataset analysis.
- Working knowledge of SQL and/or Python for data analysis; VBA or automation experience preferred.
- Solid understanding of RMBS, ABS, consumer securitizations, or whole-loan transactions.
- Ability to manage multiple transactions simultaneously under tight deadlines.
What it's like to work here
From originations to secondary market activity – and everything in between – we bring together an experienced, proven team and breakthrough technology enabling clients to grow with agility and efficiency. And, whether you’re right out of school, a real estate veteran or a leader in a corporate or technology area, you’ll have a front row seat to it all.
Part of a global team
- Whether you’re working in one of our Real Estate businesses, or in Technology or a Corporate function, you’ll have plentiful learning opportunities and be greeted by a team who values your contribution.
- And, when it comes to benefits, you can expect above-and-beyond offerings supporting your emotional, physical and financial wellness.