Loan Portfolio Analytics Analyst – Global Markets

The Goldman Sachs Group; Dallas (TX); On-site; USD 90,000 - 130,000; Full time

Job summary

The Goldman Sachs Group seeks an Analyst to support Global Markets Mortgage Loan Trading and Banking trades. You'll analyze performing and non-performing loan acquisitions, sales, securitizations, and back‑testing to inform bid decisions and investment committee materials.

Collaborating with Mortgage Banking, Data Management, Operations and Technology, you will produce monthly P&L, cash flow, and collateral performance analytics, while refining modeling assumptions to drive portfolio performance.

Qualifications

• Undergraduate degree in Finance, Economics, Mathematics or STEM field.
• Excellent analytical skills and attention to detail required.
• Strong communication with internal/external stakeholders required.

Responsibilities

• Support Mortgage Loan Trading and Banking trade analysis across acquisitions, sales, securitizations and back-testing.
• Create analytics, schedules for governing documents, and loan level data.
• Prepare monthly P&L, returns, cash flows and collateral performance reports.

Skills

Analytical skills

Communication

Advanced Excel

CAS

Excel VBA

SQL

Tableau

Fast-paced

Education

Finance/Economics/Mathematics or STEM degree

Tools

SQL

Tableau

Job description

Operating at the center of global financial markets, our FICC and Equities professionals serve institutional clients including Asset Managers, Hedge Funds, Banks and Brokerages, Pensions, Endowments and Foundations, Corporations, and Governments.

We seek to deliver to our clients leading market insight, risk management and execution, helping them to raise money, invest, and transfer risk across financial asset classes.

The Loan Management team is a business unit within the Global Market's division, primarily supporting the Mortgage Loan Trading and Structured Finance desks. The team is a multi-faceted diligence and asset management platform specializing in whole loan acquisition, sales, securitizations, and financing opportunities. The Loan Management team has product expertise across mortgages, consumer loans, real estate and warehouse financing.

Loan Management is seeking an Analyst to support Global Market's Mortgage Loan Trading and Banking trades. The successful candidate will be responsible for the analysis of performing and non-performing loan acquisitions, sales, securitizations, P&L reporting, and back-testing.

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


• Work 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


• Provide thoughtful monthly quantitative analysis on the key drivers of portfolio performance and recommend actionable strategies to asset managers and the trading desk


• 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 advance 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