Institutional Reporting Specialist

Morgan Stanley; Purchase (NY); On-site; USD 110,000 - 170,000; Full time

Job summary

Morgan Stanley is seeking an entrepreneurial professional to join the Institutional Reporting Team within IIS. You will maintain accurate data in performance reporting systems, automate processes, and deliver timely reports for institutional and ultra-high net worth clients.

Responsibilities include reconciling investments, processing large datasets, and collaborating with client coverage teams, advisory professionals, and custodians while continuously improving reporting accuracy and efficiency.

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 investment reporting platforms a plus (Addepar, Investment Metrics).
• Experience with complex datasets and relational databases; SQL/Python/Excel VBA a plus.

Responsibilities

• Compile and generate monthly and quarterly performance reports, reconcile discrepancies, and ensure data accuracy through self-audit.
• Manually capture and reconcile alternative investment transactions and valuations into designated systems and spreadsheets.
• Develop programs to automate processes and handle large data sets for reporting.
• Process, review and resolve exception items to ensure accurate reporting of client investments.
• Review investment activity, performance, and cash flows daily to ensure data quality across accounts and entities.
• Plan and prioritize assignments to meet high standards of timeliness and accuracy.
• Engage with cross-functional teams and stakeholders to provide timely feedback and solutions.
• Utilize group systems, platforms and processes to improve reporting efficiency.
• Identify gaps and propose training/development opportunities for team members.
• Participate in training programs to stay current on policies, procedures and risk.

Skills

Portfolio accounting

Performance attribution

Data analysis

Communication skills

Project management

Leadership abilities

Independent work

Technical proficiency

Education

Undergraduate degree in accounting, finance, economics, data, or related field

Tools

Addepar

Investment Metrics

Dataiku

SQL

Python

Excel VBA

Job description

Morgan Stanley is a leading global financial services firm providing a wide range of investment banking, securities, investment management and wealth management services. Morgan Stanley Wealth Management (MSWM) has over $2 trillion under management and is one of the world's largest networks of Financial Advisors.

Institutional Infrastructure Solutions (IIS), a business unit within Corporate & Institutional Solutions, is an integrated client service solution for institutional and family office clients. IIS supports clients in partnership with Financial Advisors, Morgan Stanley Family Office ("MSFO"), Outsourced Chief Investment Office ("OCIO"), Morgan Stanley Fund Services, Graystone Consulting and Wealth Management Operations. IIS is responsible for all client service execution processes including Client Onboarding & Maintenance, Investment Execution, Asset Aggregation, Accounting, Reporting & Analytics and Billing.

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. The candidate will collaborate and partner closely with client coverage teams, investment officers, and financial advisors to deliver timely and accurate performance reports.

Primary 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
• Understand and effectively utilize the group's systems, infrastructure, platforms and business processes
• 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

Knowledge and Skills Required:

• 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
• Must be 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
• Ability 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

WHAT YOU CAN E