HYBRID in San Francisco, CA
This role requires a strong understanding of financial data, particularly mortgage loans, and the ability to identify discrepancies such as receiving an adjustable rate when a fixed rate is expected. The ideal candidate will be proficient in reading and interpreting bank notes, extracting relevant information, and accurately compiling that data into organized Excel spreadsheets for presentation to management. This includes the ability to recognize anomalies and inconsistencies within financial documents, ensuring data integrity and facilitating informed decision-making.
Candidate must possess comprehensive financial skills including knowledge of agency and non-agency securities, secondary market expertise, and understanding of residential/commercial real estate origination, underwriting, servicing, and mortgage-backed securities pricing. Experience with banking institutions such as CDFIs, Housing Authorities, Regulatory Agencies (Federal Reserve, FHFA, FHLMC,FNMA, OCC, FDIC), Commercial Banks, GSIBs, Banks or Credit Unions is highly valued. The position requires familiarity with eVault systems and electronic note management for handling Pledged eNotes and MERS eRegistry transactions. Strong knowledge of mortgage collateral validation processes, document authentication, and SMART Doc implementation standards is essential.
Technical proficiency should include Excel functions (VLOOKUP, Pivot Tables, IF Functions).
Primary Responsibilities
- Create and maintain customized mortgage collateral update files
- The role involves creating and gathering customer specifications for mortgage collateral update (MCU) files while collaborating with members to review test results.
- This position requires coordinating and writing user acceptance criteria through JIRAs and conducting testing with each customer to validate data integrity.
- The analyst provides technical support and troubleshooting assistance to enable members to process their MCU files, along with ongoing support for members' data files and maintenance of data maps.
- Additionally, the role includes conducting market research and supporting changes to criteria data requirements to ensure compliance with the Bank's collateral risk framework.