Global Banking & Markets - Private - Dallas - Analyst - Loan Management - Trade Analytics

Responsibilities

• Work with the trading desk on various stages of potential non-performing, re-performing loan and new originations bids (NPL/RPL/New Orig), normalize and load loan level data into internal databases, analyze and stratify pools, determine appropriate modeling assumptions, run analytics and produce bid packets and investment committee memos
• Interact with the Mortgage Banking team on deal securitizations to produce analytics, schedules for the governing documents, accurate loan level data, and work with transaction managers on diligence items
• Collaborate with the desk on monthly marking of residential mortgage warehouse positions
• Collaborate with transaction managers and due diligence teams to ensure all post-bid activities data related to final settlement of awarded bids are accurately reflected in the systems
• Produce detailed monthly reports on P&L, returns, cash flows and collateral performance of the loan portfolio across multiple portfolios
• Conduct a periodic model back-testing on the existing portfolio and recommend modeling assumptions adjustments to the trading desk
• Collaborate across internal teams (Data Management, Operations, Technology, and Modeling) to ensure the quality of data, accurate cash processing, and validate modeling assumptions

Qualifications

• Undergraduate in Finance, Economics, Mathematics, or other STEM related degree
• Superior analytical skills and attention to detail
• Exceptional communication skills with the ability to manage internal and external relationships
• Advanced Excel skills with knowledge in advanced functions such as vlookup, ifs, sumproducts, index/matches, etc.
• Technical Skills including CAS, Excel VBA, SQL Programming and Tableau a huge plus
• Ability to perform under fast-paced environment with tight time constraints