Collateral Operations Analyst (Mortgage banking, SQL, Power BI/Local Candidates only)

Need someone who can Analyse residential and commercial real estate servicing data and can build databases/reports and query the data to analyze it for trends and or problems. They have to be able to communicate with the members and solve their data issues.

This role requires a candidate with a blend of mortgage banking knowledge, collateral operations expertise, and data analysis skills, particularly in SQL and Power BI.

Here's a summarized version of the job details:

Collateral Operations Analyst

Location: San Francisco, CA (Hybrid - 3 days onsite)

Contract: 4 to 6 months (possible extension)

Key Responsibilities:

• Analyze residential & commercial real estate servicing data
• Build databases/reports and query data for trends/issues
• Assist customers/vendors with mortgage collateral update (MCU) file queries & problem resolution
• Support programming of mortgage collateral updates in MCU system
• Perform UAT testing for data integrity and system acceptance
• Process securities pledge and release transactions
• Perform vault custody duties & collateral maintenance
• Support reconciliation & balancing of collateral holdings
• Query and access data for compliance with policies and record retention

Must-Have Skills & Experience:

• Bachelor's in business, Finance, or Accounting (preferred)
• Mortgage banking work experience (preferred)
• Data analysis skills: SQL, Power BI
• Exposure to loan documentation, servicing, UCC-1 filings, secondary market
• Experience with securities processing
• Strong communication skills to assist customers with data issues
• Experience with JIRA for tracking & project management