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.