Gathers, reconciles, and analyzes data required to prepare and distribute Monthly Servicer Report (MSR), securitization loan tapes, servicer certificates and statements to noteholders, warehouse reports, compliance certificates, and other reports to all related parties.
Produces supplemental reports based on MSR data and distributes to internal teams: accounting deliverables, historical ABS views, etc.
Serves as a liaison to the accounting department to reconcile loan roll transactions and related GLs on financial statements. Assists audits requests, investigates reconciliation and roll errors.
Creates simple templates for new or ongoing reporting needs and entry level SQL queries.

Requirements

Bachelor’s degree in Accounting, Finance, Data or Business. (basic understanding of loans/lending process, accruals, charge offs will be discussed in interview)
1-2 years in any combination of the following: accounting, finance, data, loan servicing, other reconciliation roles
Advanced knowledge in excel (excel skills are tested during interview; Vlookup, IF, ‘sumifs’, pivot tables)
Ability to develop querying skills (SQL)
Attention to detail, trends, and ability to investigate abnormalities
Great collaborative and communication skills
Must take initiative, be self motivated and have the drive to learn independently where necessary
Must be a team player and able to work in a fast paced environment

Benefits

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

SQLExcelVlookupIFsumifspivot tablesdata analysisreconciliationreportingfinancial statements

attention to detailcollaborationcommunicationinitiativeself-motivationdrive to learnteam playerability to investigateadaptabilityfast-paced work

Bachelor’s degree in AccountingBachelor’s degree in FinanceBachelor’s degree in DataBachelor’s degree in Business