Loan Reporting Analyst

Job Title: Loan Reporting Analyst Duration: 12 Months + (High Possibilities of Extension/Conversion) Location: New York City, NY (Hybrid, 3 days onsite) • Assist with setup and on-going support for bank loan, warehouse and repo facility reconciliation and position reporting o Monthly and quarterly ABS and CLO processing and related automation o Cash and loan transaction account reconciliation and related automation o Daily reconciliation report and position statement review and related automation o Assist with documentation of requirements, use cases, and related testing data o Follow detailed reconciliation and processing scripts to: • Properly bifurcate cash and transaction activity and related breaks for each facility • Assist with preparation of daily aggregated facility reporting • Test model and data for completeness and accuracy • Create reconciliation and validation tools for structured finance transactions utilizing python Qualifications: • Some experience in the ABS/CLO/CMBS/RMBS industry is preferred • Proficiency in a programming language such as python or VBA is desirable but not required • General knowledge of databases, software and overall process design is desirable • BS degree in finance or a relevant quantitative field such as mathematics, physics, computer science, or engineering is highly desirable • Proficiency with cash-flow modeling of securitized products is preferred • Proficiency with bank loan or repo facility cash and account reconciliation is strongly preferred • Must be highly competent with Excel • Proficiency with Access, SQL, and/or ETL experience is a plus • Must have strong problem-solving skills, excellent work ethic, and good communication skills • Must be motivated and able to work both independently and as part of a team "Mindlance is an Equal Opportunity Employer and does not discriminate in employment on the basis of - Minority/Gender/Disability/Religion/LGBTQI/Age/Veterans."

Created: 2024-11-05