Who You Are You have a bachelors degree, or equivalent, preferably in finance, accounting, economics, business management, mathematics, or computer science two years minimum work experience in institutional asset management, operations, client support, or finance Basic knowledge of fixed income Strong Excel skills, including PivotTables, advanced formulas (e.g., INDEX/MATCH or XLOOKUP), and analysis of large datasets for reporting and reconciliation Skills That Will Help You Stand Out Competent skills with Python and SQL Experience with AI assisted code writing tools Knowledge of preferred and capital securities FINRA SIE, Series 7 and Series 63 preferred or ability to obtain within 180 days Experience with Bloomberg Terminal; including AIM, CMGR, PORT, and SQL database queries Excellent communication, writing, and organizational skills Salary Range Information Salary ranges below reflect targeted base salaries. Monitor and maintain client account performance and attribution reporting, internal composites, benchmarks and indices Analyze and maintain market constituents, and other strategic data for the firm Communicate and disseminate information to sales and marketing teams regarding portfolio, credit and market performance Design and implement systems to make client service data related activities more efficient Design, test, monitor, and internally report upon portfolio guideline compliance rules Coordinate and consolidate responses to requests for proposals Interface with portfolio managers and credit analysts, clients and affiliated compliance personnel regarding portfolio compliance and coordination Spectrum is a registered institutional advisor, with a subsidiary broker-dealer.