Entry Level Financial Analyst

Aston Carter•Columbia, MD

1d•$23 - $23•Onsite

About The Position

The Securities Analyst II role sits within the Securities Administration Services group and focuses on processing complex transactions and reconciliations related to loan and security payments. You will perform detailed data entry, accounting, and analysis of pooled loan data from multiple mortgage servicers, ensuring accuracy and resolving variances. This position requires regular use of multiple database systems, including Microsoft Excel, and involves researching and interpreting controlling legal documents when issues arise with collateral or bond payments. You will work closely with Collateral, Securities, Default, and Trust Administration teams in a highly collaborative, deadline-driven environment that offers strong growth opportunities and flexible work arrangements.

Requirements

Demonstrated proficiency with Microsoft Excel, including formulas, pivot tables, VLOOKUP, and other advanced functions.
Ability to perform detailed data entry, accounting, and analysis of pooled loan data with strong accuracy and organization.
Strong analytical skills with the ability to identify, investigate, and resolve data variances and compliance issues.
Working knowledge or ability to develop expertise in Collateral, Securities, Default, and Trust Administration.
Capability to research and interpret controlling legal documents related to collateral and bond payments.
Business analysis skills with a focus on finance, data, and quantitative evaluation.
Bachelor’s degree in Math, Economics, Finance, Accounting, Statistics, Business, or a related field.
Strong math skills and comfort working with large data sets and complex financial information.
Ability to work effectively in a deadline-driven environment and manage overtime when required.
Clear written and verbal communication skills to interact with servicers, investors, and internal stakeholders.
Attention to detail and a high level of accuracy in processing transactions and reconciliations.

Nice To Haves

1+ year of experience in financial services, which may include internship experience.
Experience using multiple database systems to manage and analyze financial or loan data.
Prior exposure to pooled loans, mortgage servicing, or securities administration.
Experience participating in system enhancement initiatives, including attending user groups and performing testing.
Ability to identify process improvement opportunities and contribute to automated solutions.
Experience reviewing the work of junior staff or providing informal training and guidance.
Strong teamwork skills and ability to collaborate in a task-based, team-oriented environment.
Interest in career growth within a financial services or securities administration organization.
Background in business analysis, finance, or data analysis, including handling complex datasets.

Responsibilities

Process complex transactions and reconciliations related to loan and security payments with a high level of accuracy and attention to detail.
Provide remittance and correction information to mortgage servicers to ensure proper posting and reporting of payments.
Monitor and analyze pooled loans to identify non-compliance and communicate relevant findings to investors.
Evaluate servicer performance to ensure adherence to stated agreements and servicing standards.
Use multiple database systems and Microsoft Excel to perform data entry, accounting, and variance analysis on pooled loan data from various mortgage servicers.
Identify, research, and resolve discrepancies in loan and security data, ensuring that all variances are properly documented and accounted for.
Research and interpret controlling legal documents related to collateral and bond payments, and apply findings to resolve problems.
Maintain a strong working knowledge of Collateral, Securities, Default, and Trust Administration processes and requirements.
Participate in system enhancements by attending user groups, performing testing, and providing feedback on functionality and process improvements.
Identify and communicate processing exceptions that may impact similar series across individual portfolios, ensuring consistent handling and resolution.
Train junior level staff as needed and review their processing and reconciliations to ensure quality and compliance.
Propose recommendations and implement automated solutions on an ongoing basis to improve efficiency and accuracy.
Collaborate closely with team members in a task-based, team-oriented environment to meet monthly and periodic analysis deadlines.
Manage workload effectively in a deadline-driven environment, including working overtime as needed to complete analyses at specific points during the month.