Senior Analyst — People & Workforce Intelligence (PWI) (d/f/m)
Indexed description
The Senior Analyst — PWI sits within the Data, Systems & AI department and partners closely with the People & Workplace Intelligence (PWI) function. This role combines two capabilities that are most powerful together: building the data foundations that make reliable analysis possible, and delivering the analysis itself. You own the infrastructure — writing dbt models from raw sources — and you own the insight: turning that data into clear recommendations for People leadership and partners.
You will work closely with PBPs and People leadership to connect people data sources — HRIS, absence and attendance systems, and others — and enable a self-serve analytics capability across the people domain.
What You'll Do
Data Foundations
- Build and own dbt models end-to-end — from raw source ingestion through to staging, intermediate, and reporting layers — for the PWI domain, covering HRIS, headcount, absence, attendance, and adjacent people data sources.
- Design and maintain scalable warehouse schemas in Snowflake, with clear data lineage, documentation, and version-controlled code (Git).
- Define, document, and steward metric definitions and the semantic layer for people data, ensuring reliable KPI logic and metric consistency across the domain.
- Implement data quality testing, monitoring, and alerting so that data issues are caught early and fixed proactively — not discovered by stakeholders.
- Deliver structured analysis on headcount, attrition, absence and attendance, org design, manager effectiveness, and compensation for PBPs and PWI leadership — forming clear hypotheses and producing decision-ready outputs, not just data dumps.
- Build and maintain intuitive dashboards and reporting that allow stakeholders to self-serve on day-to-day questions without requiring analyst involvement.
- Support MBR and QBR cycles with data storytelling: own the narrative, not just the numbers.
- Partner with PBPs to diagnose root-cause data gaps, translate urgent business needs into analytical deliverables, and systematically improve the quality of people data over time.
- Act as the embedded analytical partner for the PWI function — showing up proactively, anticipating needs, and flagging risks before they escalate.
- Present findings directly to People leadership with confident, prescriptive recommendations.
- Enable PBPs to work more independently with data through documentation, self-serve tools, and direct coaching.
- 5+ years in analytics engineering, analytics, or a hybrid of both — you have done both the building and the analysis, not just one side.
- Expert-level dbt: you have built models from raw source data, written tests, managed documentation, and understand lineage end-to-end — not just maintained existing models.
- Strong SQL: complex queries, performance optimization, ability to work across a Snowflake-based data warehouse without hand-holding.
- Analytical rigour: you structure ambiguous problems into hypotheses, identify the right metrics, and produce outputs that lead to decisions — not more questions.
- Clear communicator: you translate data into plain language for non-technical stakeholders, present confidently, and write documentation that people actually use.
- Experience with BI tooling (HEX, Tableau, Looker, or equivalent) for building stakeholder-facing dashboards and reporting.
- Comfortable with Git and version-controlled codebases as a daily practice.
- High ownership: you diagnose root causes, drive work independently, and don't wait to be told what matters next.
- Experience with people/HRIS data — Workday, BambooHR, or similar compensation and benefits tooling.
- Python for analytical workflows and automation.
- Exposure to AI/LLM tooling (Claude, GPT) for insight generation or workflow automation.
At Personio, we value in-person collaboration while also offering flexibility. This role is office-based, with 3 days per week required in your contracted office location. The remaining days can be worked from home or in the office if you prefer. In addition, you’ll have 20 Flex Days per year to work remotely from other locations. Aside from our people, culture, and mission, check out some of the other benefits that make Personio a great place to work:
- Receive a competitive reward package – reevaluated each year – that includes salary, benefits, and pre-IPO equity
- Enjoy 28 days of paid vacation, plus an additional day after 2 and 4 years
- Make an impact on the environment and society with 1 (fully paid) Impact Day
- Receive generous family leave, child support, mental health support, and sabbatical opportunities
- We enjoy gathering for meals, cultural initiatives, and events like local Summer Sessions and year-end celebrations. There's also healthy snacks, drinks, and a weekly catered lunch.
Create a free Caio profile to unlock more results and save your role and location preferences.
Unlock free search