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 youre a close but not exact match with the description we hope youll still consider applying. Want to learn more about life at Klaviyo Visit 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 Klaviyos analytical reporting capabilities.

How youll 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 engineers 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
• Bachelors 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