Data Warehouse Engineer, Infrastructure

This is a fully remote position, open to applicants in Europe.

📋 Description

• Optimize ClickHouse queries for improved performance and efficiency.

• Manage ClickHouse configurations, tables, and data structures (serving as ClickHouse DBA).

• Develop and sustain data models and dashboards using Looker.

• Establish and oversee data quality checks and validations.

• Conduct infrastructure tasks related to Kafka, Zookeeper, ClickHouse, and the Kubernetes ecosystem.

⛳️ Requirements

• Practical experience in optimizing queries within relational databases.

• Demonstrated proficiency in database administration.

• Advanced SQL skills, including the use of window functions and analytical queries.

• Familiarity with Kafka concepts such as topics, partitions, offsets, and delivery guarantees.

• Basic understanding of Linux CLI and shell scripting for troubleshooting and automation purposes.

• Working knowledge of Kubernetes.

• Experience with Docker and containerization technologies.

• Familiarity with infrastructure as code tools (Terraform, Pulumi, Ansible, or similar).

• Comprehension of data modeling principles and data lifecycle management.

• Proficient in Git and version control practices.

• Experience in implementing backup and restore procedures for extensive datasets.

• Strong command of English (minimum B2 level equivalent).

🏝️ Benefits

• Flexible work arrangements