Business Intelligence Data Engineer

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 Business Intelligence Data Engineer to join our Business Intelligence (BI) team. BI at Klaviyo collaborates across all departments to provide solutions for our 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. The role in particular will oversee the creation of all the backend data models used to power centralized metrics and reportings used across the company.Technologies we use (not exhaustive): Snowflake, Airflow, and dbt. Fivetran, Airbyte, and Workato. ThoughtSpot, Tableau, and dbt metrics Amazon Web Services (EC2, S3, Lambda, Athena, DynamoDB, etc.), Terraform, Kubernetes, Docker 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. Work with petabyte scale databases optimized for business analytics Develop data models that power predictive recommendations, marketing attribution, and financial forecasts to support the decision-making within the organization. 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. 2-5 years of data development experience in SQL and 1+ years of experience in object-oriented programming languages (i.e. Python) Experience in database design, 3NF, dimensional modeling, or star schema. Experience with Big Data technologies (Snowflake, Databricks/Spark, Trino) 1+ years of data modeling experience using dbt Experience with building data integration / pipeline to support business operations using reverse ETL tools Experience with reporting tools like Tableau/Looker/Thoughtspot 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) Masters degree in data Engineering or undergraduate degree and equivalent experience

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.