Business Analyst III
1. Assist team with client conversions
o Maintain and update weekly scorecards for all on-going conversion projects to be shared as a dashboard to SMT.
o Assist with reconciling all Investor data and Investor contact level data imported into FSID against the source data provided by the client/incumbent administrator.
The reconciliations are rules driven and will be done through a series of Pivot tables & V-lookups.
o Assist with managing all incoming Investor documentation
Parse and vault all Investor documentation received into FSID. Tax Forms, Self-certifications, initial subscription documentation must be parsed and vaulted separately.
Responsible to provide gap analysis to assigned coverage teams on all occurrences where initial Investor documentation is missing.
2. Processing of all incoming/outgoing mail
o Daily scanning and vaulting of mail received via post.
3. Assist with system testing / Ad Hoc Projects
o Responsible to assist team with system testing for Investor Services enhancements/developments.
o Responsible to assist team with arranging transactional documentation for all audit requests.
4. Assist with annual electronic K-1 process
o Ensure each onshore investor has a valid tax identification number by liaising with the client and following up with investors for the necessary tax forms in advance of the K-1 distribution date.
o Work with the tax team and the client's tax preparer on downloading the final K-1's from the tax preparer's portal and ensure the client has approved the K-1's for distribution.
o Validate the K-1's through the electronic K-1 distribution tool and investigate any mismatches/missing K-1's (Investor Names, Address, Tax ID)
o FTP the K-1 file to RRD for hardcopy distribution
" Bachelor's degree
" Minimum 2-3 years professional experience
" Strong team and interpersonal skills
" Strong communication (written & oral)
" Advanced Excel skills preferred (pivot tables, V-lookups)
" Strong organizational skills & Multi-Tasking ability