Data Warehouse Engineer, Infrastructure

Role Overview

• Tune ClickHouse queries for performance and efficiency.
• Administer ClickHouse settings, tables, and data structures (act as ClickHouse DBA).
• Create and maintain data models and dashboards in Looker.
• Implement and monitor data quality checks and validations.
• Perform infrastructure work on Kafka, Zookeeper, ClickHouse, and the Kubernetes stack.

Requirements

• Hands-on experience tuning queries in relational databases.
• Proven database administration experience.
• Strong SQL, including window functions and analytical queries.
• Working knowledge of Kafka: topics, partitions, offsets, and delivery guarantees.
• Familiarity with Linux CLI and shell scripting for troubleshooting and automation.
• Working knowledge of Kubernetes.
• Experience with Docker and containerized environments.
• Experience with infrastructure as code (Terraform, Pulumi, Ansible, or equivalent).
• Understanding of data modeling concepts and data lifecycle management.
• Proficiency with Git and version control workflows.
• Experience implementing backup/restore strategies for large datasets.
• Good command of English (at least B2 equivalent).

Tech Stack

• Ansible
• Docker
• Kafka
• Kubernetes
• Linux
• Shell Scripting
• SQL
• Terraform
• Zookeeper

Benefits

• Flexible work arrangements