Expired
Company:
SGA Inc.
Location: New York County
Closing Date: 29/11/2024
Hours: Full Time
Type: Permanent
Job Requirements / Description
Software Guidance & Assistance, Inc., (SGA), is searching for a Data Analyst - Structured Finance for a CONTRACT assignment with one of our premier Financial Services clients in New York, NY.
Responsibilities:
Assist with setup and on-going 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:
Properly 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.
Required Skills:
Proficiency in a programming language such as python or VBA is desirable but not required.
Must be highly competent with Excel.
Must have strong problem-solving skills, excellent work ethic, and good communication skills.
Must be motivated and able to work both independently and as part of a team.
Preferred Skills:
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.
SGA is a technology and resource solutions provider driven to stand out. We are a women-owned business. Our mission: to solve big IT problems with a more personal, boutique approach. Each year, we match consultants like you to more than 1,000 engagements. When we say let's work better together, we mean it. You'll join a diverse team built on these core values: customer service, employee development, and quality and integrity in everything we do. Be yourself, love what you do and find your passion at work. Please find us at .
SGA is an Equal Opportunity Employer and does not discriminate on the basis of Race, Color, Sex, Sexual Orientation, Gender Identity, Religion, National Origin, Disability, Veteran Status, Age, Marital Status, Pregnancy, Genetic Information, or Other Legally Protected Status. We are committed to providing access, equal opportunity, and reasonable accommodation for individuals with disabilities in employment, and our services, programs, and activities. Please visit our company to request an accommodation or assistance regarding our policy.
Responsibilities:
Assist with setup and on-going 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:
Properly 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.
Required Skills:
Proficiency in a programming language such as python or VBA is desirable but not required.
Must be highly competent with Excel.
Must have strong problem-solving skills, excellent work ethic, and good communication skills.
Must be motivated and able to work both independently and as part of a team.
Preferred Skills:
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.
SGA is a technology and resource solutions provider driven to stand out. We are a women-owned business. Our mission: to solve big IT problems with a more personal, boutique approach. Each year, we match consultants like you to more than 1,000 engagements. When we say let's work better together, we mean it. You'll join a diverse team built on these core values: customer service, employee development, and quality and integrity in everything we do. Be yourself, love what you do and find your passion at work. Please find us at .
SGA is an Equal Opportunity Employer and does not discriminate on the basis of Race, Color, Sex, Sexual Orientation, Gender Identity, Religion, National Origin, Disability, Veteran Status, Age, Marital Status, Pregnancy, Genetic Information, or Other Legally Protected Status. We are committed to providing access, equal opportunity, and reasonable accommodation for individuals with disabilities in employment, and our services, programs, and activities. Please visit our company to request an accommodation or assistance regarding our policy.
Useful Links