Lead, Collateral Modeling & Analytics

Federal Home Loan Bank of San Francisco; United States; On-site; USD 125,000 - 155,000; Full time

Job summary

The Federal Home Loan Bank of San Francisco is seeking an Associate Director for Collateral Modeling and Analytics to lead loan valuation, data analytics, and reporting across the mortgage collateral pricing process. You will work with internal risk teams, members, and vendors to improve valuation accuracy and risk insights.

Responsibilities include managing quarterly collateral valuation, integrating third‑party pricing, conducting benchmark studies, supporting model governance, and preparing

Qualifications

• Three to five years progressively responsible experience in mortgage portfolio analysis and risk management.
• Experience in whole-loan and securities valuation and in prepayment/default modeling.
• Strong data quality focus and ability to manage large datasets across multiple data stores.

Responsibilities

• Manage the Bank’s quarterly collateral valuation and risk analysis processes for residential and commercial portfolios, including data prep and identifying valuation trends.
• Integrate valuations from third-party pricing vendors into the mortgage loan valuation process.
• Analyze vendor pricing outputs and assess drivers of valuation changes (rates, spreads, prepayments, collateral characteristics, market conditions).
• Perform data validation and quality checks on loan-level datasets and pricing outputs; reconcile results across cycles and investigate discrepancies.
• Conduct benchmark studies and tolerance testing for third-party models and internal valuations to ensure consistency with current market practice.
• Summarize complex analytical findings into concise executive-level presentations for Senior Management and Credit Committee.

Skills

SQL

Excel

Power BI

Data analytics

Mortgage market knowledge

Education

Bachelor's degree in Finance, Economics, Statistics, Mathematics, Data Analytics, or related quantitative discipline

MBA or Master of Finance or CFA designation preferred

Tools

PolyPaths

AFT

Bloomberg analytics

CapIQ

Job description

The Federal Home Loan Bank of San Francisco is seeking an Associate Director for Collateral Modeling and Analytics to lead loan valuation, data analytics, and reporting across the mortgage collateral pricing process. You will work with internal risk teams, members, and vendors to improve valuation accuracy and risk insights.

Responsibilities include managing quarterly collateral valuation, integrating third‑party pricing, conducting benchmark studies, supporting model governance, and preparing