On-Chain Data Analyst

STEVEN
LIEW

Turning raw blockchain data into decisions that move capital.

// Open to full-time · on-chain analytics · data engineering · Web3

Steven Liew — On-Chain Data Analyst
OPEN TO WORK

About

Turning raw data into tactical intelligence

For me, analytics is less about making pretty charts and more about uncovering where the real alpha lives.

I specialize in transforming raw blockchain data into tactical intelligence. Whether it's tracking smart money flows or identifying protocol anomalies, my work is built for operators who need high-signal insights in real-time.

1TB+Data Points Analyzed
50+Dashboards Built
100+Protocols Tracked
10K+On-Chain Queries

Tech Stack

Extraction

The GraphSQLDune AnalyticsFlipsideBlockscout APIs

Processing

PythonNode.jsTypeScriptWeb3 Libraries

Visualization

ReactTableauDune DashboardsLooker Studio

Education

B.Sc. (Hons) in Computer Science (Specialism in Data Analytics)

Asia Pacific University (APU), Petaling Jaya, Malaysia

Second Class Honours, First Division

Data Mining · Statistical Analysis · Database Management · Machine Learning | SAS Joint Certificate in Computer Science and Data Analytics

2018 – 2021

Experience

Where I've worked

Data Analyst (Marketing & Product)

Bedrock·Full-time·Petaling Jaya, Malaysia
Feb 2024 – Dec 2025
  • SQL & BI Dashboards: Built custom SQL queries on Dune Analytics to visualize product health metrics like TVL, volume, and user retention for executive decision-making.
  • Python Automation: Developed Python scripts using blockchain APIs to automate tracking of whale wallet activity and cross-chain user flows.
  • Market Intelligence: Conducted deep-dive analysis on competitor protocols and multi-chain ecosystems to identify high-value partnership opportunities.
  • Retention & Lifecycle Analytics: Analyzed user cohort behavior and "stickiness" metrics to identify drop-off points in the product funnel, leading to targeted re-engagement strategies.
  • Growth Analytics: Correlated on-chain transaction data with social sentiment (X/Discord) to optimize marketing spend and increase platform traffic.
SQLDune AnalyticsPythonBlockchain APIsData Visualization

Data Analyst / Operations Specialist

ZorixChange·Full-time·Malaysia
Apr 2023 – 2024
  • Quantitative Vetting: Spearheaded a token listing framework using on-chain forensics to audit project liquidity and technical health.
  • Predictive Analysis: Leveraged user traffic and on-chain metrics to identify undervalued assets, securing early listings that drove volume.
  • Data-Driven Ops: Directed design and operations teams by aligning visual campaigns with data-backed user engagement metrics.
  • Strategic Reporting: Automated weekly reports on SEO performance and market volatility to guide senior management decisions.
SQLOn-chain ForensicsPythonSEO AnalysisDeFi Protocols

Skills

Full-stack data pipeline

From raw on-chain events to production dashboards — every layer of the analytics stack.

EXTRACTION

Data Sources & APIs

Dune Analytics
Primary tool
SQL
3+ yrs
The Graph
Subgraphs
Flipside
Cross-chain
Blockscout API
EVM chains

PROCESSING

Data Processing & Analysis

Python
3+ yrs
Pandas / Polars
Data wrangling
TypeScript
2+ yrs
Node.js
Backend scripts
SQL Engines
Advanced queries

VISUALIZATION

Dashboards & Visualization

Dune Dashboards
Primary output
React
2+ yrs
Looker Studio
BI reporting
Tableau
Enterprise BI
Real-time Charts
Live data
3 pipeline stages — 15 tools loadedSystem running optimally

Projects

Selected work

Preview of Bedrock uniBTC TVL Tracker

Bedrock uniBTC TVL Tracker

5+ Chains tracked20+ Metrics surfaced

Built a cross-chain TVL dashboard for Bedrock Protocol tracking uniBTC deployment across Ethereum, BNB Chain and beyond — giving the team real-time protocol growth visibility.

SQLDune AnalyticsMulti-chainData Visualization
Preview of Binance Alpha BR Token Campaign

Binance Alpha BR Token Campaign

10+ Metrics tracked

Delivered real-time campaign analytics for the Binance Alpha BR token trading campaign — measuring volume, unique traders, and participation rates across the campaign window.

SQLDune AnalyticsDeFi AnalyticsCampaign Tracking
Preview of BR Token Team LP Overview

BR Token Team LP Overview

Created a transparency dashboard for BR Token team LP positions — giving the community and team real-time visibility into liquidity health and token distribution.

SQLDune AnalyticsDeFi AnalyticsLP Monitoring
Preview of uniBTC Retention on Ethereum

uniBTC Retention on Ethereum

Surfaced user retention patterns for uniBTC on Ethereum — tracking cohort behaviour and protocol stickiness for the Bedrock core team.

SQLDune AnalyticsCohort AnalysisEthereum
Preview of uniBTC Flow Dashboard

uniBTC Flow Dashboard

Mapped the full flow of uniBTC on Ethereum — tracking third-party integrations, contract interactions and TVL attribution to each integration partner.

SQLDune AnalyticsProtocol AnalyticsEthereum

Currently

What I'm building now

Available for:Full-timeContractFreelanceAdvisory

Latest project

Cross-chain DeFi Intelligence Suite

In progress

Building a unified analytics layer that aggregates protocol-level signals across Ethereum, Arbitrum and Base — turning raw event logs into structured alpha.

Learning

ZK Proofs & Data Availability Layers

Ongoing

Going deeper into zkEVM data structures and how DA layers like EigenDA and Celestia change the on-chain analytics landscape.

Follow my open-source work and contribution activity on GitHub
GitHub Profile

Contact

Let's connect

Have a data challenge or need on-chain intelligence? I'm always open to interesting conversations and new collaborations.