Data Analyst

Data Analyst(Collateral Analysis)

Location: Jersey City, NJ
Duration: Contract
Schedule: Monday – Friday 8:30AM - 5:00PM
Hybrid Schedule: (3) Days in Office (Tuesday-Thursday) & (2) Days Remote (Monday & Friday)
Dress: Business Casual

This is a big migration project starting in February 2025. Client is now moving forward and would like to obtain (2) temporary employees for a (5) month project starting in February 2025.

JOB DESCRIPTION:

Collateral Analysis Temp

Job Responsibilities (include but not limited to):

• Assist in the data analysis aspects of the mortgage List Load Process.  This includes reviewing member submitted loan level pledge files, analyzing the information through the Bank’s ETL application, generating reports, comparing results, and uploading to Collateral System.
  
• Create member reporting for accuracy and completeness.
  
• Perform comparisons of generated ETL reports against the previous month’s member submission and test system.  
  
• Proactively work with other colleagues within Collateral Analysis and the broader Collateral Risk Management team to ensure data quality submitted and respond to data related inquiries.
  
  

Requirements

• Ability to analyze loan level data for residential, multifamily and CRE mortgages.
  
• Ability to monitor mortgage pledge extract for eligibility and synthesize large amounts of loan level data.
  
• Ability to refresh member reports, canned and ad-hoc.
  
• Expert in the use of tools such as MS Excel, MS Access and any ETL tools (Carlisle Group’s Collateral Analysis System “CAS” preferred) used to analyze loan level mortgage data.  Knowledge of SQL language a major plus.
  
• Ability to communicate data changes both verbally and written. 
  
• In addition to the above Analyst must demonstrate Collaborative and Proactive skills.