Data Analyst

Jersey City, United States | Posted on 01/16/2025

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

JOB DESCRIPTION:

Collateral Analysis Temp

Job Responsibilities (include but not limited to):

• Assist inthe 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.
• Createmember reporting for accuracy and completeness.
• Performcomparisons of generated ETL reports against the previous month’s membersubmission 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.

Mortgage, Collateral,Loan(Finance, banking) experience must.

Location:

Tri-statearea(Must be in NYC area, no relocation)

• Ability toanalyze loan level data for residential, multifamily and CRE mortgages.
• Ability tomonitor mortgage pledge extract for eligibility and synthesize largeamounts of loan level data.
• Ability torefresh member reports, canned and ad-hoc.
• Expert inthe use of tools such as MS Excel, MS Access and any ETL tools (
  Carlisle Group’s Collateral Analysis System “CAS” preferred ) used to analyzeloan 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 Proactiveskills.