Investor Reporting Analyst III

spsservicing; Utah; On-site; USD 60,000 - 80,000; Full time

Job summary

spsservicing in Utah seeks an Investor Reporting Analyst to aggregate loan activity, reconcile custodial accounts, and remit funds to investors accurately and on time. You will leverage Excel, SQL, and Black Knight/LPS, ensure thorough issue resolution, and support cross-functional teams.

Ideal candidates have a bachelor's degree with 3–5 years in investor reporting or accounting, strong data literacy, and excellent communication skills.

Qualifications

• Bachelor's degree or equivalent experience.
• Strong written and oral communication skills.
• Proficiency in Microsoft Excel.

Responsibilities

• Aggregate loan activity into summary remittance reports.
• Reconcile custodial bank accounts with loan activity.
• Remit funds to investors accurately and timely.
• Research and resolve questions thoroughly and promptly.
• Utilize Excel, SQL and Black Knight/LPS systems.
• Analyze deal points and communicate to stakeholders.
• Own ancillary reporting and processes.
• Train and mentor other Investor Reporting Analysts.

Skills

Excel

SQL

Python

VBA

Data analysis

Communication

Education

Bachelor's or equivalent

Tools

Black Knight/LPS

Job description

Principal Duties:

• Aggregate loan activity from various sources into summary remittance reports
• Reconcile custodial bank accounts to loan activities accurately and timely
• Remit funds due to investors accurately and timely
• Research and resolve questions timely, accurately, and thoroughly
• Understand and utilize systems: Excel, SQL, and Black Knight/LPS
• Ensure all deal points are completely analyzed and communicated to the appropriate parties
• Owns ancillary reporting and/or processes
• Trains and mentors other Investor Reporting Analysts

Minimum Qualifications:

• Bachelor's or equivalent experience
• Strong written and oral communication skills
• Proficient in Microsoft Excel
• Analytical skills for effective data interpretation and decision-making

Preferred Qualifications:

• 3-5 years of experience in Investor Reporting or Accounting related functions
• Working knowledge of Investor Reporting concepts and/or requirements
• Demonstrated ability to organize and manage tasks simultaneously
• High levels of data literacy, including abilities in SQL, VBA, Python, or equivalent technical skills