<p>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.</p> <p>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):</p> <ul> <li>Snowflake, Airflow, and dbt. </li><li>Fivetran, Airbyte, and Workato. </li><li>ThoughtSpot, Tableau, and dbt metrics </li><li>Amazon Web Services (EC2, S3, Lambda, Athena, DynamoDB, etc.), Terraform, Kubernetes, Docker </li></ul> <p>How you will make a difference:</p> <ul> <li>Develop and maintain the "source of truth" data environment used by everyone at Klaviyo to measure the health of the business. </li><li>Work with petabyte scale databases optimized for business analytics </li><li>Develop data models that power predictive recommendations, marketing attribution, and financial forecasts to support the decision-making within the organization. </li><li>Collaborate on a regular basis with the following teams at Klaviyo: Finance, Go-To-Market, Engineering, Customer Success, Support, Product, Sales, and Marketing. </li><li>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. </li></ul> <p>Who You AreYou 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.</p> <ul> <li>2-5 years of data development experience in SQL and 1+ years of experience in object-oriented programming languages (i.e. Python) </li><li>Experience in database design, 3NF, dimensional modeling, or star schema. </li><li>Experience with Big Data technologies (Snowflake, Databricks/Spark, Trino) </li><li>1+ years of data modeling experience using dbt </li><li>Experience with building data integration / pipeline to support business operations using reverse ETL tools </li><li>Experience with reporting tools like Tableau/Looker/Thoughtspot </li><li>Comfortable with massive amounts of semi-structured data </li><li>Has knowledge of data engineering best practices (data discovery, data documentation, infrastructure development/deployment, and information security) </li><li>Masters degree in data Engineering or undergraduate degree and equivalent experience </li></ul> <p>#LI-Hybrid #LI-Boston #LI-CR1</p> <p>Massachusetts Applicants:</p> <p>It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.</p> <p>Our salary range reflects the cost of labor across various U.S. geographic markets. The range displayed below reflects the minimum and maximum target salaries for the position across all our US locations. The base salary offered for this position is determined by several factors, including the applicant's job-related skills, relevant experience, education or training, and work location.</p> <p>In addition to base salary, our total compensation package may include participation in the company's annual cash bonus plan, variable compensation (OTE) for sales and customer success roles, equity, sign-on payments, and a comprehensive range of health, welfare, and wellbeing benefits based on eligibility. Please visit Klaviyo Rewards to find out more about our Total Rewards package.</p> <p>Your recruiter can provide more details about the specific salary/OTE range for your preferred location during the hiring process.</p> <p>Base Pay Range For US Locations:</p> <p>$104,000-$156,000 USD</p> <p>Get to Know Klaviyo</p> <p>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.</p> <p>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.</p> <p>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.</p> <p>By clicking "Submit Application" you consent to Klaviyo processing your Personal Data in accordance with our Job Applicant Privacy Notice. If you do not wish for Klaviyo to process your Personal Data, please do not submit an application. You can find our Job Applicant Privacy Notice here and here (FR).</p>