Analysis Skills, Communication Skills, Data Analysis, Data Quality, Database Extract Transform and Load (ETL), Marketing/Sales Collateral, Microsoft Access Database, Microsoft Excel, Mortgage Lending, Risk Management, SQL (Structured Query Language), Team Player
Data Analyst(Collateral Analysis)<\/span><\/b><\/span><\/span><\/span><\/span><\/b><\/span>
Location: Jersey City, NJ<\/b>
Duration: Contract<\/b>
Schedule: Monday – Friday 8:30AM - 5:00PM<\/b>
Hybrid Schedule: (3) Days in Office (Tuesday -Thursday) &
(2) Days Remote (Monday & Friday)<\/b>
Dress: Business Casual<\/b>
<\/span>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.<\/span><\/span><\/span>
<\/span><\/span><\/p>
JOB DESCRIPTION:<\/span><\/span><\/span><\/b>
<\/span><\/span><\/p>
Collateral Analysis Temp<\/span><\/span><\/span><\/u><\/b>
<\/span><\/span><\/p>
Job Responsibilities (include but not limited to):<\/span><\/span><\/span><\/b>
<\/span><\/span><\/p>- 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.<\/span><\/span>
<\/span><\/li> - Create
member reporting for accuracy and completeness.<\/span><\/span>
<\/span><\/li> - Perform
comparisons of generated ETL reports against the previous month’s member
submission and test system. <\/span><\/span>
<\/span><\/li> - 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.<\/span><\/span>
<\/span>
<\/li><\/ul><\/div><\/span>
Requirements<\/h3>Mortgage, Collateral,
Loan(Finance, banking) experience must.<\/span><\/span><\/span>
<\/span>Location: Tri -state
area(Must be in NYC area, no relocation) <\/span><\/span><\/span>
<\/span>
<\/span><\/div>
- Ability to
analyze loan level data for residential, multifamily and CRE mortgages.<\/span><\/span>
<\/span><\/li> - Ability to
monitor mortgage pledge extract for eligibility and synthesize large
amounts of loan level data.<\/span><\/span>
<\/span><\/li> - Ability to
refresh member reports, canned and ad -hoc.<\/span><\/span>
<\/span><\/li> - Expert in
the use of tools such as MS Excel, MS Access and any ETL tools (<\/span>Carlisle
Group’s Collateral Analysis System “CAS” preferred<\/span><\/b>) used to analyze
loan level mortgage data. Knowledge of SQL language a major plus.<\/span><\/span>
<\/span><\/li> - Ability to
communicate data changes both verbally and written. <\/span><\/span>
<\/span><\/li> - In
addition to the above Analyst must demonstrate Collaborative and Proactive
skills.<\/span><\/span>
<\/span><\/li><\/ul>
<\/div><\/span>