Every transaction on a public blockchain is permanently recorded and freely accessible. This creates a dataset unlike anything in traditional finance or tech — billions of transactions, visible to anyone, updating in real time. On-chain data analysts are the people who turn this raw data into actionable intelligence, and the demand for this skill set has grown enormously as protocols, funds, and institutions need people who can actually read the blockchain.
This isn't just "SQL with extra steps." On-chain analysis requires a unique combination of technical skill, protocol knowledge, and financial intuition. Here's how to build a career in it.
What On-Chain Data Analysts Actually Do
The role varies depending on where you work, but the core work falls into several categories:
Protocol Analytics
Working directly for a DeFi protocol or L2, you'll track and analyze:
- Usage metrics — Daily active users, transaction volume, TVL trends, retention rates
- Revenue and fee analysis — How much the protocol earns, where revenue comes from, how it compares to competitors
- Governance participation — Voting patterns, delegate behavior, proposal outcomes
- Liquidity dynamics — Pool depth, impermanent loss, LP behavior, capital efficiency
This data directly informs product decisions. When Uniswap decides whether to deploy on a new chain, they're looking at on-chain data about developer activity, user volume, and DeFi composability on that chain.
Investment and Research
At crypto funds, market makers, and research firms, analysts focus on:
- Token economics modeling — Emission schedules, unlock events, treasury analysis
- Whale tracking — Monitoring large wallet movements, exchange inflows/outflows, accumulation patterns
- Protocol comparison — Benchmarking competing protocols on standardized metrics
- Risk assessment — Identifying concentration risk, liquidity fragility, or governance capture
Security and Compliance
A growing segment of on-chain analysis focuses on:
- Transaction monitoring — Tracking funds through DeFi protocols for compliance purposes
- Exploit forensics — Tracing stolen funds after hacks, analyzing attack patterns
- Sanctions screening — Identifying interactions with sanctioned addresses (OFAC lists)
- AML/KYT — Know Your Transaction analysis for exchanges and institutional platforms
The security and compliance side of on-chain analysis is growing fastest, driven by institutional adoption and regulatory requirements. Companies like Chainalysis, Elliptic, and TRM Labs have built entire businesses around this.
Tools of the Trade
Dune Analytics
Dune is the most widely used platform for on-chain analysis, and for good reason. It provides a SQL-based interface to decoded blockchain data across Ethereum, Polygon, Arbitrum, Optimism, Base, Solana, and dozens of other chains.
What makes Dune powerful:
- Decoded tables — Raw blockchain data is decoded into human-readable tables (e.g.,
uniswap_v3_ethereum.Pair_evt_Swapinstead of raw event logs) - Community dashboards — Thousands of public dashboards you can study, fork, and learn from
- Visualization tools — Built-in charting that turns query results into dashboards
- Spellbook — A community-maintained repository of curated data models (like dbt for blockchain data)
Getting started: Fork existing dashboards, modify the queries, and build on them. Dune's community is exceptionally open — the best analysts publish their queries publicly.
Flipside Crypto
Flipside takes a slightly different approach, offering pre-built data models that are more opinionated but often easier to work with than raw Dune tables.
Key differences from Dune:
- More structured data models with better labeling
- Incentive program that pays analysts for creating valuable dashboards
- Strong Solana, Cosmos, and cross-chain data coverage
- Python SDK for programmatic access to data
The Graph
The Graph is a decentralized indexing protocol that lets you query blockchain data through GraphQL APIs (subgraphs). It's less of an analysis platform and more of a data infrastructure tool.
When you'd use The Graph:
- Building real-time data feeds for applications
- Querying specific protocol events efficiently
- Creating custom indexers for protocols that Dune doesn't decode yet
- Building data pipelines that need programmatic access
Nansen
Nansen is a premium analytics platform focused on wallet labeling and "smart money" tracking.
Key features:
- Millions of labeled wallets (VC funds, whale traders, protocol treasuries, exchange wallets)
- "Smart Money" dashboards that track what sophisticated actors are doing
- Token God Mode — comprehensive token analytics
- NFT analytics and holder analysis
Nansen is more of a product analytics platform than a raw data tool. It's particularly useful for investment research and market intelligence.
Other Essential Tools
- Arkham Intelligence — Wallet labeling and entity identification, strong investigative features
- DefiLlama — The standard for TVL and protocol comparison data, completely free and open-source
- Token Terminal — Financial metrics for protocols (P/E ratios, revenue, earnings)
- Etherscan / Blockscout — Block explorers for transaction-level investigation
- Tenderly — Transaction simulation and debugging, useful for understanding complex DeFi interactions
You don't need to master every tool. Start with Dune — it's free, has the largest community, and the SQL skills transfer everywhere. Add other tools as your work demands them.
Essential Skills
SQL (Non-Negotiable)
SQL is the foundation of on-chain analysis. You need to be comfortable with:
- Joins and aggregations — Combining data across multiple tables (transactions, events, traces)
- Window functions — Time-series analysis, running totals, rolling averages. These are used constantly in protocol metrics
- CTEs (Common Table Expressions) — Building complex queries in readable, maintainable stages
- Date/time manipulation — Bucketing data by hour, day, week. Blockchain timestamps require careful handling
- Performance optimization — On-chain datasets are massive. Writing efficient queries that don't time out is a skill in itself
Practical example: A simple query to track daily active users on Uniswap involves joining the swap events table with timestamp functions, deduplicating wallet addresses per day, and aggregating across multiple pool contracts. This requires competence in all of the above.
Python
Python extends what you can do beyond SQL:
- pandas and polars — Data manipulation and analysis for datasets exported from Dune or pulled via APIs
- matplotlib, plotly, seaborn — Visualization beyond what Dune's built-in charts offer
- Web3.py — Direct blockchain interaction for custom data collection
- Jupyter notebooks — The standard environment for exploratory analysis
- APIs — Pulling data from Dune, Flipside, CoinGecko, DefiLlama, and other sources programmatically
You don't need to be a software engineer, but you need enough Python to automate data collection, clean messy datasets, and create polished visualizations.
Understanding DeFi Protocols
Technical skills without protocol knowledge is like having a telescope without knowing where to point it. You need to understand:
- AMM mechanics — How Uniswap, Curve, and Balancer work under the hood. What concentrated liquidity means for LP economics
- Lending protocols — How Aave and Compound calculate interest rates, what liquidation mechanisms look like in the data
- Derivatives — How perpetual futures, options protocols, and synthetic assets generate on-chain data
- Bridges and L2s — How cross-chain messages appear in the data, how to track value flowing between chains
- Token standards — ERC-20, ERC-721, ERC-1155, and how transfers and approvals show up in event logs
The single biggest mistake new on-chain analysts make is querying data without understanding the protocol generating it. If you don't know what a Uniswap V3 tick range is, you can't correctly analyze liquidity concentration data. Protocol knowledge always comes first.
Types of On-Chain Analysis
Protocol Health Metrics
The bread and butter of on-chain analysis. Key metrics include:
- Total Value Locked (TVL) — How much capital is deposited in a protocol
- Daily/Monthly Active Users — Unique wallets interacting with the protocol
- Transaction Volume — Dollar value of activity flowing through the protocol
- Revenue — Fees generated and how they're distributed (to the protocol, to LPs, to token holders)
- User Retention — What percentage of users return after their first interaction
Whale and Smart Money Tracking
Following the money is one of the most valuable applications of on-chain analysis:
- Exchange flows — Large inflows to exchanges often signal upcoming selling pressure
- Accumulation patterns — Identifying wallets steadily acquiring a specific token
- VC wallet monitoring — Tracking token unlocks and whether VCs are selling, holding, or staking
- MEV analysis — Understanding how searchers and builders extract value from transaction ordering
Token Economics Analysis
Understanding the economic model of a token:
- Supply dynamics — Circulating vs total supply, inflation rates, burn mechanisms
- Distribution analysis — How concentrated token holdings are (Gini coefficient, top holder percentages)
- Unlock schedules — Mapping upcoming token unlocks against historical price impact
- Governance token utility — Analyzing actual usage of governance tokens beyond speculation
Forensics and Investigations
This specialized area involves:
- Hack tracing — Following stolen funds through mixers, bridges, and DEXs
- Wash trading detection — Identifying artificial volume on NFT marketplaces or DEXs
- Sybil analysis — Detecting when one entity controls many wallets (relevant for airdrops and governance)
- Sanctions compliance — Screening transactions against sanctioned address lists
Building a Portfolio
A strong portfolio is the most important thing for landing an on-chain analyst role. Unlike traditional data science where portfolio projects are hypothetical, on-chain analysis portfolios use real, public data — which means they're immediately verifiable and impressive.
Publish Dune Dashboards
Create 3-5 polished Dune dashboards that demonstrate different skills:
- Protocol deep-dive — Comprehensive analytics for a specific protocol (TVL, volume, users, revenue, retention). Pick a protocol you find interesting and build the definitive dashboard for it
- Market analysis — A dashboard tracking a specific sector (DEX market share, L2 transaction comparison, stablecoin flows)
- Investigation — Analyze a specific event (a major exploit, a large airdrop, a governance attack) and tell the story through data
- Custom metric — Create a novel metric that doesn't exist elsewhere. This shows creative thinking, not just query ability
Write Analysis Threads
Turn your dashboards into narratives. The best on-chain analysts don't just produce charts — they tell stories:
- Publish Twitter/X threads walking through your findings with clear visualizations
- Write on Mirror, Substack, or your own blog for longer-form analysis
- Contribute to research publications like Messari, The Block, or Delphi Digital
- Post your analysis in protocol Discord servers and governance forums
The single most effective portfolio-building strategy: pick a popular protocol, build a comprehensive dashboard, write a detailed analysis thread, and tag the protocol's team. If the analysis is good, they'll share it — and that's instant visibility to exactly the people who hire on-chain analysts.
Contribute to Open Data
- Contribute to Dune's Spellbook (community data models)
- Build and maintain subgraphs on The Graph for protocols that need better indexing
- Create open datasets that other analysts can use
- Contribute to DefiLlama adapters for protocols that aren't yet tracked
Salary Range and Career Progression
Compensation: $100k-$160k Base
On-chain data analyst salaries in 2026:
| Level | Base Salary (USD) | Total Comp (with tokens) |
|---|---|---|
| Junior Analyst (0-2 years) | $80k - $110k | $100k - $140k |
| Mid Analyst (2-4 years) | $110k - $140k | $140k - $200k |
| Senior Analyst (4+ years) | $140k - $175k | $200k - $280k |
| Lead / Head of Analytics | $170k - $220k | $250k - $350k+ |
Analysts at crypto-native funds and trading firms can earn significantly more through performance-based bonuses.
Career Progression
The career path for on-chain analysts branches in several directions:
- Protocol analytics lead — Managing analytics for a specific protocol, informing product and growth decisions
- Research analyst at a fund — Using on-chain data for investment decisions, often with performance-based comp
- Data engineering — Building the infrastructure (indexers, data pipelines, APIs) that powers analytics platforms
- Founding your own research firm — Several successful crypto research firms started as one analyst publishing great Dune dashboards
- Compliance and security — Specializing in forensics, AML, or security analysis at firms like Chainalysis
The Independent Path
Many top on-chain analysts work independently:
- Paid newsletters — Substack and Mirror publications with on-chain analysis can generate $5k-$50k/month
- Consulting — Protocols pay $5k-$20k for in-depth analytics audits and dashboard builds
- Research bounties — Platforms like Flipside pay analysts for creating valuable dashboards
- Grant funding — Protocol foundations fund analytics projects that benefit their ecosystem
Getting Started Today
If you're starting from zero, here's a 12-week plan:
Weeks 1-4: Foundations
- Complete a SQL course (Mode Analytics tutorial or SQLZoo)
- Create a Dune account and work through their official documentation
- Fork 10 existing dashboards and understand every query
- Read "How to DeFi" or equivalent to understand protocol mechanics
Weeks 5-8: Building
- Create your first original Dune dashboard
- Learn Python basics (focus on pandas and API interactions)
- Start following top analysts on Twitter (hildobby, 0xKofi, rchen8, momin_ahmad)
- Write your first analysis thread
Weeks 9-12: Establishing
- Build 2-3 portfolio-quality dashboards
- Contribute to Dune Spellbook
- Apply to junior analyst roles and research internships
- Engage with protocol analytics teams on Discord
The on-chain analyst community is remarkably open and collaborative. Most top analysts share their queries publicly and are willing to help newcomers who demonstrate genuine effort. Don't be afraid to ask questions — just make sure you've tried to figure it out yourself first.
Conclusion
On-chain data analysis is a career built on a genuinely unique advantage: public, permissionless access to the financial data of an entire industry. No other field gives a junior analyst the same quality and breadth of data that a Goldman Sachs quant works with — except in Web3, it's free and open to everyone.
The barriers to entry are skill-based, not credential-based. Nobody cares if you have a statistics degree from Stanford. They care whether your Dune dashboard accurately tracks protocol revenue, whether your analysis thread correctly identifies accumulation patterns, and whether you can tell a compelling story with data.
Start building dashboards today. The data is waiting.
Explore data analyst roles and salary benchmarks on gm.careers.