software engineer, clickhouse

At Shopify, Staff Infrastructure Engineers use their expertise and passion to multiply the overall output of their development team. As a technical leader, you’ll help drive your team’s vision to its implementation. You and the team will design and build technically innovative solutions that empower all teams at Shopify to build powerful and resilient distributed cloud software. Merchants that depend on Shopify for a highly scalable, performant, and reliable platform benefit directly from the work you do. You will maintain a high bar for quality and lead and mentor other engineers. And of course, you’ll be hands-on in the code and contribute technically.

As an experienced infrastructure technical leader, we need your help to both start new teams and expand and grow the technology of our existing teams. There are multiple positions available on a variety of teams and we will work with you as part of the interview process to identify which team best fits your interests, needs and experience.

The successful candidate for this position will be working on ClickHouse, both designing the Infrastructure and optimizing data pipelines, queries, and migrations. Experience with ClickHouse is preferred. 

Examples of the exciting work happening in Infrastructure/ClickHouse:

• Our new Reportify product heavily utilizes ClickHouse to provide low-latency access to merchant data
• ClickHouse area of expertise is being created within Shopify, designed to provide expert guidance to other internal teams
• ClickHouse powers our internal observability tooling

Qualifications

Experience and skills that are important for success in this role:

• Experience with creating and maintaining ClickHouse infrastructure
• Experience with the ClickHouse JDBC driver
• Creating, implementing and maintaining robust ClickHouse infrastructure
• Create and run complex DDL migrations to evolve the ClickHouse schema with no or minimal downtime and no data loss
• Optimize queries using ClickHouse best practices
• Work with other Shopify teams to consult on ClickHouse projects
• Experience with service discovery and service communication
• A proven track record of success in leading software development teams — strong technical mentorship is a must
• Deep experience building large scale, high throughput distributed systems and scaling web services, particularly those using and analyzing large amounts of data
• The ability to write high quality code in a high level programming language (e.g. Go, Ruby, Java)
• Experience with Site Reliability engineering/ DevOps practices.
• Experience leading the architecture and automation of infrastructure within a cloud environment.
• Experience deploying and monitoring a production system at scale in a cloud native environment.
• A track record of being a self-starter and a team player keen on mentoring others and growing your own skill set within a fast paced environment.
• Experience working on a remote or distributed engineering team.
• A commitment and drive for quality, technical excellence and results
• Building services and deploying them on top of Kubernetes and/or Google Cloud Platform
• Participating in an on call rotation and/or site reliability engineering (SRE) experience