Senior Consulting Engineer - AMER

ClickHouse is the open-source, real-time analytical database behind a lot of today's AI. More than 4,000 companies build on ClickHouse, including Anthropic, OpenAI, Tesla and Meta. As a Consulting Engineer, you're the hands-on engineer on our customers' most important projects. When a customer needs to migrate, integrate, or prove ClickHouse on a real workload, you work in the build alongside their engineers: you design it, build it, test it and hand it over. You'll work on a broad mix of projects for customers across the Americas, from moving large workloads off other databases to building new real-time analytics on ClickHouse. Each one is scoped with clear goals from the start, so you know what success looks like and can get stuck in. It's a fast way to build deep experience across lots of different data problems. The consulting function at ClickHouse is less than a year old, so you'll help shape how ClickHouse delivers this work as the team grows. Between projects you take cases alongside support engineers, which keeps you close to day-to-day support. WHAT YOU'LL DO - Turn customer goals into a scoped project with measurable success criteria, sizing and a timeline - Design a target architecture and prove it against the customer's own data: schema and engine design, capacity and sizing, proofs of concept - Do the build: implementation, pipelines and integrations, migration execution, tooling and automation - Measure it before it matters, with benchmarking, load and functional testing, then support the cutover - Tune what production reveals, then hand over with an engagement report and knowledge transfer, so the customer's team can run it without you - Take L1 to L3 cases alongside support engineers when you're between projects - Feed what you see in the field back to Product and Engineering, and turn your work into reference architectures, knowledge base articles and blog posts - Work in a constant feedback loop with the Pre-sales team to ensure that the demos and POCs they present are credible when you put them into production WHAT YOU'LL BRING - 5+ years delivering hands-on technical work for customers, whether your title was consultant, professional services, solutions architect, senior support, SRE or something else - Real depth in databases, whether analytical, transactional or relational - Hands-on SQL. You regularly write complex queries from scratch, and tune and debug them yourself - You've owned implementations, migrations or POCs for external customers from start to finish - Hands-on cloud experience (AWS, GCP and/or Azure) - You've deployed and run workloads on Kubernetes yourself - You've run distributed systems, such as distributed databases, in production - You give precise technical answers and explain them clearly - Fluent English NICE TO HAVE - Experience with ClickHouse - Migrating analytical workloads from systems such as PostgreSQL, Snowflake, BigQuery or Elastic - Terraform - Data pipelines and streaming, such as Kafka, Kinesis, Spark or Debezium - Python, Bash or Go - Involvement in open source, as a user, contributor or community member GOOD TO KNOW - This role is remote in North America, in a country where ClickHouse already hires - Travel to customer sites is part of the job, up to 35% of your time, depending on the project: some need none, others weekly visits - You'll join our Support Services team in the Americas, alongside Support Engineers and TAM Architects - You'll be part of the on-call rotation, about one week a quarter, with time off in lieu if you're paged at a weekend HOW WE HIRE - A 30-minute call with our recruiter - A conversation with the hiring manager - A take-home exercise, designed to take three to four hours, with three working days to complete it - A 90-minute technical interview with the team: you'll walk us through your take-home, then join a working session where you write and tune SQL live - A final conversation with our VP of Support Services - References, then an offer The working session is without AI tools, so make sure you're comfortable writing queries from scratch. Download open-source ClickHouse and practise: it's free, easy to install, and great preparation. PERKS - Flexible work environment - ClickHouse is a globally distributed company and remote-friendly. We currently operate in over 25 countries. - Healthcare - Employer contributions towards your healthcare. - Equity in the company - Every new team member who joins our company receives stock options. - Time off - Flexible time off in the US, generous entitlement in other countries. - A USD$500 Home office setup if you’re a remote employee. - Global Gatherings – We believe in the power of in-person connection and offer opportunities to engage with colleagues at company-wide offsites. CULTURE - WE ALL SHAPE IT As part of a rapidly scaling start-up, you will be instrumental in shaping our culture. Are you interested in finding out more about our culture? Learn more about our values here https://clickhouse.com/company/careers. Check out our blog posts https://clickhouse.com/blog or follow us on LinkedIn https://www.linkedin.com/company/clickhouseinc/life/0c1ee7f4-2129-488d-b413-e7f6270659fd/?viewAsMember=true to find out more about what’s happening at ClickHouse. EQUAL OPPORTUNITY & PRIVACY ClickHouse provides equal employment opportunities to all employees and applicants and prohibits discrimination and harassment of any type based on factors such as race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws. Please see here https://clickhouse.com/legal/applicant-privacy-notice for our Privacy Statement.