Institutional Reporting Specialist
Morgan Stanley · New York, NY · 5 mo ago
Analyst$57k–$115k/yrFull-time
About the role
IIS is looking for an entrepreneurial, ambitious and intellectually curious professional to join the Institutional Reporting Team. The candidate plays a vital role maintaining accurate data in performance reporting systems, adhering to all policies and procedures, and contributing to operational process improvements.
Responsibilities
- Compile and generate monthly and quarterly performance reports, reconcile performance discrepancies, and ensure accuracy of data through self-audit
- Manually capture and reconcile alternative investment transactions and valuations into designated systems and spreadsheets
- Responsible for collecting, processing, managing, and analyzing large amount of data and creating programs to automate processes
- Process, review and resolve any exception items to ensure accurate reporting of client investments
- Review investment activity, performance, and cash flows daily to ensure data quality across accounts, entities, and clients
- Plan, organize, and prioritize assignments to consistently meet high standards of reporting timeliness and accuracy
- Develop as a subject matter expert and support cross-functional teams by being accessible, responsive, and delivering timely feedback
- Increase the effectiveness of the Reporting Team by identifying gaps and recommending/providing training and development opportunities for other Team members
- Regularly seek opportunities to use firm resources for peer sharing and collaborating across the team
- Actively engage in available training and education programs to maintain current status on policies, procedures and risk awareness
- Interface and maintain strong relationships with internal and external stakeholders including research, trading, operations, product specialists, third party vendors and custodians
Requirements
- Proficiency in Microsoft Office including Excel, PowerPoint and Access
- Experience and knowledge of wealth management platforms and vehicles, including managed accounts, mutual funds, ETFs, separate accounts, and alternative investments
- Detailed understanding of performance calculations, including measurement and attribution
- Detailed understanding of alternative investments and their corresponding transactions, including private equity, hedge funds, and direct investments
- Detail-oriented, with an ability to multi-task and manage competing priorities
- Strong strategic thinking and problem-solving skills with the ability to clearly define a problem, synthesize data to derive fact-based insights, and provide insightful and actionable recommendations
- Strong organizational and project management skills
- Able to work independently and effectively on a team, with demonstrated leadership abilities
- Technical background with strong analytical and quantitative skills
- Exemplary verbal and written communication skills
Qualifications
- 3+ years portfolio accounting or investment reporting experience serving institutional and ultra-high net worth clients
- Firm understanding of portfolio management concepts including modern portfolio theory, asset allocation, portfolio construction, manager selection, risk management and performance attribution
- Experience with Addepar, Investment Metrics, or other investment reporting platforms a plus
- Experience working with complex datasets and relational databases
- Experience with Dataiku a plus, but not required
- Technical background with strong analytical and quantitative skills; proficient in SQL, Python or Excel VBA a plus
- Undergraduate degree in accounting, finance, economics, data, or related field
- FINRA Series 7 and 66 is a plus, though not required
- Industry designations including CIPM, CFA or significant progress preferred, but not required