Job Title: Structured Finance Analyst (Reconciliation and Reporting)
Location: New York, NY (Hybrid)
Duration: 12+ Months (Possible extension/Conversion)
Responsibilities:
- Assist with setup and ongoing support for bank loan, warehouse, and repo facility reconciliation and position reporting
- Monthly and quarterly ABS and CLO processing and related automation
- Cash and loan transaction account reconciliation and related automation
- Daily reconciliation report and position statement review and related automation
- Assist with documentation of requirements, use cases, and related testing data
- Follow detailed reconciliation and processing scripts to:
- Properly bifurcate cash and transaction activity and related breaks for each facility
- Assist with the 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
EEO:
“Mindlance is an Equal Opportunity Employer and does not discriminate in employment on the basis of – Minority/Gender/Disability/Religion/LGBTQI/Age/Veterans.”
