Investor Reporting Analyst III

SPS; West Valley City (UT); On-site; USD 65,000 - 90,000; Full time

Job summary

SPS in Utah is seeking an Investor Reporting Analyst to aggregate loan activity and generate remittance reports, ensuring accuracy and timeliness. You will reconcile custodial bank accounts, remit funds to investors, and research questions thoroughly, using Excel, SQL, and Black Knight/LPS.

The role also involves mentoring peers and owning ancillary reporting to support informed decision-making.

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.

Responsibilities

• Aggregate loan activity 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

Skills

Strong communication

Analytical skills

Data interpretation

Excel proficiency

Education

Bachelor's degree or equivalent experience

Tools

Excel

SQL

Python

VBA

Job description

• 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