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

Who you are (qualifications)

Must‑have

• 3–5+ years in analytics/data engineering with production ELT in Snowflake + dbt + SQL; Python for orchestration/utilities.


• Demonstrated independence partnering with senior, non‑technical leaders; able to translate open‑ended needs into scalable data products.


• Proven experience implementing tests, monitoring, and documentation that keep pipelines healthy and reporting trustworthy.


• Experience building data integrations and reverse‑ETL pipelines that support business operations.


• Airflow (orchestration) and Fivetran/Workato (ELT/integration).


• Familiarity with data privacy controls (masking/RLS) in people data.


• AWS experience (S3/EC2/Lambda) and IaC/Terraform.


• You’ve already experimented with AI in work or personal projects, and you’re excited to dive in and learn fast. You’re hungry to responsibly explore new AI tools and workflows, finding ways to make your work smarter and more efficient. 

The tools you’ll use

Snowflake, dbt, Airflow, Fivetran, Workato, Python, AWS, Tableau/Looker/ThoughtSpot; publishing via reverse‑ETL where appropriate.

Success measures & ramp plan (30/60/90)

• 30 days: Access/RBAC in place; landscape documented; agree with People leadership on the first lifecycle views and SSoT scope; monitoring baselines defined.


• 60 days: Core HRIS ingestion + tests/alerts live; first curated marts (headcount/movement, recruiting funnel) powering People Analytics dashboards; reverse‑ETL pilot to an operational destination.


• 90 days: Extend coverage (e.g., performance, compensation); publish employee 360 profile model; codify governance/RLS for sensitive attributes; usage dashboard for self‑serve adoption.

What this role is not

• Not a Workday configuration/HRIS admin role.


• Not an infra‑only platform role. This is hands‑on modeling + ELT + reverse‑ETL in service of People Analytics.

Our commitment to candidates

We value unique backgrounds and experiences; even if you don’t match every bullet, we encourage you to apply. Klaviyo is an equal‑opportunity employer.

We use Covey as part of our hiring and / or promotional process. For jobs or candidates in NYC, certain features may qualify it as an AEDT. As part of the evaluation process we provide Covey with job requirements and candidate submitted applications. We began using Covey Scout for Inbound on April 3, 2025.

Please see the independent bias audit report covering our use of Covey here