Skip to main content
Back to jobs

Analyst - Due Diligence, Securitized Products (U.S. Assets & Consumer)

External
situsamc logoSitusamc · New York, NY
Full-timeOn-site2w ago
ComplianceData AnalysisExcelPythonSQLVBA
Cover LetterConnect

Prepare for this interview

Elite

AI-generated questions, company research, and talking points tailored to this role


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.

Requirements

  • 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.
  • Ideal Candidate
  • Prior experience with consumer and/or mortgage loan data tapes , diligence reviews, and transaction execution.
  • Strong analytical judgment and ability to clearly communicate findings to stakeholders.
  • Highly detail-oriented, proactive, and comfortable operating with limited supervision.
  • The annual full time base salary range for this role is
  • $105,000.00 - $125,000.00
  • Pay Transparency Nondiscrimination Provision
  • Know Your Rights, Workplace Discrimination is Illegal

Benefits

Dental insuranceVision insurance401(k)Paid time offPerformance bonus

Additional Information

SitusAMC is where the best and most passionate people come to transform our client's businesses and their own careers. Whether you're a real estate veteran, a passionate technologist, or looking to get your start, join us as we work together to realize opportunities for everyone, we proudly serve. At SitusAMC, we are looking to match your unique experience with one of our amazing careers, so that we can help you realize your potential and career growth within the Real Estate Industry. If you are someone who can be yourself, advocate for others, stay nimble, dream big, own every outcome, and think global but act local - come join our team! We are seeking an Experienced Analyst to join the Due Diligence team within Securitized Products, with a focus on U.S. residential mortgage and consumer asset diligence. This role requires prior hands-on experience reviewing loan-level and consumer credit data, with increasing ownership of analytical workstreams and transaction support. The Experienced Analyst will independently conduct diligence reviews across mortgage and consumer portfolios, partner closely with trading and structuring teams, and serve as a key analytical resource throughout the transaction lifecycle


Your Match

How well this role fits your profile.

Company Intel

What employees say

Worked at situsamc? Share your experience

Interested in this role?

Apply on the company's website.

Cover LetterConnect