Data Analyst - Structured Finance

Software Guidance & Assistance - New York, NY

Full-time - Entry Level

New York, NY

Professional, Scientific, and Technical Services

About the position

The Data Analyst - Structured Finance position at Software Guidance & Assistance, Inc. involves supporting financial services clients in New York, NY, through a contract assignment. The role focuses on bank loan, warehouse, and repo facility reconciliation, as well as automation of related processes. The analyst will be responsible for monthly and quarterly processing of asset-backed securities (ABS) and collateralized loan obligations (CLO), ensuring accuracy and completeness in financial reporting and documentation.

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 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.

Requirements

• Must be highly competent with Excel.
• Proficiency in a programming language, Python or VBA is desirable.

Nice-to-haves

• BS degree in finance or a relevant quantitative field such as mathematics, physics, computer science, or engineering is highly desirable.
• Some experience in the ABS/CLO/CMBS/RMBS industry is preferred.
• General knowledge of databases, software, and overall process design is 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.
• Proficiency with Access, SQL, and/or ETL experience is a plus.