Job Title: Securities Admin Services Analyst 2Job DescriptionThe candidate will be responsible for extracting bond and loan calculations from large legal documents and uploading them into a database similar to Access. The role involves managing large loan portfolios, some exceeding $1B, and handling transactions, balancing daily cash, and reporting monthly and quarterly cash positions for loan holders and investors. The candidate will also ensure the accuracy of client data extracted from documents. Strong Excel skills are essential, and basic knowledge of Access is a plus.Responsibilities
Extract bond and loan calculations from large legal documents.
Upload calculations into an Access-like database.
Manage large loan portfolios, including those over $1B.
Handle transactions and balance/reconcile daily cash.
Report on monthly and quarterly cash positions for loan holders and investors.
Ensure the accuracy of client data extracted from documents.
Essential Skills
Proficiency in Excel (pivot tables, vlookups, sort, formulas, functions).
1+ year of experience in financial services, accounting, or analytical analysis; or a BS/BA degree in Math, Finance, Business, Economics, or a related discipline.
Additional Skills & Qualifications
Experience in an analytical role or at a bank is a bonus.
BA or BS in Business, Mathematics, Computer Science, Finance, or Statistics.
Technical aptitude and readiness to learn.
Extracurricular activities or internships during schooling are preferred.
Work EnvironmentThe position is a hybrid schedule of 3 days a week in the office (Tue-Thur). The office environment is supportive, with opportunities for growth and team outings.Pay and BenefitsThe pay range for this position is $23.00 - $23.00 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 TypeThis is a hybrid position in Saint Paul,MN.Application DeadlineThis position will be accepting applications until Jan 10, 2025.About Aston Carter: Aston Carter provides world-class corporate talent solutions to thousands of clients across the globe. Specialized in accounting, finance, human resources, talent acquisition, procurement, supply chain and select administrative professions, we extend the capabilities of industry-leading companies. We draw on our deep recruiting expertise and expansive network to meet the evolving needs of our clients and talent community with agility and excellence. With offices across the U.S., Canada, Asia Pacific and Europe, Aston Carter serves many of the Fortune 500. We are proud to be a ClearlyRated Best of Staffing® double diamond winner for both client and talent service.Diversity, Equity & Inclusion At Aston Carter, diversity and inclusion are a bridge towards the equity and success of our people. DE&I are embedded into our culture through:
Hiring diverse talent
Maintaining an inclusive environment through persistent self-reflection
Building a culture of care, engagement, and recognition with clear outcomes
Ensuring growth opportunities for our people
The company is an equal opportunity employer and will consider all applications without regard to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.If you would like to request a reasonable accommodation, such as the modification or adjustment of the job application process or interviewing process due to a disability, please email astoncarteraccommodation@astoncarter.com (%20astoncarteraccommodation@astoncarter.com) for other accommodation options.
Full-time