Collateral Modeling and Analytics, Assoc. Dir.

Federal Home Loan Bank of San Francisco•San Francisco, CA

13d•$125,000 - $155,000

About The Position

The Collateral Modeling and Analytics team within Collateral Risk Management is responsible for producing analytics to determine member borrowing capacity, managing liquidation valuation of pledged collateral, supporting haircut/margin methodologies, and operating and maintaining the suite of collateral models used by the Bank. The Associate Director, Collateral Modeling and Analytics supports loan valuation, data analytics, and reporting activities across the Bank’s mortgage collateral pricing process, working closely with internal risk teams, members, and third‑party vendors.

Requirements

Bachelor's degree in Finance, Economics, Statistics, Mathematics, Data Analytics, or a related quantitative discipline.
Three to five years progressively responsible experience in mortgage portfolio analysis and risk management, including expertise in whole loan and securities valuation as well as prepayment and default modeling.
Detail-oriented and well-organized, with strong data quality focus and sound judgment in applying procedures.
Excellent interpersonal skills to work in a team environment and to influence and interface with a broad range of stakeholders at all levels, both internal and external.
Proficiency with mortgage market–related software tools such as PolyPaths, AFT, Bloomberg analytics, and CapIQ.
Uses data to aid decision making by possessing strong analytical and problem-solving skills while being able to tell the story behind the numbers and analysis.
Ability to manage large datasets across multiple data stores and technology platforms.
Strong SQL skills for querying, transforming, and validating large datasets, with proficiency in Microsoft Excel and Power BI.
Proficiency with mortgage market related tools such as PolyPaths and AFT.
Minimum of three to five years of progressively responsible experience in mortgage portfolio analysis and risk management, including expertise in whole‑loan and securities valuation.
Demonstrated ability to manage large datasets across multiple data stores and technology platforms.
Strong proficiency with Microsoft Excel, Power BI, and SQL.

Nice To Haves

Advanced degree (MBA or Master of Finance) or CFA designation preferred.

Responsibilities

Manage the Bank’s quarterly collateral valuation and risk analysis processes for residential and commercial portfolios, including preparing loan data files, supporting vendor submissions, and identifying key valuation trends.
Integrate valuations from third-party pricing vendors into the mortgage loan valuation process. Analyze vendor pricing outputs and independently assess drivers of valuation changes, including interest rates, credit spreads, prepayment assumptions, collateral characteristics, and market conditions.
Perform data validation and quality checks on loan‑level datasets and pricing outputs, including reconciling results across reporting cycles and investigating discrepancies.
Perform benchmark studies and tolerance testing for third party behavioral models, vendor price models, internal model generated valuations, and haircut (margin) assignments to assure consistency with current market practice.
Summarize complex analytical findings and market developments into concise executive-level presentations and reports for Senior Management and/or Credit Committee.
Provide national and regional economic and real estate market risk research in a concise executive level format with sufficient analytical support for conclusions and/or recommendations to the Bank’s risk and credit committees, including support for the Bank’s CECL and collateral monitoring process.
Provide analytical support for collateral models, including valuations and margin methodologies. Support model governance activities, including model validation reviews, documentation updates, testing, and remediation of findings and recommendations.
Execute projects independently that enhance and/or streamline department reporting capabilities.
Assists in preparing monthly reports for Senior Management and the Board of Directors which portray the safety, soundness and mix of associated risks of securities and mortgages pledged to the Bank by its Member institutions.
Assist Senior Analysts with monthly and quarterly valuation and risk analysis processes for the Bank’s Pledged Collateral and MPF Whole Loan portfolios.
Support mortgage collateral systems and data processes, including maintaining data mappings and updating fields within the Mortgage Collateral Management system.
Monitor collateral data submissions and assist members with mortgage data file errors, corrections, and data mapping requirements.
Provide support for the member portal and related system inquiries.