Investment & Data Analyst

Job Summary:

The Investment Risk, Report and Data Analyst role will support the firm’s Portfolio Management and Research efforts companywide. The role will focus on leveraging Advisory systems to maximize their capabilities, integrate with other systems and departments to maximize data accuracy, timeliness and transparency by performing recurring risk and performance reporting, workflow documentation and reporting automation across our investment disciplines and systems.

The Analyst will work closely with Money Market Portfolio Managers, SMA Portfolio Managers, Portfolio Management Analysts, the Director of Risk and Middle Office, the CIO, cross-functional partners, and Bloomberg representatives to maintain reliable data, improve workflows, and support informed portfolio management and trading decisions.

Duties/Responsibilities:

Bloomberg Portfolio Management

• Maintain, update, and create Portfolio Management views in Bloomberg for both Money Market Fund and SMA Portfolio Managers.
• Ensure data integrity and accuracy of Bloomberg views to support efficient workflows and real-time trading decision-making.
• Conduct ongoing testing and validation following system updates, guideline changes, or portfolio amendments; work with Compliance, Accounting, and custodial data sources to confirm daily position data accuracy.
• Coordinate with Portfolio Managers to identify workflow gaps and propose solutions through Bloomberg functionality.
• Actively develop Bloomberg expertise with expectation towards becoming the team’s primary internal resource and key point of contact for the Bloomberg relationship, including coordination with Bloomberg Representatives.

Workflow Research, Planning & Implementation

• Partner with the Director of Risk and Middle Office and CIO to research, plan, implement, and test target state workflows across the Portfolio Management function.
• Leverage workflow and target state documentation as the foundation for collaboration with the Product and Information Technology/Development teams to improve daily processes, gain efficiencies, and advance automation of reporting and file extracts used by the team.
• Support workflow improvement initiatives across trading, reporting, and portfolio analytics by coordinating across Money Market Portfolio Managers, SMA Portfolio Managers, Portfolio Management Analysts, Sales, Fund Accounting, SMA Accounting, Information Technology/Development, Product, and Compliance.
• Document workflow processes and contribute to procedure manuals and operational guides for Middle Office and Portfolio Management functions.

Risk & Reporting

• Develop, maintain, and enhance recurring portfolio risk, exposure, and performance reports — including WAM/WAL, liquidity, and issuer and concentration limits for Money Market Fund strategies, and duration, key rate duration, credit quality, and sector concentrations for SMA strategies.  Provide support for compliance-support reporting.
• Review portfolio reporting for accuracy, completeness, and consistency; research data discrepancies and coordinate resolution with Portfolio Management, Accounting, Compliance, IT/Development, Product, and Bloomberg.
• Support regular reporting packages for Portfolio Managers, the CIO, and senior leadership by summarizing key trends, exceptions, and data-quality observations; assist with gathering, organizing, and reviewing documentation in preparation for quarterly controls meetings.
• Support Compliance by researching portfolio data, Bloomberg outputs, and exception details related to pre-trade and post-trade compliance results; escalate potential compliance issues to Compliance for review and determination.
• Build, enhance, and automate reports and analyses using Excel, Bloomberg, Python, and other approved reporting tools; support user acceptance testing (UAT) for reporting and workflow changes.

Cross-Functional Collaboration

• Work collaboratively with Money Market Portfolio Managers, SMA Portfolio Managers, Sales, Fund Accounting, SMA Accounting, Compliance, Information Technology, Product, and Bloomberg Representatives to ensure data accuracy and operational alignment.
• Escalate data discrepancies, system issues, and workflow risks promptly with clear documentation and recommended remediation.
• Support ad hoc analytical and reporting requests from Portfolio Managers and the Director of Risk and Middle Office.

Structured Finance Research

• Support Rates Research Lead by assisting in the development of structured finance holdings analysis tools
• Assist in the development of Issuer template to develop time series analysis of issuance trends and behaviors of invested asset classes.
• Research mortgage, asset backed, and commercial mortgage sectors as directed by CIO and Portfolio Management Staff.
• Design approach and work with Bloomberg representatives to develop BQuant forms and tools to improve accessibility to relevant stats and characteristics across the investment team
• Development of Surveillance process for ABS/DUS holdings
• Provide transaction and trading support for Rates team (REPO)

Required Skills/Abilities:

• Exercises sound, independent judgment within defined procedures and escalates matters requiring senior review in a timely and well-documented manner.
• Maintains a consistently high degree of attention to detail across portfolio data management, reporting, and workflow documentation activities.
• Demonstrates strong interpersonal skills with the ability to build effective working relationships across teams and seniority levels, including with external partners such as Bloomberg Representatives.
• Demonstrates effective collaboration across a multi-disciplinary team environment including Portfolio Management, Trading, Fund Accounting, Product, Compliance, and Information Technology/Dev.
• Ability to manage multiple priorities and adapt quickly to shifting business needs.
• Strong analytical mindset with the ability to think both conceptually and at the operational detail level simultaneously.
• Demonstrates a strong ability to learn quickly, absorb new systems and processes, and apply knowledge independently in a fast-moving environment.
• Strong written and verbal communication skills with the ability to present complex data clearly to diverse internal audiences.
• High interest in capital markets, fixed income, and portfolio management with a genuine desire to develop expertise in investment operations.

Education and Experience: 

• Bachelor’s degree required, preferably in Finance, Economics, Accounting, Mathematics, Computer Science, or a related field.
• 1 to 3 years of experience in investment operations, portfolio analytics, middle office, or a related financial services role.
• Active pursuit of the CFA designation strongly preferred.
• Working knowledge of fixed income instruments including Treasuries, agency securities, commercial paper, and money market instruments highly desired.
• Hands-on experience with the Bloomberg Terminal, including portfolio management views, data functions, and analytics preferred.
• Advanced Microsoft Excel skills required.
• Proficient in Microsoft Word, PowerPoint, and Outlook.
• Python preferred; demonstrated ability to build reports or analyses and work collaboratively with development teams on automation and standardization of reporting workflows.
• Familiarity with investment adviser operations and applicable regulatory frameworks (e.g., Investment Advisers Act of 1940) a plus.

Physical Requirements:  Must be able to work at a computer for long periods of time. Lift up to 15 lbs.