Advanced Microsoft Excel skills, including pivot tables, lookups, formulas, data validation, and reconciliation workflows across large data sets; experience with Python or other tools for large-scale data analysis is a plus. Working knowledge of the security types held across SMA portfolios, including fixed income instruments such as corporate bonds, treasuries, agency mortgages, CMBS, CMOs, municipal bonds, and preferreds.