Blockchain Data Wizard, Analyst or Scientist

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'll 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.

- 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/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.

- 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.

- Co-developing methodology to identify organic and meaningful stablecoin activity, powering Visa's Stablecoin Dashboard

- Reconstructing Bitcoin Ordinals data to power research work

- Powering Brevan Howard Digital's stablecoin industry reports

- Design chain level metrics (Fees, Activity..) for all chains