thrill-labs - Data Warehouse and Infrastructure Engineer
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). • Bonus Points for (but could be developed on the job): • ClickHouse administration and advanced query tuning. • Looker administration and LookML modeling. • Experience with data quality frameworks and cross-checks. • Administration of Kafka, Kafka Connect, and Zookeeper clusters. • Knowledge of OLAP/DWH concepts (staging, marts, star/snowflake schemas, Kimball/layering). • Monitoring setup experience (Grafana, Prometheus, or similar). • Experience with infrastructure migrations and IaC automation. • End-to-end understanding of data pipelines and analytics modeling.
Responsibilities
• 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.
Apply in one click
Upload My Resume
Drop here or click to browse · Tap to choose · PDF, DOCX, DOC, RTF, TXT