Why are you interested in joining CoinGecko? Where do you see yourself contributing best in the team?✱

Share with us a technical project from work. How did you come up with the idea? What was the biggest challenge you faced and how did you overcome it? What is the outcome of the project?✱

In CoinGecko, we believe in continuous learning. Tell us about a recent skill you have developed either on or off work, and how you approached the process.✱

Describe a solution you integrated into your work production stack. Tell us how you evaluated the solution and convinced your team to adopt this.✱

A data analyst complains that a query on last month's transaction data (500M rows) is timing out after 10 minutes. List 3 optimization techniques you'd implement, in order of priority.✱

Using Dune Analytics (dune.com), create a simple dashboard or query that shows the top 10 tokens by trading volume on Ethereum DEXs over the past 7 days. Share the Dune query link and explain in 2-3 sentences what tables you used and any data transformations applied.✱