Analytics & Reporting

Goldman Sachs

Dallas (TX)

On-site

USD 90,000 - 150,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Healthcare & Medical Insurance
Generous vacation policy
Retirement program
On-site health centers

Job summary

Goldman Sachs is seeking a motivated professional to support the Credit & Asset Finance business within the Structured Finance Analytics team. You will analyze securitization transactions across various asset classes and collaborate with clients to prepare data tapes and documentation.

The role requires a bachelor’s degree and 0–3 years of related experience for an analyst, or 3+ years for an associate, with strong Excel, SQL, and VBA skills and knowledge of Python a plus.

Qualifications

  • Bachelor’s degree in finance, economics, math or STEM.
  • 0–3 years for analyst; 3+ years for associate.
  • Big Four collateral analytics experience preferred (RMBS/CMBS).
  • Advanced Excel (VLOOKUP, SUMPRODUCT, INDEX/MATCH).
  • CAS, Excel VBA, SQL; Python a plus.
  • Able to work in a fast-paced, deadline-driven environment.

Responsibilities

  • Act as client advisor and analytics on securitization transactions.
  • Create data tapes from settlement, servicer, TPR, originator data.
  • Perform data validation, portfolio stratification and replines.
  • Provide pool CPR speeds, loss data from rating agency models.
  • Assist in credit memos and PPM materials with outside counsel.

Skills

Finance/Economics background
Mathematics aptitude
STEM education
Analytical mindset

Education

Bachelor’s degree

Tools

CAS
Excel VBA
SQL
Python

Job description

TheStructured Finance Analytics team under Global Banking & Markets division is seeking a motivated professional to support the Credit & Asset Finance business.The team has product expertise across residential assets, consumer loans, real estate, and warehouse financing. The successful candidate will be responsible for the below:

JOB DUTIES:
  • Act as a client advisor and perform analytics on all principal and 3 rd party securitization transactions including but not limited: NPL, RPL, PJ, Agency, Non-QM, SFR, MSR, Investor Occupied, Second Lien, Fix and Flip, iBuyer and Mortgage Insurance Linked Notes. Responsibilities include:
    • Collaborate with client and perform data tape creation from various resources including:
      • Settlement Data
      • Latest Month End Servicer Data
      • TPR due diligence Data
      • Originator Data
    • Perform data validations and create portfolio level stratification and replines.
    • Perform portfolio collateral analysis.
    • Provide pool level CPR speeds, loss severity and credit enhancement from RA (Fitch, KBRA, Moodys, Milan) models.
    • Assist in populate credit memo and PPM materials with outside accountants and lawyers.
  • Perform asset pool selection based on contribution requirements on ABS/CMBS securitization. Work with rating agencies and create historical performance matrices (CPR, CDR, Charge off, Recoveries, Loss) to project future performance.
  • Evaluate daily mark to market on all MSR warehouse lines. Provide recommendations on OAS spreads given the recent dynamic change in rate environments.

Manage cross-functional relationship with the desk, IBD, transaction management, diligence, operation, controller, and technology team to ensure monthly portfolio activities are accurately represented.

MINIMUM EDUCATION REQUIREMENTS/DEGREE AND FIELD:

Bachelor’s degree (U.S. or foreign equivalent)

MINIMUM YEARS EXPERIENCE REQUIRED:
  • 0 to 3 years of Resi loans / Fixed income experience or internship in related fields for analyst.
  • 3+ years of experience for associate.
Preferred Skillsets:
  • Undergraduate in Finance, Economics, Mathematics, or other STEM related degree
  • Big four accounting firm experience in collateral analytics and RA runs on RMBS/CMBS deals strongly preferred.
  • Advanced Excel skills with knowledge in advance functions such as vlookup, sumproducts, index/matches, indirects etc.
  • Technical Skills including CAS, Excel VBA, SQL preferred. Knowledge in Python huge plus.
  • Ability to perform under fast-paced environment with tight time constraints.
Healthcare & Medical Insurance

