What are the responsibilities and job description for the Click House Architect / Tech Lead / Subject Matter Expert position at Jobs via Dice?
Dice is the leading career destination for tech experts at every stage of their careers. Our client, ClifyX, is seeking the following. Apply via Dice today!
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
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.
- 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.