Allium - Blockchain Data Wizard, Analyst or Scientist

• Creating Meaningful Data AbstractionsTransform 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. • Creating Meaningful Data Abstractions • Reverse Engineer DeFi Protocol MechanicsDive 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. • Reverse Engineer DeFi Protocol Mechanics • Indexing New BlockchainsDive 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. • Indexing New Blockchains • Building Metrics & Filtering NoiseDesign 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. • Building Metrics & Filtering Noise • Qualities • Qualities • Sherlock & Enola Holmes-Level CuriosityYou 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. • Sherlock & Enola Holmes-Level Curiosity • Product-Minded Data DesignYou 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. • Product-Minded Data Design • Comfortable with AmbiguityNew blockchains and protocols have sparse documentation. You thrive when you need to figure things out yourself through exploration and experimentation. • Comfortable with Ambiguity • SQL/dbt MasteryYou 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. • SQL/dbt Mastery • 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 • Don't take our word for it, what our customers say about us (https://www.allium.so/blog#love) • What some cool people have to say about us: • The Information's Top 50 Startups (https://www.allium.so/post/allium-named-to-the-informations-50-most-promising-startups-of-2025) • The Information's Top 50 Startups • Mario Gabriele from The Generalist's Future 50 Startup List: https://www.allium.so/post/allium-named-awardee-of-the-generalists-inaugural-future-50-startups • Mario Gabriele from The Generalist's Future 50 Startup List: • Tomasz Tungus from Theory Ventures: https://tomtunguz.com/allium/ • Tomasz Tungus from Theory Ventures: • Bucky Moore from Kleiner Perkins: https://www.kleinerperkins.com/perspectives/allium-series-a/ • Bucky Moore from Kleiner Perkins: • Ok, now for some tough love. Here are the values we strive for at Allium: • Obsessiveness - The best people at Allium cannot put a problem down once they pick it up. We care more about the work than is strictly rational. Institutions trust us because our data is right. Right means caring about the small things. The decoded contract that ships with one wrong field. The label that is 99% accurate but wrong on the address that matters. The query that runs in 4 seconds when it should run in 400 milliseconds. Most companies tolerate these. We do not. • Obsessiveness • Obsessiveness shows up as depth of care. It is not measured in hours worked or visible effort. You should feel something physical when work ships half-right. That instinct is what we hire for. • Pro Athlete Mindset - Consistency. Day in and day out, in pursuit of excellence. A win yesterday does not guarantee (or even imply!) a win tomorrow. I hope anyone who supports a failing sports team will feel the pain (cough Man United fans) of inconsistency • Pro Athlete Mindset • Figure It Out & Extreme Ownership - Every day is unexplored territory. There are new engineering frameworks, new legal docs, new compliance, new sales, new regulations, and new operational procedures every single day. If you don’t know it, learn it. If you can’t learn it, find someone or a product that does it. If you can’t find someone, find someone who can find someone. It is never a lack of resources, but lack of resourcefulness. • Figure It Out & Extreme Ownership • High Agency - (One of) the highest commonalities between all successful people is their responsiveness. Most successful billionaire CEOs still reply to emails within minutes (within working hours). And when you reply, respond fast with effective solutions - and even better, resolutions. If you’re looking for a superpower, you can’t go wrong with responsiveness. Well of course this doesn't make sense when you're an engineer coding in flow, but in general high agency of problem solving gets one very far in life • High Agency • Leading from the Front - No one is going to listen (and adopt) your suggestion unless you lead by example. It’s one thing to say We need to do XYZ this better & it’s another thing to build an MVP and say “This is the way we should do things”. The proof of work and momentum goes a long way. • Leading from the Front • Strong Opinions On the Future (loosely held) - It is okay to be wrong, but what is not okay is not to have an idea of how a better future should be. Alliumites take pride in trying to improving everything about the company all the time. • Strong Opinions On the Future (loosely held) • Sense of (Allium) business smell - There are number of folks who live to eat at Allium, but the Allium smell we are talking about is that we love folks who naturally want to know why and how the work they are doing builds leverage for their teammates and also relates to the business goals • Sense of (Allium) business smell • We invite people of all backgrounds (https://www.allium.so/about). We have engineers who learnt coding much later in life, who learnt coding on the side, we have engineers who are still in school and we also have engineers who went to the top schools (CMU, Stanford, UIUC, UPenn, Oxford, NUS, Cornell), all are welcome if one comes in with a curious mind and an infectious work ethic.