Data Analyst HR (People Analytics)

TL;DR

Data Analyst HR (People Analytics): Building scalable data models and impactful dashboards to provide transparency on workforce dynamics with an accent on headcount forecasting and retention analysis. Focus on transforming complex people data into actionable insights to support organizational growth and performance.

Location: Cologne, Germany (Hybrid)

Company

Europe’s No.1 e-pharmacy powered by cutting-edge innovation and passionate teams.

What you will do

• Lead the design and development of advanced data models in Tabular and Databricks for workforce planning and organizational effectiveness.
• Develop and oversee Power BI Cloud dashboards to surface key HR KPIs such as hiring, attrition, and engagement.
• Collaborate with Talent Acquisition, HR Service, and HR Business Partnering to align analytics with strategic objectives.
• Conduct in-depth operational data analysis to identify attrition drivers and hiring funnel performance.
• Transform complex people data into compelling narratives tailored to HR and business stakeholders.

Requirements

• Bachelor’s or Master’s degree in Computer Science, IT, Economics, HR Analytics, or a related field.
• 4+ years of experience as a Data Analyst or Analytics Consultant, ideally within People Analytics.
• Advanced proficiency in Power BI Cloud, including data modeling and semantic layer optimization.
• Hands-on experience with Databricks and SQL for handling large HR datasets.
• Must be based in or able to work from Cologne, Germany.

Nice to have

• Experience with HR systems such as Workday or SAP SuccessFactors.
• Proficiency with Jira.

Culture & Benefits

• Individual work-from-home arrangements, including the possibility to work from anywhere in the EU for up to 20 days a year.
• Financial support for childcare with a Kindergarten Grant of €100 per month.
• Free and anonymous professional mental health support via nilo.
• Fully funded Deutschland Ticket for daily commuting.
• Membership package at Urban Sports Club for health and fitness.
• Continuous professional growth through internal and external training programs.