Blockchain Data Wizard, Analyst or Scientist

Theory Ventures; San Francisco (CA); On-site; USD 120,000 - 150,000; Full time

Benefits offered by this job

Medical, Dental, Vision, Life and AD&D insurance

Equity options

Flexible paid time off

Retirement 401(k) plan

Job summary

Theory Ventures is seeking a Blockchain Data Wizard to transform fragmented on-chain data into meaningful data models that empower the world's largest crypto applications. This role involves deep diving into blockchain mechanics and crafting data products that institutions rely on.

Successful candidates will have SQL and dbt mastery, along with curiosity and the ability to navigate ambiguity. The position offers meaningful equity, comprehensive health insurance, and flexible paid time off.

Qualifications

• Strong proficiency in SQL and dbt for data transformations.
• Ability to work with ambiguous data environments and protocols.
• Experience in designing and building data products.

Responsibilities

• Create meaningful data abstractions from fragmented on-chain data.
• Reverse engineer DeFi protocol mechanics to extract useful insights.
• Index new blockchains and ensure accurate data capture.
• Design metrics that provide reliable insights for the industry.

Skills

SQL

Data Engineering

Data Products Design

Protocol Research

Data Analysis

Tools

dbt

Job description

About the role

At Allium, Blockchain Data Wizards are the data architects who transform raw, fragmented on‑chain data into elegant, meaningful abstractions that power the world's largest crypto applications.

You will be equal parts detective, data engineer, and protocol researcher—diving deep into blockchain internals, reverse engineering DeFi protocols, and crafting data models that institutions and developers rely on.

What you will do

• Creating Meaningful Data Abstractions Transform messy on‑chain data into unified, intuitive data models (e.g. dex.trades, lending.liquidations) that work across verticals and protocols, providing users with granular, reliable insights.

• Reverse Engineer DeFi Protocol Mechanics Dive deep into the mechanics of new DeFi protocols, dissect smart contract interactions and on‑chain events, extract the data that matters, and transform it into clean, production‑ready models using SQL and dbt.

• Indexing New Blockchains Dive into a blockchain’s raw data structures, ensure complete and accurate data capture, and design schemas that translate native blockchain data into reliable internal models, becoming the trusted source of truth for that ecosystem.

• Building Metrics & Filtering Noise Design and create metrics people can actually use – volumes, fees, TVL, and user activity – and filter out noise like wash trades, bots, and Sybil attacks. Make it easy for the industry to see what’s real and what matters.

Qualities

• Sherlock & Enola Holmes-Level Curiosity You find peculiarities in data that others miss. You question assumptions, dig deeper when something looks off, and help the industry redefine narratives with evidence‑based insights.

• Product-Minded Data Design You don't just build tables—you design data products. You think about query patterns, performance, documentation, and how end users will interact with your models.

• Comfortable with Ambiguity New blockchains and protocols have sparse documentation. You thrive when you need to figure things out yourself through exploration and experimentation.

• SQL & dbt Mastery You can write elegant, performant SQL transformations that process large volumes of data. You understand incremental models, macros, and how to build maintainable data pipelines at scale.

Allium's Data Wizards in Action

• Co-developing methodology to identify organic and meaningful stablecoin activity, powering Visa's Stablecoin Dashboard
• Reconstructing Bitcoin Ordinals data to power research work
• Sybil Detection for Wormhole's Token Launch
• Powering Brevan Howard Digital's stablecoin industry reports
• Design chain level metrics (Fees, Activity…) for all chains

Administrative Benefits

• Medical, Dental, Vision, Life and AD&D insurance - US folks get 100% coverage for Gold plans, 80% for dependents
• Ownership - Meaningful early‑stage equity. Every full‑time employee receives a stock option grant so you can share directly in Allium's upside
• Time off - Flexible, trust‑based paid time off. We encourage people to take the rest they need. In every country we hire, our policies meet or exceed local statutory vacation requirements
• Retirement - Company sponsored 401(k) plan in US so you can save pre‑tax for the long term