Company Description Vortix Data and AI Technology India Private Limited (Vortix.in) specializes in deploying and optimizing ClickHouse, a high-performance, real-time columnar database designed for large-scale analytics. The company delivers consulting, performance tuning, data migration, custom development, and training services to help organizations fully leverage ClickHouse for massive datasets and complex analytical workloads. Vortix.in focuses on enabling blazing-fast query performance, low latency, and high throughput, ensuring data platforms are effective and scalable. Its team brings deep expertise across industries, designing solutions that grow with evolving data needs and future infrastructure challenges.

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
Strong 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:

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