Data Analyst

Posted: 2 weeks ago

Job Description / Responsibility:
5500 Process (end of June deadline)
" Identify current IC and RPCS client population for required mailing (3300 clients)
" Obtain data for fee received from firm's compensation system
" Create master list for total annual fees received
" Create the disclosure form for each client:
- Coordinate with Billing department to identify all fees received
- Verify status of clients where no fees received
- Verify noncash compensation from branch supervisors
- Perform calculations and compile in mail merge format
" Coordinate with firm Mailing Department
- Provide account numbers to obtain address on CAI
- Provide documents for mail merge
- Review final mail merge for accuracy
- Obtain confirmation of mailing
" Respond to questions/resolve discrepancies

ADV Mailing (end of April deadline)
" Identify current IC and RPCS client population for required mailing (3300 clients)
" Create report from firm's CAI system for client contact information
" Create master list in mail merge format
" Review for consolidated mailings
" Creation and review of mail merge letters
" Coordinate with firm Mailing Department
- Provide account numbers to obtain address on CAI
- Provide documents for mail merge
- Review final mail merge for accuracy
- Obtain confirmation of mailing


Step-Out Trade Mailing (beginning of April)
" Identify current IC held long client population for required mailing (300 clients)
" Reach out to IC SMA managers for step-out trade detail
" Create master tracker with step-out data for SMA advisory and IC managers
" Coordinate with firm Mailing Department
- Provide account numbers to obtain address on CAI
- Provide documents for mail merge
- Review final mail merge for accuracy
- Obtain confirmation of mailing