What You’ll Do

📍Design and optimize complex aggregations in ClickHouse materialized views to support real-time DeFi analytics. 📍Build and maintain high-speed data ingestion pipelines for streaming and batch data from Solana and other sources. 📍Perform query optimization to ensure low-latency access for analytical workloads. 📍Partner with developers to analyze query patterns, optimize SQL, and propose data denormalization or pre-aggregation strategies to accelerate analytical access. 📍Manage backup and restore processes for ClickHouse environments, ensuring data reliability and minimal downtime. 📍Monitor and tune ClickHouse clusters for performance, scalability, and fault tolerance. 📍Troubleshoot ingestion and query performance issues, delivering robust solutions under tight timelines. 📍Explore and implement advanced ClickHouse features like tiered storage, distributed joins, custom codecs, or dictionary tables to push the boundaries of our analytics capabilities. 📍Spend most of your (work)day solving database challenges… on your schedule!

What You Bring

📍Proven expertise with ClickHouse in a production environment, including materialized views and complex aggregations. 📍Strong experience with high-speed data ingestion (e.g., Kafka, REST APIs, or ETL pipelines) into ClickHouse. 📍Deep knowledge of query optimization and performance tuning for analytical databases. 📍Ability to collaborate with developers to refine queries and improve data models (e.g., denormalization, aggregation). 📍Hands-on experience with ClickHouse backup, restore, replication, and cluster management. 📍Comfort making technical decisions with minimal oversight. 📍Resonance with Step’s values (degen, passionate, crypto-loving). 📍Excellent communication skills and a team-oriented mindset.

Looking for your next challenge? The world of crypto offers exciting roles in blockchain development, web3 innovations, and remote opportunities.