We offer a wide range of health and welfare programs that vary depending on office location. These generally include medical, dental, short-term disability, long-term disability, life, accidental death, labor accident and business travel accident insurance.

We offer competitive vacation policies based on employee level and office location. We promote time off from work to recharge by providing generous vacation entitlements and a minimum of three weeks expected vacation usage each year.

Financial Wellness & Retirement

We assist employees in saving and planning for retirement, offer financial support for higher education, and provide a number of benefits to help employees prepare for the unexpected. We offer live financial education and content on a variety of topics to address the spectrum of employees’ priorities.

Health Services

We offer a medical advocacy service for employees and family members facing critical health situations, and counseling and referral services through the Employee Assistance Program (EAP). We provide Global Medical, Security and Travel Assistance and a Workplace Ergonomics Program. We also offer state-of-the-art on-site health centers in certain offices.

Fitness

To encourage employees to live a healthy and active lifestyle, some of our offices feature on-site fitness centers. For eligible employees we typically reimburse fees paid for a fitness club membership or activity (up to a pre-approved amount).

Child Care & Family Care

We offer on-site child care centers that provide full-time and emergency back-up care, as well as mother and baby rooms and homework rooms. In every office, we provide advice and counseling services, expectant parent resources and transitional programs for parents returning from parental leave. Adoption, surrogacy, egg donation and egg retrieval stipends are also available.

Benefits at Goldman Sachs

Read more about the full suite of class-leading benefits our firm has to offer.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Asset & Wealth Management, Private Bank, Credit Underwriter, Analyst- Dallas Dallas · · Analyst
Asset & Wealth Management, Private Bank, Credit Underwriter, Analyst- Dallas Dallas · · Analyst

Marcus • Dallas (TX)

On-site
USD 65,000 - 90,000
Loan Management & Due Diligence
Loan Management & Due Diligence

Goldman Sachs • Dallas (TX)

On-site
USD 110,000 - 170,000
Asset & Wealth Management, Private Bank, Credit Underwriter, Analyst- Dallas
Asset & Wealth Management, Private Bank, Credit Underwriter, Analyst- Dallas

Candidate Experience Site - Lateral • Dallas (TX)

On-site
USD 70,000 - 95,000
Global Banking & Markets - Capital Solutions Group - Relationship Lending Group - Dallas
Global Banking & Markets - Capital Solutions Group - Relationship Lending Group - Dallas

Goldman Sachs Group • Dallas (TX)

On-site
USD 90,000 - 130,000
Private Bank Credit Underwriter Analyst – Dallas
Private Bank Credit Underwriter Analyst – Dallas

Goldman Sachs • Dallas (TX)

Hybrid
USD 65,000 - 90,000
Risk, Credit Risk - Global Markets, Analyst, Salt Lake City
Risk, Credit Risk - Global Markets, Analyst, Salt Lake City

Goldman Sachs Group • Salt Lake City (UT)

On-site
USD 70,000 - 110,000
Asset & Wealth Management, Marcus Savings, US Commercial Strategy, Associate, Richardson, TX Richardson · · Associate
Asset & Wealth Management, Marcus Savings, US Commercial Strategy, Associate, Richardson, TX Richardson · · Associate

Goldman Sachs • Richardson (TX)

On-site
USD 120,000 - 160,000
AWM, Private Bank, Underwriter, Analyst- Dallas
AWM, Private Bank, Underwriter, Analyst- Dallas

Goldman Sachs Group • Dallas (TX)

On-site
USD 65,000 - 90,000
Asset & Wealth Management, Digital Operations - Management, Associate - Richardson Richardson · · Associate
Asset & Wealth Management, Digital Operations - Management, Associate - Richardson Richardson · · Associate

Marcus • Richardson (TX)

On-site
USD 120,000 - 180,000
Risk, Credit Risk (Asset Finance), Associate / Vice President, Dallas
Risk, Credit Risk (Asset Finance), Associate / Vice President, Dallas

Goldman Sachs Group • Dallas (TX)

On-site
USD 180,000 - 250,000