Senior Data Engineer, Business Intelligence

At Klaviyo, we value the unique backgrounds, experiences and perspectives each Klaviyo (we call ourselves Klaviyos) brings to our workplace each and every day. We believe everyone deserves a fair shot at success and appreciate the experiences each person brings beyond the traditional job requirements. If you’re a close but not exact match with the description, we hope you’ll still consider applying. Want to learn more about life at Klaviyo? Visit klaviyo.com/careers to see how we empower creators to own their own destiny.

At Klaviyo, we value the unique backgrounds, experiences and perspectives each Klaviyo (we call ourselves Klaviyos) brings to our workplace each and every day. We believe everyone deserves a fair shot at success and appreciate the experiences each person brings beyond the traditional job requirements. If you’re a close but not exact match with the description, we hope you’ll still consider applying. Want to learn more about life at Klaviyo? Visit careers.klaviyo.com to see how we empower creators to own their own destiny.

Data is at the heart of every decision made at Klaviyo, and we’re looking for a Senior Data Engineer to join our Business Intelligence (BI) team. BI at Klaviyo collaborates across all departments to provide a platform that powers all internal data, analytic, and reporting needs. Our mission is to champion data-driven value creation, and you will own creating and maintaining the internal data infrastructure that powers Klaviyo’s business. This role in particular will significantly contribute to the infrastructure, pipelines, and security/compliance aspects of our internal analytics platform while driving architectural innovation and mentoring the team.

How You’ll Make a Difference

As a Senior Data Engineer, you will shape the scalability, reliability, and cost-efficiency of our data platform. You’ll lead architectural decisions, establish engineering best practices, and mentor other engineers while partnering closely with analytics, engineering, and business stakeholders.

Your work will directly influence data-driven decision-making across the organization by ensuring our data systems are performant, observable, and built to scale.

What You’ll Do (Responsibilities)

Accelerating Engineering with AI

• Transform workflows by putting AI at the center, building smarter systems and ways of working from the ground up for example, using AI to generate tests, detect anomalies, summarize data issues, or accelerate analysis.

Data Architecture & Optimization

• Design, develop, and maintain scalable dbt models and pipelines, including advanced incremental and merge strategies.
• Architect solutions for attribution models, event data pipelines, and analytics at scale.
• Lead performance optimization efforts across Snowflake and related data systems.
• Define and enforce best practices for query performance, warehouse management, and cost control.

Pipeline & Platform Ownership

• Own end-to-end data pipelines, ensuring reliability, scalability, and observability.
• Lead complex DAG orchestration with Airflow/MWAA.
• Oversee Spark/EMR cluster management, job optimization, and large-scale backfills.
• Implement monitoring, alerting, and automated recovery strategies for production systems.

Infrastructure & DevOps Leadership

• Architect infrastructure-as-code solutions using Terraform for Snowflake and AWS resources.
• Oversee integration of AWS services (S3, EMR, Secrets Manager, CloudWatch) into the data platform.
• Guide CI/CD pipeline design and improvements using GitHub Actions and CodeBuild.
• Promote containerization best practices with Docker for scalable deployments.

Cost & Performance Management

• Monitor Snowflake and EMR usage to proactively optimize costs.
• Analyze query performance and warehouse efficiency.
• Troubleshoot and resolve pipeline and infrastructure performance issues.

Leadership & Mentorship

• Mentor and coach junior and mid-level data engineers through code reviews and technical guidance.
• Establish and enforce coding standards, testing practices, and CI/CD processes.
• Serve as technical lead for cross-functional data initiatives.
• Advocate for reliability, performance, and cost optimization across the data engineering function.

Who You Are (Qualifications)

• 5+ years of data engineering experience, including demonstrated technical leadership.
• Expert-level proficiency in dbt, including advanced modeling, testing framewo