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.
  

RequirementsMortgage, Collateral,

Loan(Finance, banking) experience must.
Location: Tri-state

area(Must be in NYC area, no relocation)

• 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.