People Analytics Intern

Simon‑Kucher; Barcelona; On-site; EUR 8,900 - 13,000; Part time

Job summary

Simon-Kucher is seeking a People Analytics Intern in Spain (Barcelona or Madrid) to support HR analytics and workforce planning within the Healthcare & Life Sciences team.

You will develop dashboards, analyze FTE utilization, and help align staffing with business goals using Excel, SAP data, and basic Power BI. This internship offers exposure to senior stakeholders in a fast-paced, values-driven culture.

Qualifications

• Advanced proficiency in Microsoft Excel with Power Query and Pivot Tables.
• Advanced-Proficient level of English.
• Strong analytical and problem-solving skills with the ability to work with large datasets.
• Basic knowledge or strong interest in Power BI and data visualization tools.
• Ability to prepare clear dashboards, reports, and presentations for business stakeholders.
• Strong organizational skills and ability to manage multiple tasks simultaneously.
• Business-oriented mindset with the ability to connect data insights to operational and strategic decisions.
• Interest in HR Analytics, workforce planning, and people management topics.
• Proactive attitude and willingness to learn in a fast-paced, dynamic environment.

Responsibilities

• Support the end-to-end HR Analytics and workforce planning processes related to workforce management and resource allocation within the Healthcare & Life Sciences team.
• Assist with annual FTE planning by aligning staffing needs with business performance and operational goals.
• Analyze FTE utilization to assess team workload, capacity, and resource availability.
• Contribute to employee performance analysis to support talent development and evaluation processes.
• Extract and consolidate data from systems such as SAP and other internal databases.
• Perform data cleaning, validation, and quality checks to ensure accuracy and consistency.
• Prepare presentations, reports, and analytical deliverables for senior stakeholders, including Partners and Division Heads.
• Collaborate with cross-functional teams to translate business needs into analytical solutions.
• Support ad hoc HR and workforce analytics projects as required.

Skills

Advanced Excel

Power Query

Pivot Tables

Power BI

English (Advanced)

Data analysis

Presentations

Organizational skills

Business insights

Tools

SAP

Job description

People Analytics Intern

In Spain - Barcelona | Madrid

What makes us special:

• Become part of a unique entrepreneurial team. Think independently, use your initiative, and take some risks. Entrepreneurship is a powerful force that drives the growth not only of our firm but our clients and people.
• Unlock the power of opportunity. Advance your career in a thriving company that creates positive impact. We invest in your professional development every step of the way.
• Work in a values-driven culture. At Simon-Kucher, our vision is to become the world's leading growth specialist. Our values guide the way we do business and communicate our distinctiveness. They sum up what we stand for, influence our culture, and drive how and why we do things.

How you will create an impact:

• Support the end-to-end HR Analytics and workforce planning processes related to workforce management and resource allocation within the Healthcare & Life Sciences team.
• Assist with annual FTE planning by aligning staffing needs with business performance and operational goals.
• Analyze FTE utilization to assess team workload, capacity, and resource availability.
• Contribute to employee performance analysis to support talent development and evaluation processes.
• Extract and consolidate data from systems such as SAP and other internal databases.
• Perform data cleaning, validation, and quality checks to ensure accuracy and consistency.
• Prepare presentations, reports, and analytical deliverables for senior stakeholders, including Partners and Division Heads.
• Collaborate with cross-functional teams to translate business needs into analytical solutions.
• Support ad hoc HR and workforce analytics projects as required.

About you:

• Advanced proficiency in Microsoft Excel, including intensive use of Power Query, Pivot Tables, and other functions.
• Advanced-Proficient level of English.
• Strong analytical and problem-solving skills with the ability to work with large datasets.
• Basic knowledge or strong interest in Power BI and data visualization tools.
• Ability to prepare clear dashboards, reports, and presentations for business stakeholders.
• Strong organizational skills and ability to manage multiple tasks simultaneously.
• Business-oriented mindset with the ability to connect data insights to operational and strategic decisions.
• Interest in HR Analytics, workforce planning, and people management topics.
• Proactive attitude and willingness to learn in a fast-paced, dynamic environment.

About Simon-Kucher

Simon-Kucher is a global consultancy with more than 2,200 employees in 30+ countries. Our sole focus is on unlocking better growth that drives measurable revenue and profit for our clients. As a trusted commercial advisor, we combine deep consulting expertise, growth specialization, and technology to scale impact. We optimize every lever of commercial strategy – product, pricing, innovation, marketing, sales, and digital – based on deep insights into what customers value and are willing to pay for. With over 40 years of experience in monetization, we are regarded as the world’s leading commercial growth and pricing specialist. simon-kucher.com

We believe in building a culture that embraces diversity, equity, and inclusion, creating an environment in which our people feel valued, are able to be themselves and feel their contribution matters. If we get that right, remarkable things will happen; people will grow faster, innovate, feel valued, and create better outcomes for everyone – our people, our clients and, of course, our business.

Your personal contact:

Sofía Poch
[e-mail]