Allium
Blockchain Data Wizard, Analyst or Scientist
NEWNew York, Remote, San Francisco, ...Full-timeGlobal
RemoteRemote work position availableActivePosted within the last 30 days
Job Description
[AI-summarized by JobStash]
You will transform messy on-chain data into unified, intuitive data models that humans and machines can rely on. You will reverse engineer DeFi protocol mechanics and smart contract interactions, extracting the data that matters and converting it into production-ready models using SQL and dbt. You will index new blockchains, ensure complete and accurate data capture, and design schemas that translate native chain structures into reliable internal representations. You will design metrics (volumes, fees, TVL, activity), filter noise such as wash trades, bots, and Sybil attacks, and build performant, maintainable data pipelines at scale.
Requirements
- ●Mastery of SQL and dbt
- ●Experience reverse engineering smart contracts and DeFi protocols
- ●Experience designing data models and schemas for large-scale blockchain datasets
- ●Ability to operate with ambiguous or sparse protocol documentation
- ●Strong curiosity and analytical problem solving
Responsibilities
- ●Transform messy on-chain data into unified, intuitive data models
- ●Reverse engineer DeFi protocol mechanics and smart contract interactions into production-ready models using SQL and dbt
- ●Index new blockchains and design schemas to translate native blockchain data into internal models
- ●Design and create financial metrics such as volumes, fees, TVL, and user activity
- ●Filter out noise including wash trades, bots, and Sybil attacks
- ●Build performant, maintainable data pipelines and SQL transformations at scale
Benefits & Perks
- ●Medical, dental, vision, life and AD&D insurance (US folks get 100% coverage for Gold plans, 80% for dependents)
- ●Meaningful early-stage equity via stock option grants
- ●Flexible, trust-based paid time off meeting or exceeding local statutory vacation requirements
- ●Company sponsored 401(k) plan in US
Tech Stack
data pipelinedbtanalysissybil detectiondata modelingIndexingDeFismart contractmetricsProtocol research