RAPS CONSULTING INC
Data Analyst (Banking/Financial Domain)
RAPS CONSULTING INC, New York, New York, us, 10261
Role- Data AnalystLocation: NYC- HybridDuration: 12+ MonthsJob Description:
Required Skills
Data visualizationEnterprises Data warehouseData extractingData modelingSetting up security reference masterData lineageData migrationDetails:
Must have strong experience most of it in financial industry, if not allMust have worked in Middle OfficeWorked with Cross Functional teams to onboard the Asset servicing clients Data into Data Lake and Billing applicationsOnboarded the middle office client's data (from IBOR, Eagle, Derivatives D360, Swifts counts by client) into Data Lake/Billing ApplicationsDefine the business and functional requirements for Revenue and Billing applicationsReconciling the billing data with source systems and Nexen and billing applicationDocumenting workflows, designing the application, business and functional requirementsSetting up the client specific reference data (custodians, broker/dealers, accounting data, etc.)Setting up and maintaining the Security Reference Master (SRM) data for all the client's securities of interestCaptured trades from client's PMS (CRD, Aladdin, EZ_ and transformed the data into client specific format(s)Monitor the trade upload process, troubleshoot and document the issues
Required Skills
Data visualizationEnterprises Data warehouseData extractingData modelingSetting up security reference masterData lineageData migrationDetails:
Must have strong experience most of it in financial industry, if not allMust have worked in Middle OfficeWorked with Cross Functional teams to onboard the Asset servicing clients Data into Data Lake and Billing applicationsOnboarded the middle office client's data (from IBOR, Eagle, Derivatives D360, Swifts counts by client) into Data Lake/Billing ApplicationsDefine the business and functional requirements for Revenue and Billing applicationsReconciling the billing data with source systems and Nexen and billing applicationDocumenting workflows, designing the application, business and functional requirementsSetting up the client specific reference data (custodians, broker/dealers, accounting data, etc.)Setting up and maintaining the Security Reference Master (SRM) data for all the client's securities of interestCaptured trades from client's PMS (CRD, Aladdin, EZ_ and transformed the data into client specific format(s)Monitor the trade upload process, troubleshoot and document the issues