Company Description Vortix Data and AI Technology India Private Limited (Vortix.in) specializes in leveraging ClickHouse, a high-performance, real-time columnar database designed for large-scale analytics. The company delivers solutions that help organizations manage petabytes of data, achieve extremely fast query performance, and optimize data infrastructure. Vortix.in provides consulting on architecture, implementation, and optimization, along with performance tuning, data migration, custom development, and training. Its team offers deep ClickHouse expertise across industries and focuses on scalable, efficient, and low-latency data processing solutions that prepare businesses for future growth.

Key Responsibilities
Design and implement scalable data architectures using ClickHouse for analytical workloads
Build high-performance ingestion pipelines for structured and semi-structured data
Optimize ClickHouse schemas (partitioning, indexing, primary keys, TTLs) for performance and cost
Develop complex SQL queries for large-scale analytics and reporting use cases




Enable real-time and near real-time analytics using streaming and batch ingestion patterns
Work with stakeholders to model data for observability, product analytics, and business intelligence
Perform query tuning, performance troubleshooting, and capacity planning
Ensure data reliability, governance, and lifecycle management

Required Skills & Experience
Robust expertise in SQL and analytical query optimization
Hands-on experience with ClickHouse (data modeling, engine selection, MergeTree family)
Solid understanding of columnar storage, compression, and distributed systems
Experience designing data warehouses / lakehouse architectures
Strong programming skills in Python, Scala, or similar
Experience with distributed data processing frameworks (Apache Spark preferred)
Familiarity with ingestion tools and pipelines (Kafka, batch ingestion, CDC pipelines)
Exposure to cloud platforms such as:
Microsoft Azure OR

📌 Clickhouse Consultant (India)
🏢 Vortix Data and AI Technology India Private
📍 India