Senior Analytics Engineer, People Analytics

About the team and role

Data is at the heart of every decision made at Klaviyo, and we’re looking for a Business Intelligence Data Engineer to join our Business Intelligence (BI) team supporting People Analytics. This domain of data aims to improve the experience of all Klaviyos, from culture and engagement to retention and satisfaction. This role sits in Data Engineering as part of the BI team and is fully dedicated to People Analytics as a sponsored headcount.

You’ll build and steward the source of truth for people data so People leaders and analysts can answer lifecycle questions quickly and confidently and turn those insights into a healthier, higher-performing organization.

You will be an independent, embedded partner to People leadership, capable of translating ambiguous requirements into stable data products. You’ll be supported by the broader Data Engineering organization’s standards, tooling, and review practices.

How you’ll make a difference

• Deliver people‑data SSoT that drives employee experience. Stand up curated, documented marts that make it easy to monitor org health, retention, hiring, performance, movement, and comp cycles so that leadership can act earlier and more precisely.
• Own the pipelines & models end‑to‑end. Build and maintain reliable integrations from core HR systems (e.g., HRIS/ATS/OKR/comp), model them in dbt, and publish governed marts and reverse‑ETLs to operational destinations where they create value.
• Create lifecycle views with People Analytics. Partner with analysts to build hire→onboard→develop→promote→compensate→offboard lifecycle views and “employee 360” profiles that reduce swivel‑chair reporting and speed up decision cycles.
• Raise the bar on data reliability and governance. Instrument monitoring and alerting, tests (freshness/volume/constraints), and documentation so the people data ecosystem is discoverable, auditable, and self-serve.
• Operate as a trusted partner to leadership. Work directly with People leadership to scope problems, clarify trade‑offs, and communicate technical concepts in exec‑ready language.

What you’ll do (responsibilities)

• Integrations & ingestion: Own secure ingestion from HRIS/ATS/comp/performance systems into Snowflake; define SLAs/SLOs; implement monitoring & alerting for each feed.
• Modeling & marts: Design dimensional/entity models (dbt) for employees, positions, org structure, requisitions/offers, performance/promo history, compensation/equity, and movement; publish curated marts with strong contracts and lineage.
• Reverse ETL: Operationalize high‑value models to downstream tools and workflows using reverse‑ETL patterns to close the loop between insight and action.
• Quality & governance: Implement tests (unit/integration, schema/freshness), data policies (masking, purpose‑based access), and documentation that enable safe self‑service across the analytics community.
• Repository stewardship: Maintain the analytics codebase (dbt repo), perform code reviews, and ensure modular, reusable patterns the broader team can adopt.
• Stakeholder partnership: Run an intake & engagement model with People Analytics (primary), HRIS/People Tech (security/integration), Finance (plan/comp interfaces), and BI/Platform teams (shared standards).&