Website:
vortix.in
Job details:
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 efficient 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:
- 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.
