Blockchain Data Wizard, Analyst or Scientist

New York. Posted 52 months ago

The role

Blockchain Data Wizards transform raw, fragmented on-chain data into meaningful data models. You will reverse engineer DeFi protocols, index new blockchains, and design metrics to provide granular insights for institutions and developers.

What you will do

Transform messy on-chain data into unified, intuitive data models
Reverse engineer DeFi protocol mechanics and smart contract interactions
Extract data and transform it into clean, production-ready models using SQL/dbt
Index new blockchains and design schemas for reliable internal models
Design and create metrics like volumes, fees, TVL, and user activity
Filter out noise like wash trades, bots, and Sybil attacks

Required qualifications

SQL/dbt Mastery
Ability to write elegant, performant SQL transformations
Understanding of incremental models, macros, and building maintainable data pipelines at scale
Curiosity to find peculiarities in data
Product-minded approach to data design
Comfortable with ambiguity

Benefits

Medical, Dental, Vision, Life and AD&D insurance
US folks get 100% coverage for Gold plans, 80% for dependents
Meaningful early-stage equity
Stock option grant for every full-time employee
Flexible, trust-based paid time off
Policies meet or exceed local statutory vacation requirements in every country hired
Company sponsored 401(k) plan in US

Before you apply

All applicants have to answer this pop quiz: 'What is an Allium? What is your favorite Allium?'

About the company

Allium is building the system of record for onchain finance by ingesting, verifying, and standardizing data across 140+ blockchains. The company provides a neutral, canonical data layer for finance, accounting, risk, engineering, and research teams.