Technical/Business Analyst/Engineer
Core
Develop, validate, and maintain business/functional requirements for the Commercial Mortgage Data Warehouse model, translating business needs into SQL statements and data quality improvements.
Role type
Senior IC Technical/Business Analyst (Data Warehouse)
Builds
Commercial Mortgage Data Warehouse model and PLM platform data solutions
Domain
Commercial Real Estate Finance / Mortgage Servicing
Required skills
Advanced SQL, Alteryx, Data Anomaly Detection, Data Quality Analysis, Gap Analysis, Test Planning, API/Integration Analysis, System Configuration, Agile Methodologies
Preferred skills
Python (Data Analysis/Automation), REST/JSON, Financial/Investment Industry Knowledge, Commercial Real Estate Finance, Loan Management Systems, CCIM/MAI/CPA/LOMA, Insurance/Reinsurance
Technologies
SQL, Alteryx, Excel, Python, REST, JSON, APIs, PLM Platform
Responsibilities
Develop, validate, document, and maintain business and functional requirements; Translate business requirements into SQL statements; Analyze data to triage data-model issues and examine source-system data; Partner with data architects and business sponsors using Agile methods; Review application functionality and conduct gap analyses; Create test plans and execute scripts for application and data-model changes; Investigate and resolve inbound and outbound data-feed issues; Support the core commercial mortgage servicing and accounting platform.