Data Analyst (On-Chain)

Learning path available

Highly Remote

On-Chain Data Analysts extract insights from blockchain data to inform product decisions, track protocol health, and identify market trends. They work with tools like Dune Analytics, The Graph, and custom data pipelines to make sense of the transparent but complex world of on-chain data.

Explore learning path Browse Data Analyst jobs

Key Responsibilities

Build dashboards and reports to track protocol metrics, TVL, and user behavior
Analyze on-chain data to identify trends, anomalies, and growth opportunities
Create SQL queries and data models using Dune Analytics or similar platforms
Develop automated alerts and monitoring for protocol health metrics
Collaborate with product and engineering teams to inform roadmap decisions
Research competitor protocols and market dynamics through on-chain analysis

Hiring expectations

These describe experienced roles. Requirements vary by employer; use the learning path below to build toward them.

2+ years of data analysis experience with SQL and Python
Proficiency with blockchain data tools (Dune Analytics, Flipside, The Graph)
Understanding of DeFi protocols, token economics, and on-chain metrics
Experience with data visualization tools and dashboard creation
Strong analytical thinking and ability to communicate insights clearly

Skills & Technologies

SQL

Python

Dune Analytics

The Graph

Data Visualization

DeFi

Learn. Practice. Build.3 steps + a portfolio project

Courses & learning path

For analysts learning to turn blockchain activity into useful evidence.

Before you start

Comfort with spreadsheets, percentages and interpreting charts.
No prior blockchain querying experience required; start with SQL.

Already use SQL? Review joins and aggregation, then focus on blockchain tables, address-level data and metric definitions.

See what you’ll build

Build a SQL foundation
Practice selecting, filtering, joining and aggregating data.
SQLBoltFree
Interactive SQL lessons
Beginner · Interactive exercises
Self-paced practice
Open on SQLBolt: Interactive SQL lessons (opens in a new tab)
Access & course details: Interactive SQL lessons
Access
Practice in your browser
Language
English
Credential
No certificate listed
Reviewed
Sep 18, 2026
Put it into practice: Complete the query and aggregation lessons and explain how a join can double-count rows.
Query blockchain activity
Use DuneSQL and curated tables to explore activity across networks.
DuneFree
Create your first query
Beginner · Guide + SQL exercise
Self-paced practice
Open on Dune: Create your first query (opens in a new tab)
Access & course details: Create your first query
Access
Public guide; Dune account to save work
Language
English
Credential
No certificate listed
Reviewed
Sep 18, 2026
Put it into practice: Adapt the DEX volume query and document the date range, units and included chains.
Communicate the result
Turn query results into readable charts and a dashboard.
DuneFree
Create your first visualization
Beginner · Guide + dashboard exercise
Self-paced practice
Open on Dune: Create your first visualization (opens in a new tab)
Access & course details: Create your first visualization
Access
Public guide; platform usage limits may apply
Language
English
Credential
No certificate listed
Reviewed
Sep 18, 2026
Put it into practice: Create a chart with a clear title, units, source query and one limitation.

Your portfolio project

An onchain activity dashboard

Answer one focused question about a protocol or ecosystem with reproducible queries and a short analysis.

What to include

Saved SQL queries and a dashboard with metric definitions.
A short explanation of data coverage, exclusions and possible double-counting.
Three findings, separating observations from interpretations.

Be ready to explain why an address is not necessarily a person and how your conclusions change with the time window.

Explore Data Analyst jobs

Selected by gm.careers for relevance and practical learning. Levels reflect our suggested sequence. Listed course times come from providers; allow extra time for practice. Provider credentials are separate from professional experience.

Report an outdated resource