Blockchain Data Wizard, Analyst or Scientist

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.

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

• 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
• Sybil Detection for Wormhole's Token Launch
• Powering Brevan Howard Digital's stablecoin industry reports
• Design chain level metrics (Fees, Activity…) for all chains

• 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