Data & Analytics

On-Chain Data Analyst

Extracts, cleans, and visualizes raw blockchain transaction data to provide actionable business and trading insights.

Level: MidMode: Low-code#SQL#Data#Dune Analytics

Next action

Build your Web3 proof-of-work. Start contributing and prepare for interviews based on real scenarios.

Role Guide Progress

Lane Type

Data & Analytics

Seniority Level

Mid

Execution Mode

Low-code

1. Role Overview

Translates millions of complex crypto transaction data points into easy-to-understand visual dashboards. You help business teams understand transaction volumes, wallet behavior, and protocol economic health.

2. Daily Work

What you will actually do most weeks

Writing complex SQL queries to extract data from blockchains (EVM, Solana, etc.)

Building and updating interactive dashboards on platforms like Dune Analytics or Flipside Crypto

Analyzing money flows to detect sybil attacks, airdrop farmers, or whale activity

Presenting monthly performance reports for management teams and DAO communities

Expected Outputs & Deliverables

Public dashboards on Dune Analytics / Flipside Crypto

Market intelligence reports and tokenomics health analysis

Wallet address lists for filtering airdrop/reward programs

3. Skills & Tools

Must-Have Skills

Intermediate to advanced SQL (especially for relational databases / BigQuery)

Deep understanding of blockchain transaction structures (blocks, receipts, event logs, topics)

Data visualization and data storytelling

Basic statistical analysis skills (Python/Pandas is a plus)

Ecosystem Tools

Dune AnalyticsFlipside CryptoNansen / Token TerminalSQL / Google BigQueryPython / Jupyter Notebook

4. Proof-of-Work & Prep

Actionable Proof-of-Work

Dune Analytics or Flipside Crypto profile with public dashboards featuring high stars/views

Analysis articles on Twitter/Substack breaking down on-chain metrics of a major event (e.g., DEX volume analysis post-airdrop)

Self-Study Prep

Learn SQL basics (SELECT, JOIN, GROUP BY, CTE, Window Functions)
Learn how smart contracts emit data through Event Logs and how to read ABIs
Create a free account on Dune Analytics and start forking popular dashboards to understand their query logic

5. Apply & Interview

Application Strategy

Build a custom analytics dashboard for the protocol you want to apply to (e.g., daily active user retention analysis), share it on X tagging their team

Attach your best Dune/Flipside profile link in your CV

Interview Prompts

"How do you write a query in Dune to calculate the historical Total Value Locked (TVL) of a Uniswap V3 pool?"

"Explain the difference between parsing data from function call transactions versus event log data (emit events)."

6. Guide Roadmap

Step 1

SQL & Database Mastery

Master advanced SQL query language for processing big data.

Step 2

On-Chain Data Anatomy

Understand how to read blocks, transactions, internal transactions, and event logs.

Step 3

Dashboard Portfolio Creation

Build 3 specific analytics dashboards (e.g., DEX volume, NFT floor tracking, DAO treasury).

Step 4

Analyst Role Application

Apply with a dashboard portfolio that directly proves your analytical skills.