Klaviyo is a company that empowers creators to own their destiny by making first-party data accessible and actionable. They are seeking a Senior Analytics Engineer to join their Go To Market team, focusing on Compensation Analytics to improve the experience of variable compensation plans for employees.
Responsibilities:
- Deliver compensation‑data SSoT that drives better employee experience, is SOX compliant, and entirely auditable by both internal and 3rd party organizations. Maintain and sStand up curated, documented marts that make it easy to monitor attainment health, quota setting, audits, and cycles so that leadership can minimize time in front of compensation boards to focus on their organizations
- Own the pipelines & models end‑to‑end. Build and maintain reliable integrations from core compensation systems (e.g., SPM/ICM/CRM), model them in dbt, and publish governed marts and reverse‑ETLs to operational destinations where they create value
- Create attainment views with Compensation and People Analytics. Partner with analysts to build quota→BoB management→attainment→submission→booking lifecycle views of quarterly compensation. Focusing on quicker cadences to booking and dynamic reconciliation processes
- Raise the bar on data reliability and governance. Instrument monitoring and alerting, tests (freshness/volume/constraints), and documentation so the compensation data ecosystem is discoverable, auditable, and self-serve
- Operate as a trusted partner to leadership. Work directly with Operations and Compensation leadership to scope problems, clarify trade‑offs, and communicate technical concepts in exec‑ready language
- Transform workflows by putting AI at the center, building smarter systems and ways of working from the ground up
- 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), multi-layered validation frameworks that routinely validate data integrity, 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 Compensation Analytics (primary), HRIS/People Tech (security/integration), Finance (plan/comp interfaces), and BI/Platform teams (shared standards)
Requirements:
- 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