Competent skills with Python and SQL 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 Work experience in institutional asset management, operations, client support, or finance Experience with and knowledge of 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.