About the role

  • Contract Data Analyst focusing on collateral analysis for a migration project at Pharmatek Consulting. Responsible for loan data analysis, reporting accuracy, and cross-team collaboration.

Responsibilities

  • 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

  • Mortgage, 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.
  • Analyst must demonstrate Collaborative and Proactive skills.

Benefits

  • Hybrid Schedule: (3) Days in Office (Tuesday-Thursday) & (2) Days Remote (Monday & Friday)
  • Dress: Business Casual

Job title

Data Analyst

Job type

Experience level

Mid levelSenior

Salary

Not specified

Degree requirement

No Education Requirement

Tech skills

Location requirements

Report this job

See something inaccurate? Let us know and we'll update the listing.

Report job