Data Analyst
Pharmatek
contract
Posted on:
Location Type: Hybrid
Location: Jersey City • New Jersey • United States
Visit company websiteExplore more
About the role
- 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
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
data analysisETLreport generationSQLloan level data analysismortgage pledge extract monitoringdata quality assurancead-hoc reportingcollateral analysisdata comparison
Soft Skills
collaborativeproactivecommunication