Sr. Data Engineer, Business Intelligence

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 play an essential role in creating and maintaining the data infrastructure that powers Klaviyo's business. This role in particular will oversee the infrastructure, pipelines, and security/compliance aspect of our internal analytics platform.

Technologies we use (not exhaustive):

• Amazon Web Services (EC2, EMR, S3, Lambda, Athena, DynamoDB, etc.), Terraform, Kubernetes, Docker.
• Snowflake, Spark, Trino, Airflow, and dbt.
• Fivetran, Airbyte, and Workato.
• ThoughtSpot, Tableau, and dbt metrics.

How you will make a difference:

• Develop and maintain the "source of truth" data environment used by everyone at Klaviyo to measure the health of the business.
• Develop data models that power predictive recommendations, marketing attribution, and financial forecasts to support decision-making within the organization.
• Work with petabyte scale databases optimized for business analytics.
• Collaborate on a regular basis with the following teams at Klaviyo: Finance, Go-To-Market, Engineering, Customer Success, Support, Product, Sales, and Marketing.
• Work with a team of data engineers and analysts to build a world-class, self-service data environment that everyone at the company can use.

Who You Are:

• Strong understanding of cloud technologies (AWS).
• Experience with Infrastructure as Code (IaC) tooling such as Terraform.
• 3+ years of data development experience in SQL and 3+ years of experience in object-oriented programming languages (i.e. Python).
• Experience in database design, 3NF, dimensional modeling, data vault, or star schema.
• Experience with Big Data technologies (Snowflake, Databricks/Spark, Trino).
• 1+ years of data modeling experience using dbt.
• Experience ingesting data from REST APIs to a data warehouse or data lake.
• Experience with automated testing, test-driven development, and CI/CD pipelines.
• Comfortable with massive amounts of semi-structured data.
• Has knowledge of data engineering best practices (data discovery, data documentation, infrastructure development/deployment, and information security).
• Prior work experience in distributed computing systems or stream processing a plus.