Transaction Analyst - Banking/Finance, ABS/CLO/CMBS/RMBS, Excel, Python/VBA
Job title: Transaction Analyst - Banking/Finance, ABS/CLO/CMBS/RMBS, Excel, Python/VBA in New York City, NY at Denken Solutions
Company: Denken Solutions
Job description: Currently, we are looking for talented resources for one of our listed clients. If interested please reply to me with your updated resume or feel free to reach out to me for more details at (949) 482-4436Hybrid - 3 Days Onsite and 2 days RemoteJob Description:
- Assist with setup and on-going 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
- 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
- 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