Role Overview
Join Simon-Kucher as a People Analytics Intern in Spain (Barcelona or Madrid). Support end-to-end HR Analytics and workforce planning for the Healthcare & Life Sciences team, including FTE planning, utilization analysis, employee performance analysis, and data extraction from SAP and internal databases. Prepare reports and dashboards for senior stakeholders using Microsoft Excel and Power BI.
Responsibilities
- Align staffing needs with business goals for annual FTE planning
- Analyze FTE utilization to assess workload, capacity, and resource availability
- Contribute to employee performance analysis for talent development
- Extract, clean, and validate data from SAP and other systems
- Build presentations, reports, and analytical deliverables for Partners and Division Heads
- Collaborate cross-functionally to translate business needs into analytical solutions
- Support ad hoc HR and workforce analytics projects
Requirements
- Advanced proficiency in Microsoft Excel (Power Query, Pivot Tables)
- Advanced-proficient English
- Strong analytical and problem-solving skills with large datasets
- Basic knowledge or strong interest in Power BI and data visualization
- Ability to create clear dashboards, reports, and presentations
- Strong organizational skills and multi-tasking ability
- Business-oriented mindset connecting data insights to strategic decisions
- Interest in HR Analytics, workforce planning, and people management
- Proactive attitude and willingness to learn in a fast-paced environment
Benefits
- Entrepreneurial culture with independence and initiative
- Career advancement in a high-impact global consultancy
- Values-driven environment focused on diversity, equity, and inclusion
- Professional development investment