Role- Data Analyst Location: NYC- Hybrid Duration: 12+ Months Job Description: Required Skills
- Data visualization
- Enterprises Data warehouse
- Data extracting
- Data modeling
- Setting up security reference master
- Data lineage
- Data migration
Details:
- Must have strong experience most of it in financial industry, if not all
- Must have worked in Middle Office
- Worked with Cross Functional teams to onboard the Asset servicing clients Data into Data Lake and Billing applications
- Onboarded the middle office client's data (from IBOR, Eagle, Derivatives D360, Swifts counts by client) into Data Lake/Billing Applications
- Define the business and functional requirements for Revenue and Billing applications
- Reconciling the billing data with source systems and Nexen and billing application
- Documenting workflows, designing the application, business and functional requirements
- Setting 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 interest
- Captured 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