Database Reporting Specialist Jobs (NOW HIRING)

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