Software Guidance & Assistance, Inc., (SGA), is searching for a Data Analyst for a CONTRACT assignment with one of our premier Financial clients in New York, NY.
Responsibilities
New business setup and BAU processing support
Monthly and quarterly ABS and CLO processing and related automation
Distribution cash and account reconciliation and related automation
Monthly report and certificateholder statement review and related automation
Assist in the implementation of the migration of the ASAP 1.0 data and models to the new ASAP 2.0 environment
Assist with documentation of requirements, use cases, and related testing data
Follow Detailed Migration And Testing Scripts To
Migrate ABS and CLO deals
Assist with migration of RMBS deals
Test model and data for completeness and accuracy
Reconcile newly migrated data with historical data
Support the ongoing monthly processing and reporting requirements of migrated deals
Create reconciliation and validation tools for structured finance transactions utilizing python
Required Skills
Must be proficient in a programming language
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
python or VBA is desirable but not required
General knowledge of databases, software and overall process design is desirable
Proficiency with cash-flow modeling and reverse engineeri ng of securitized products is 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 .
EEO Employer: Race, Color, Sex, Sexual Orientation, Gender Identity, Religion, National Origin, Disability, Veteran Status, Age, Marital Status, Pregnancy, Genetic Information, or Other Legally Protected Status.
