SECURITIES ADM SVCS ANALYST 2

Aston Carter•Saint Paul, MN

5d•$23 - $23•Hybrid

About The Position

The role involves extracting bond and loan calculations from extensive legal documents and uploading them into a database similar to Access. You will manage large loan portfolios, some exceeding $1 billion, and handle transactions, daily cash reconciliation, and monthly and quarterly cash reporting for loan holders and investors. Attention to detail is crucial as you will ensure data accuracy by pulling client data from documents. Strong proficiency in Excel is essential, while basic knowledge of Access is advantageous.

Requirements

1+ year of experience in financial services, accounting, or analytical analysis, or a BS/BA degree or higher in Math, Finance, Business, Economics, or a related discipline.
Proficiency in Excel, including pivot tables, VLOOKUPs, sorting, formulas, and functions.
Ability to score 90% or higher on an Excel test within 30 minutes.
Technical aptitude and readiness to learn.

Nice To Haves

Experience in an analytical role or at a bank is a bonus.
Preferred candidates have completed extracurricular activities or internships.
Bachelor's degree in Business, Mathematics, Computer Science, Finance, or Statistics.

Responsibilities

Extract bond and loan calculations from large legal documents.
Upload extracted data into an Access-like database.
Manage large loan portfolios, with values ranging from $300 million to over $1 billion.
Handle transactions involving buying and selling portions of loans.
Balance and reconcile daily cash flows.
Report on monthly and quarterly cash positions for loan holders and investors.
Ensure accuracy of client data extracted from documents.