People Analytics Intern

Simon‑Kucher; Barcelona; On-site; EUR 45,000 - 70,000; Full time

Job summary

Simon-Kucher, a global growth consultancy, is seeking an HR Analytics professional to join our Healthcare & Life Sciences team in Spain. You will work on end-to-end workforce planning, data extraction from SAP, and performance analysis to support senior stakeholders.

Based in Barcelona or Madrid, you will develop dashboards and reports, collaborate with cross-functional teams, and help translate data insights into strategic decisions in a fast-paced environment. Fluency in English is required.

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 interest in Power BI and data visualization tools.
• Ability to prepare dashboards, reports, and presentations for stakeholders.

Responsibilities

• Support end-to-end HR Analytics and workforce planning for Healthcare & Life Sciences team.
• Assist with annual FTE planning aligning staffing with business goals.
• Analyze FTE utilization to assess workload and resources.
• Contribute to employee performance analysis for talent development.
• Extract and consolidate data from SAP and internal databases.
• Perform data cleaning, validation and quality checks for accuracy.

Skills

Excel

Power Query

Pivot Tables

English

Data visualization

Job description

• 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.

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]