Data Analyst Job at consultpharmatek in Jersey City

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. Thisincludes reviewing member submitted loan level pledge files, analyzing theinformation 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. Proactivelywork with other colleagues within Collateral Analysis and the broaderCollateral Risk Management team to ensure data quality submitted andrespond to data related inquiries. Requirements 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 ( CarlisleGroup’s Collateral Analysis System “CAS” preferred ) used to analyzeloan level mortgage data. Knowledge of SQL language a major plus. Ability tocommunicate data changes both verbally and written. Inaddition to the above Analyst must demonstrate Collaborative and Proactiveskills. #J-18808-Ljbffr