Website:
vortix.in
Job details:
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
- 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:
- Microsoft Azure OR
- Google Cloud Platform
Preferred Qualifications
- Experience with real-time streaming tools (Kafka, Pub/Sub, Event Hubs)
- Exposure to observability stacks (logs, metrics, traces) using ClickHouse
- Experience with Databricks or Spark-based ecosystems
- Knowledge of infrastructure tuning (CPU, memory, storage optimization for OLAP systems)
- Contributions to performance benchmarking or large-scale data platform migrations
Soft Skills
- Strong analytical and problem-solving mindset
- Ability to work directly with clients and translate business needs into data solutions
- Excellent communication and consulting mindset
What Makes This Role Unique
- Work on high-scale analytical systems handling billions of records
- Opportunity to specialize in next-gen OLAP systems like ClickHouse
- Engage in performance engineering and cost optimization at scale
- Collaborate with global teams and cutting-edge use cases (observability, real-time analytics)
Click on Apply to know more.