Stop applying — get discovered by hiring agents.
| Job Position and Company | Posted | Location | Salary | Tags |
|---|---|---|---|---|
|
| ||||
CAIZđ Remote | $80k - $150k | |||
| $105k - $150k | ||||
ONINOđ Remote | $86k - $105k | |||
 ISO 9001 Certified | 400+ students | Learn more | by Metana | ||
| $84k - $118k | ||||
| $180k - $212k | ||||
| $96k - $117k | ||||
Nexođ BG | $76k - $87k | |||
| $39k - $45k | ||||
| $91k - $104k | ||||
Immutableđ AMER | $72k - $111k | |||
| $90k - $118k | ||||
InfStonesđ Texas | $87k - $87k | |||
| $90k - $125k | ||||
| $122k - $180k |
Overview
Step Finance is the front page of Solana, a portfolio manager and aggregator for all Dapps and smart contracts across the Solana ecosystem. Weâre seeking a ClickHouse Database Expert to supercharge our analytical data infrastructure. Youâll play a critical role in optimizing our ClickHouse environment to handle complex aggregations, high-speed ingestion, and lightning-fast queries that power our DeFi analytics platform. This is an exciting opportunity to join a core Solana DeFi team and work on cutting-edge database challenges in the decentralized finance space.
Youâll collaborate with a world-class team of crypto natives, leveraging your ClickHouse expertise to unlock new levels of performance and scalability for our portfolio aggregator and data analytics.
About Our Team
- A lean team of 13 based across multiple time zones
- Fully remote and location-agnostic
- Passionate about decentralizing finance
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.
Bonus Points If You HaveâŚ
- Experience with DeFi or blockchain data analytics (e.g., Solana, Ethereum).
- Familiarity with integrating ClickHouse with BI tools (e.g., Superset, Grafana) or visualization platforms.
- Typescript knowledge for occasionally getting your hands dirty and fixing/implementing code.
- Prior work with other analytical databases (e.g., Druid, Pinot, Snowflake).
Salary Expectations To be determined based on your experience and aptitude
Learn More About Us
- App: https://www.step.finance/
- Twitter: https://twitter.com/stepfinance_
- Discord: discord.gg/stepfinance
- Medium: https://stepfinance.medium.com/
To Apply
Contact us here on jobs.solana.com
What does a blockchain developer do?
A blockchain developer is a software developer who specializes in the development of applications that make use of blockchain technology
Some of the responsibilities of a blockchain developer may include:
- Designing and implementing smart contracts.
- Creating and maintaining the infrastructure that supports the blockchain network, and developing user-facing applications that make use of the blockchain.
- Additionally, a blockchain developer may also be responsible for researching and staying up-to-date with the latest developments in blockchain technology, in order to ensure that their applications are secure and efficient.