Secondaries Data Analyst Experience: 2 to 7 YearsScope of Work Secondary Vertical ImplementationSupport definition of the secondaries data model alongside onshore stakeholdersBuild and maintain the Excel-based staging tracker for secondaries investment dataAutomate workflows connecting multi sources into consolidated workbookCollect, validate, and review incoming data against defined specificationsDocument data specifications, validation rules, and review procedures as standards evolveAssist with migrating validated data into Everest or other on-system toolsDatabase Enrichment and ArchivingArchive secondaries pricing and diversification databasesMap net new funds from the pricing database (currently name-only) to on-system and off-system IDsResolve naming ambiguities using market data providers and internal recordsEnsure pricing records in the Excel/Access model are correctly tied back to funds and companiesBuild lookup and matching logic to monitor completeness and accuracy of mappings over timeAssist in building SQL based retrieval toolsRequired Skill Sets Familiarity with secondary investments or financial accountingFamiliarity with market data providersAdvanced Excel / Power QueryPython (pandas)AI Prompt EngineeringOperational workAttention to detailOrganized record keepingStrong communication skillsData reconciliationSQL
Job Title
Data Analyst - Private equity