iCapital · posted · checked
Market Data Analyst – Assistant Vice President
ExcelPythonSQLOn-site · LisbonManager
Who can apply
On-site · Lisbon
Location: Lisbon, Portugal
About the Role
This role manages iCapital's relationships with external data providers, market data vendors, index and benchmark providers, and research partners, while supporting the quality and use of third-party financial data across the firm. The individual will be the central point of coordination for vendor selection, negotiation, renewals, licensing compliance, usage oversight, and cost optimization, and will manage data contracts and renewals as our data product offering grows.
The role partners closely with Data Solutions, Research, Product, Marketplace, Technology, Legal, Compliance, Information Security, Procurement, and Finance.
Key Responsibilities
Manage relationships with third-party data vendors (market data, benchmarks, reference data, analytics, fund data, research), including strategic providers such as Bloomberg, S&P Global, Cliffwater, FactSet, MSCI, Morningstar, LSEG, ICE Data Services, and Preqin.
Serve as the central point of contact for new data requests; evaluate new datasets and providers through trials, coverage comparisons, and validation.
Lead commercial negotiations, renewals, and vendor performance reviews; identify opportunities to consolidate vendors, optimize spend, and improve contract terms.
Maintain an inventory of data sources, licenses, contracts, business owners, users, costs, dependencies, and renewal dates.
Monitor usage and ROI; develop vendor scorecards and KPIs covering service levels, data quality, responsiveness, and commercial performance.
Partner with Legal, Compliance, Procurement, and Information Security on vendor onboarding, licensing compliance, and ongoing oversight.
Source, analyze, and reconcile market, security, fund, and benchmark data across public and private markets; investigate and resolve discrepancies.
Maintain data definitions, identifier mappings, and quality controls; partner with Technology to integrate vendor data and monitor feeds.
Use Excel, SQL, and where applicable Python to automate extraction, validation, reconciliation, and reporting.