Architect and optimize multi‑TB ClickHouse/OLAP databases for speed, reliability, and scalability. Integrate with analytics dashboards and AI pipelines at Kognitive Networks.

About the Company

Kognitive Networks is a forward‑thinking technology firm specializing in building high‑performance data infrastructure and analytical platforms. The company focuses on enabling real‑time insights through large‑scale OLAP/vector databases, working closely with engineering teams to optimize data pipelines, integrate with AI/ML workflows, and deliver reliable analytics dashboards. With a strong emphasis on speed, scalability, and mentorship, Kognitive Networks fosters a hybrid, flexible work environment that encourages continuous learning and innovation.

Role Overview

We are looking for a ClickHouse Pro Engineer with 3+ years of experience to architect, implement, and optimize large‑scale OLAP/vector databases at Kognitive Networks. In this role, you will design and tune multi‑terabyte ClickHouse (or similar OLAP/vector DB systems like Druid, DuckDB) for speed, reliability, and scalability. Your work will directly integrate with analytics dashboards and AI pipelines, shaping how data flows across our product stack. Beyond hands‑on engineering, you will mentor engineers, simplify complex technical concepts, and drive performance improvements end‑to‑end.

Key Responsibilities

• Architecture & Design: Design and implement scalable, high‑performance OLAP/vector database solutions (ClickHouse, Druid, DuckDB) capable of handling multi‑terabyte workloads.
• Performance Tuning: Optimize query performance, indexing, partitioning, and materialized views to achieve sub‑second analytical queries and efficient data ingestion.
• Integration & Pipelines: Build and maintain data pipelines that feed into analytics dashboards and AI/ML pipelines, ensuring data freshness, accuracy, and low latency.
• Mentorship & Knowledge Sharing: Guide junior engineers in database internals, query optimization, and best practices. Conduct code reviews, write documentation, and present complex topics in an accessible manner.
• Monitoring & Reliability: Implement robust monitoring, alerting, and disaster recovery strategies to ensure 99.9%+ uptime and data integrity for critical analytical workloads.
• Collaboration: Work closely with product, data science, and DevOps teams to align database infrastructure with business requirements and upcoming feature roadmaps.

Tech Stack

• Primary Database: ClickHouse
• Similar OLAP/Vector DBs: Druid, DuckDB
• Data Pipeline & Integration: Apache Kafka (implied for streaming), ETL tools, Python/Java for scripting and integration
• Cloud & Infrastructure: Likely AWS/GCP/Azure (implied from scale and hybrid model)
• Analytics & Visualization: Integration with dashboards (e.g., Grafana, Superset) and AI/ML frameworks (e.g., TensorFlow, PyTorch for vector embeddings)
• DevOps & CI/CD: Docker, Kubernetes (implied for containerization and orchestration)

Salary

₹1,20,000 - ₹2,50,000 per month

Job Type

Full-time

3+ years of experience with ClickHouse or comparable OLAP/vector databases (Druid, DuckDB). Strong understanding of database architecture, indexing, partitioning, and distributed query execution. Proficiency in SQL and performance tuning for analytical workloads. Experience with data pipeline tools (Kafka, ETL frameworks) and cloud platforms (AWS/GCP/Azure). Familiarity with containerization (Docker, Kubernetes) and monitoring solutions. Excellent communication and mentorship skills. Ability to simplify complex technical concepts for cross‑functional audiences.

Group health insurance, flexible working hours, and a hybrid work model.