Sr. 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 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 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
You are a creator at heart who understands the importance of a well-designed data environment. You have a deep understanding of business problems within the company and how to create, transform, and store the data needed to solve these problems. You are a systematic thinker and enjoy finding creative technical solutions to hard problems by collaborating closely with your team. You are curious and constantly seeking the best solutions to what makes a business/operation successful and want to contribute to that success.

• 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

#Boston #Hybrid #CR1
Get to Know Klaviyo
We're Klaviyo (pronounced clay-vee-oh). We empower creators to own their destiny by making first-party data accessible and actionable like never before. We see limitless potential for the technology we're developing to nurture personalized experiences in ecommerce and beyond. To reach our goals, we need our own crew of remarkable creators-ambitious and collaborative teammates who stay focused on our north star: delighting our customers. If you're ready to do the best work of your career, where you'll be welcomed as your whole self from day one and supported with generous benefits, we hope you'll join us.
Klaviyo is committed to a policy of equal opportunity and non-discrimination. We do not discriminate on the basis of race, ethnicity, citizenship, national origin, color, religion or religious creed, age, sex (including pregnancy), gender identity, sexual orientation, physical or mental disability, veteran or active military status, marital status, criminal record, genetics, retaliation, sexual harassment or any other characteristic protected by applicable law.
IMPORTANT NOTICE: Our company takes the security and privacy of job applicants very seriously. We will never ask for payment, bank details, or personal financial information as part of the application process. All our legitimate job postings can be found on our official career site. Please be cautious of job offers that come from non-company email addresses (@klaviyo.com), instant messaging platforms, or unsolicited calls.