Junior Data Analyst - CMBS
Core
Gather, extract, transform, and analyze complex financial data (CMBS & CRE CLOs) from legal documents and various sources to deliver insights via website or feed.
Role type
Junior Data Analyst
Builds
Data insights and processed data feeds for financial market customers
Domain
Financial Services / Securitization / CMBS
Required skills
Data extraction, data transformation, quality assurance, legal document analysis, SQL, VBA, Power BI, Microsoft Office Suite
Preferred skills
Financial or accounting experience, process automation, cross-functional teamwork
Responsibilities
Scrutinize legal documents to identify relevant CMBS/CRE CLO information, analyze complex product data, map monthly updates to system settings, perform quality assurance checks, launch and monitor data processes, set up extraction rules, review report integrity, answer client queries, contact external companies for information, update data in revised reports, monitor system health, suggest process improvements, contribute to ad-hoc projects
Seniority
Junior, hands-on IC