People Analytics Intern

Simon‑Kucher; Madrid; On-site; EUR 8,900 - 12,000; Part time

Job summary

Simon-Kucher is offering a People Analytics Intern position in Spain (Barcelona and Madrid). You will support end-to-end HR analytics and workforce planning for the Healthcare & Life Sciences team, assist with annual FTE planning, and analyze workload and resource availability.

You will extract data from SAP and internal systems, perform data cleaning, and prepare dashboards and reports for senior stakeholders.

Qualifications

• Advanced proficiency in Microsoft Excel, including Power Query and Pivot Tables.
• Advanced-Proficient level of English.
• Strong analytical and problem-solving skills with large datasets.
• Basic knowledge or strong interest in Power BI and data visualization tools.
• Ability to prepare clear dashboards, reports, and presentations for stakeholders.

Responsibilities

• Support end-to-end HR Analytics and workforce planning within Healthcare & Life Sciences.
• Assist with annual FTE planning aligning staffing with business performance.
• Analyze FTE utilization to assess workload and resource availability.
• Contribute to employee performance analysis to support talent development.
• Extract and consolidate data from SAP and internal databases.
• Perform data cleaning, validation, and quality checks.
• Prepare presentations and analytical deliverables for senior stakeholders.
• Collaborate with cross-functional teams to translate business needs into analytics.
• Support ad hoc HR and workforce analytics projects.

Skills

Excel

Power Query

Pivot Tables

English proficiency

Analytical skills

Data visualization

Tools

Power BI

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]