Portfolio Analyst

plugandplaytechcenter; Valencia; Presencial; EUR 42.000 - 64.000; Jornada completa

Descripción de la vacante

Plug and Play Tech Center is seeking a Portfolio Analyst to join our Portfolio Analytics team in Valencia. This role focuses on venture capital data, portfolio reporting, and stakeholder support across Ventures, Marketing, Sales, and Legal.

You will handle data from PitchBook, Crunchbase and related platforms, building robust dashboards and models in Google Sheets and Excel. The ideal candidate has a finance/data analytics background, advanced spreadsheet skills, and familiarity with SQL, VBA,

Formación

• Bachelor's degree in Finance, Economics, Business Analytics, Data Analytics, or related quantitative field.
• Advanced Google Sheets/Excel skills with data analysis.
• SQL, VBA, and AI tools (e.g., Claude) are a plus.
• Strong attention to detail.
• Excellent written and verbal communication skills.
• Independent, curious, and able to work in a fast-paced environment.

Responsabilidades

• Generate analytical reports and dashboards using portfolio and investment data.
• Build and maintain Google Sheets and Excel models with advanced formulas.
• Ensure data quality across internal systems and reconcile discrepancies.
• Provide portfolio and market data for strategic decision-making.
• Prepare data submissions to PitchBook, Crunchbase, TIME, and other platforms.
• Automate reporting workflows using SQL, VBA, and AI tools where relevant.
• Collaborate with cross-functional teams on analyses and data requests.
• Support ad hoc administrative needs as they arise.

Conocimientos

Google Sheets/Excel proficiency

SQL

VBA

AI tools

Educación

Bachelor's degree in Finance, Economics, Business Analytics, Data Analytics, or related quantitative field

Herramientas

Claude

Descripción del empleo

WHO WE ARE:

Plug and Play Tech Center is the ultimate innovation platform, bringing together the best startups and the world's largest corporations to create the most meaningful connections that bring innovation to anyone, anywhere. We are on a mission to bring the benefits of Silicon Valley to all corners of the world. Each year, hundreds of entrepreneurs join our vertical-specific accelerator programs to team up with our corporate members or receive a direct investment from Plug and Play.

Plug and Play has over 60 locations across the world and our corporate members include: Prologis, Walmart, Coca Cola, Eli Lilly, University Hospitals, Zimmer Biomet, Duke Energy, Tavistock, Guidewell, Doosan Bobcat, UCF, and over 500 more. Plug and Play's corporate members utilize Plug and Play to identify the best startups to meet their challenges. Plug and Play's proven investment track record includes Honey, Dropbox, Lending Club, Kustomer, Einride, and many more.

WHO WE ARE LOOKING FOR:

We are seeking a Portfolio Analyst to join our Portfolio Analytics team. This role offers hands-on experience in venture capital, working with complex investment and portfolio data that supports decision-making across the firm. The successful candidate will contribute to portfolio reporting, data quality, investment tracking, and strategic initiatives while collaborating with teams across Ventures, Marketing, Sales, Legal, etc.

Job Duties:

• Generate analytical reports and dashboards using Plug and Play's portfolio and investment data.
• Build and maintain Google Sheets and Excel models using advanced formulas and data manipulation techniques.
• Maintain the quality and accuracy of portfolio data across internal systems, including reconciling data across sources and flagging discrepancies.
• Support internal stakeholders by providing portfolio and market data for strategic decision-making.
• Prepare and validate data submitted to external databases and publications, including PitchBook, Crunchbase, TIME, and other industry platforms.
• Automate and improve reporting workflows using SQL, VBA, AI tools (e.g., Claude), or other technologies where appropriate.
• Collaborate with cross-functional teams on custom analyses, data requests, and firm-wide initiatives.
• Support ad hoc administrative needs as they arise.

The ideal candidate:

• Bachelor's degree in Finance, Economics, Business Analytics, Data Analytics, or a related quantitative field.
• Ability to understand complex datasets, identify trends, and communicate insights effectively.
• Highly proficient with Google Sheets/Excel, including advanced formulas and data analysis. Experience with SQL, VBA, AI tools is a plus (e.g. Claude).
• Strong attention to detail.
• Highly organized with the ability to manage multiple priorities to meet deadlines.
• Excellent written and verbal communication skills.
• Independent, curious, and eager to work in a fast-paced environment.