Entry Level Financial Analyst
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.
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 when issues arise related to collateral or 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.
Essential Skills
- 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.
- Preferred 1+ year of experience in financial services, which may include internship experience.
- 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.
Additional Skills & Qualifications
- 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.
Work Environment
The role operates in a highly team-oriented, task-based environment where collaboration and shared problem-solving are central to success. The work is deadline-driven, with key analyses required at specific points during the month, which may necessitate overtime to ensure all obligations are met. The position follows a hybrid, flexible schedule that combines remote work with on-site presence, including on-site training and monthly large team meetings. You will regularly use Microsoft Excel and multiple database systems while working closely with colleagues in Collateral, Securities, Default, and Trust Administration. The culture emphasizes growth opportunities, professional development, and upward mobility within the organization, while maintaining a supportive and cooperative atmosphere focused on accuracy, compliance, and continuous improvement.
Job Type & Location: This is a Contract to Hire position based out of Columbia, MD.
Pay and Benefits: The pay range for this position is $23.00 - $23.00/hr. Eligibility requirements apply to some benefits and may depend on your job classification and length of employment. Benefits are subject to change and may be subject to specific elections, plan, or program terms. If eligible, the benefits available for this temporary role may include the following: Medical, dental & vision Critical Illness, Accident, and Hospital 401(k) Retirement Plan Pre-tax and Roth post-tax contributions available Life Insurance (Voluntary Life & AD&D for the employee and dependents) Short and long-term disability Health Spending Account (HSA) Transportation benefits Employee Assistance Program Time Off/Leave (PTO, Vacation or Sick Leave)
Workplace Type: This is a fully onsite position in Columbia, MD.
Application Deadline: This position is anticipated to close on Jul 15, 2026.