Software Engineer II - Data Warehousing
ExternalPrepare for this interview
EliteAI-generated questions, company research, and talking points tailored to this role
About the role
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
Requirements
- 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.
- 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.
- 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. Travel is coordinated in advance.
- Get to Know Klaviyo
- AI fluency at Klaviyo includes responsible use of AI (including privacy, security, bias awareness, and human-in-the-loop). We provide accommodations as needed.
- By participating in Klaviyo's interview process, you acknowledge that you have read, understood, and will adhere to our Guidelines for using AI in the Klaviyo interview Proces
Benefits
Additional Information
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.
Your Match
How well this role fits your profile.
Company Intel
What employees say
Worked at Klaviyo? Share your experience