What are the responsibilities and job description for the Click House Architect / Tech Lead / Subject Matter Expert position at ClifyX?
Job Title: ClickHouse Architect / Tech Lead / Subject Matter Expert
Location: Bentonville, AR or any Infosys HUB office (3 days Hybrid)
Employment Type: Contract
Job Summary
We are seeking a highly skilled ClickHouse Architect / Tech Lead / SME to join a large-scale data and analytics transformation initiative supporting Walmart. The ideal candidate will possess deep expertise in ClickHouse database architecture, performance optimization, large-scale data processing, and real-time analytics solutions. This role will be responsible for designing, implementing, and optimizing high-performance analytical data platforms that support business-critical reporting and decision-making.
Key Responsibilities
- Design, architect, and implement scalable ClickHouse database solutions for enterprise-grade analytics platforms.
- Lead the migration and modernization of data workloads from traditional databases and data warehouses to ClickHouse.
- Optimize ClickHouse clusters for high-volume data ingestion, query performance, and storage efficiency.
- Develop data modeling strategies including partitioning, indexing, sharding, replication, and compression techniques.
- Collaborate with data engineering, analytics, and business teams to understand reporting and analytical requirements.
- Troubleshoot complex database performance issues and recommend best practices for scalability and reliability.
- Design and implement real-time and near real-time analytics solutions.
- Establish database governance, security, monitoring, backup, and disaster recovery strategies.
- Provide technical leadership and mentorship to data engineers and developers.
- Create architecture documentation, operational runbooks, and technical design specifications.
- Work closely with cloud and DevOps teams to automate deployments and operational processes.
- Participate in code reviews, architecture reviews, and production support activities.
Required Qualifications
- 10 years of overall experience in Data Engineering, Database Architecture, or Big Data technologies.
- 3 years of hands-on experience with ClickHouse database implementation and administration.
- Strong expertise in ClickHouse architecture, cluster management, replication, sharding, partitioning, and performance tuning.
- Experience designing and supporting large-scale analytical platforms handling billions of records.
- Strong SQL skills with expertise in query optimization and analytical workloads.
- Experience integrating ClickHouse with ETL/ELT frameworks and data pipelines.
- Hands-on experience with Linux environments and database administration.
- Experience working with distributed systems and high-volume data processing environments.