Collateral Operations Analyst
San Francisco, CA 3 days a week onsite
Contract -3-6 Months
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.
Department Functions
Provide support to all Collateral Operations job functions including but not limited to:
• Assist with morning and evening reconciliation and balancing functions.
• Process securities pledge and release transactions, update security codes, ratings, pricing factors, and other data.
• Perform daily review of collateral positions, including generating and analyzing mortgage and securities borrowing exception reports.
• Utilize SmartREGISTRY for eNote registration, eDelivery transfers, and eNote status management and MERs system.
• Monitor and UCC Filings and reconciliations with vendor application.
• Ability to contribute to workflow improvements and willing to gain an understanding of the legacy systems and processes.
Skills/Knowledge:
This role requires a strong understanding of financial data, particularly notes, 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 Salesforce, SharePoint, Oracle, Power BI, Tableau, SQL, SAS, advanced Microsoft applications, Excel functions (VLOOKUP, Pivot Tables, IF Functions), Crystal Reports, PowerPoint, and Word.
Criteria:
• 2 to 3 years minimum experience with a financial institution
• Intermediate to advance Microsoft Excel skills