Hybrid Software Engineer- ClickHouse Software Engineer- ClickHouse with verification

About ShopifyOpportunity is not evenly distributed. Shopify puts independence within reach for anyone with a dream to start a business. We propel entrepreneurs and enterprises to scale the heights of their potential. Since 2006, we’ve grown to over 8,300 employees and generated over $1 trillion in sales for millions of merchants in 175 countries.This is life-defining work that directly impacts people’s lives as much as it transforms your own. This is putting the power of the few in the hands of the many, is a future with more voices rather than fewer, and is creating more choices instead of an elite option.About YouMoving at our pace brings a lot of change, complexity, and ambiguity—and a little bit of chaos. Shopifolk thrive on that and are comfortable being uncomfortable. That means Shopify is not the right place for everyone.Before you apply, consider if you can:

• Care deeply about what you do and about making commerce better for everyone
• Excel by seeking professional and personal hypergrowth
• Keep up with an unrelenting pace (the week, not the quarter)
• Be resilient and resourceful in face of ambiguity and thrive on (rather than endure) change
• Bring critical thought and opinion
• Embrace differences and disagreement to get shit done and move forward
• Work digital-first for your daily work

About The RoleAt 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

QualificationsExperience 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