WSN is looking to bring on a Business Analyst (Non-Tech) for a consulting opportunity with our client, an investment bank, based in NYC.

• 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