Software Engineer II - Data Warehousing

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. We love tackling tough engineering problems and look for Engineers who are passionate about building, owning, and scaling features and breaking through any obstacle or technical challenge in their way. We push each other to move out of our comfort zone, learn new technologies and work hard to ensure each day is better than the last. Klaviyo operates a real-time data platform written in Python and built for massive scale on Amazon Web Services (AWS). Engineers come to Klaviyo with experience in a variety of languages and from a number of disciplines. About the Team: The Data Warehousing Team is responsible for the majority of real-time analytical queries at Klaviyo. We process thousands of queries per second to power Klaviyo’s analytical reporting capabilities. How you'll make a difference: As a software engineer on this team, you will be responsible for designing, building, and maintaining systems to support core product areas in Klaviyo. You will work with a cross functional team to help refine feature specifications, write technical design documents, create system infrastructure, write high quality code, and operate large scale systems in production. You will also review other engineer’s designs and code to provide technical feedback and improvements as you grow your own skill set. Team Tech Stack Python ClickHouse Kafka ZooKeeper Django Redis Must Have: Highly skilled in using at least one modern programming language 5+ years of experience in a software engineering discipline Significant experience with backend, service oriented application development Experience with OLAP databases schema design normalization / denormalization trade-offs performance operations Able to communicate well Able to work with others on a team Able to learn continuously and adapt to a high growth environment Able to stick with and solve difficult problems Bachelor's degree in Computer Science or equivalent experience. Nice to have: Experience with distributed systems Experience performance tuning and scaling systems Experience with high volume data processing and storage systems Experience using Linux operating systems Massachusetts Applicants: 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. 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. 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. Your recruiter can provide more details about the specific salary/OTE range for your preferred location during the hiring process. Base Pay Range For US Locations: $116,000 $174,000 USD This role may require up to 10% travel for purposes such as new hire onboarding, client or partner work if applicable, team meetings, and industry events. Tr ... (truncated, view full listing at source)