Job description

THE 4 BIGGEST BLOCKCHAIN STRENGTHS ARE ALSO ITS WEAKNESS - Permissionless nature leads to fragmentation of meaning - Decentralization leads to too many standards xkcd.com - Immutability leads to exponential data + query infrastructure complexity - Neutrality means that no one is accountable for interpretations Blockchain data is public. It is not usable at institutional scale. Despite being open, blockchain data is fragmented, hard to interpret, and painful to maintain. Even a simple question like “Who are the largest Ethereum token holders over time?” can require running nodes, ingesting full chain history, decoding contracts, cleaning edge cases, and writing complex SQL. BLOCKCHAINS ARE OPTIMIZED FOR WRITES, NOT READS. They are built for consensus and execution, not searchability, standardization, or financial interpretation. Blockchains are computers, not databases x.com. Every protocol defines its own schema. The same economic action can be encoded in dozens of different ways. The result: - Fragmented standards - Exponential complexity - No accountability for interpretation - Events without economic meaning Finance cannot operate on that, it needs an effective system of record. ALLIUM IS BUILDING THE SYSTEM OF RECORD FOR ONCHAIN FINANCE Allium ingests, verifies, and standardizes data across 140+ blockchains and 30+ petabytes of history. We close four structural gaps that prevent blockchains from becoming systems of record: - Semantic Gap: Translating raw events into financial concepts like payments, trades, deposits, and staking income - Standardization Gap: Mapping thousands of protocols into a single canonical cross chain schema - Infrastructure Gap: Read optimized, globally distributed data at web scale - Accountability Gap: Auditable methodology, SLAs, and SOC 1 and 2 compliance The result is a neutral, canonical data layer institutions can build on with confidence. FINANCE IS MOVING ONCHAIN Stablecoins, tokenized assets, trading, staking, and lending are growing rapidly. Institutions need a trusted source of truth for onchain financial activity, just as they rely on Bloomberg or DTCC in traditional markets. Raw blockchains cannot serve that role. As AI agents begin transacting autonomously x.com, the requirement becomes even stricter. Agents cannot reason over raw event logs. They need structured data, attribution, condition checks, and auditability. Allium is the read layer that makes onchain finance usable for humans and machines. WHO WE SERVE Allium powers three core personas with the same canonical data foundation: 1. Finance, Accounting, and Risk Teams They need reliable, audit grade answers. They rely on Allium for financial reporting, reconciliation, compliance, risk monitoring, and defensible metrics that can stand up to auditors and regulators. 2. Engineers and Product Teams They need low latency, production ready infrastructure. They use Allium to power wallets, trading systems, payment rails, staking infrastructure, and real time applications that cannot break. 3. Strategy, Research, and Executive Teams They need clarity and insight. They use Allium to understand ecosystem economics, market structure, user behavior, competitive dynamics, and where capital is flowing onchain. And of course...agents 🦞. Our customers and users include Visa, Stripe, G-SIB Banks, Big 4 Accounting firms, BCG, Coinbase, Phantom, Uniswap and cited by the Federal Reserve. What You’ll Learn - How petabyte-scale data infrastructure works - Allium manages 5+ petabytes across every combination of cloud provider x data warehouse (Snowflake, BigQuery, Databricks...) x region. You'll pick up how these systems are designed, where they break, and how to reason about freshness, cost, and correctness tradeoffs between them. - How to build AI-native support - Tickets that feed runbooks; runbooks that support agentic skills; an agentic loop that builds on itself and compounds - You will learn how to build an AI-native support system that scales. - How to manage expectations with institutional customers (banks, asset managers, exchanges, foundations) - What incident management best practices look like in production, how to communicate during a data incident, how to set an SLA you can actually keep, and how to thread the needle when two customers' expectations conflict. - How 100+ blockchains work under the hood - Resolving a ticket often means tracing a number back to raw on-chain data - why a stablecoin supply figure differs between two sources, why a balance snapshot lags, what a reorg does to a table. You'll build genuine depth in EVM, Solana, and the long tail of chains. - How enterprise data delivery works end to end - warehouse-native shares, APIs, Kafka streams, push vs pull. You'll learn to pick the right mechanism for a customer's problem, because half of support is knowing where in the product the answer already lives. - How to run a data quality investigation - verification checks, cross-source reconciliation, and separating "the data is wrong" from "the query is wrong" from "the chain did something unusual." - A path into becoming an Allium Data Wizard jobs.ashbyhq.com, if that's where you want to go. Every Wizard at Allium started on the frontlines; we believe staying close to customers and their use cases is how you learn the data best. This role builds exactly those skills: tracing numbers back to raw on-chain data, debugging SQL at scale, learning protocol mechanics. What You’ll Do - Troubleshoot and resolve complex customer issues involving SQL queries, data pipelines, API integrations and other Allium Integrations (e.g. kafka) - Mapping customer issues to where the solution exists in Allium. Be it a table in the dataset, another delivery mechanism, relevant documentation, another integration pattern (e.g. push vs pull) - Help customers diagnose problems in their data sources (Snowflake, BigQuery, Postgres, etc.) and optimize performance. - Collaborate with engineering to investigate bugs, identify patterns, and ship fixes. - Develop internal tools and scripts to automate troubleshooting and improve customer response times. - Write clear documentation and knowledge base articles for customers and internal teams. - Partner with the GTM and product teams to translate customer pain points into actionable insights. - Participate in daily syncs to discuss ongoing issues, progress, and improvements. - Synthesize all of the above into an AI-native system that builds leverage. - Triage and prioritize incoming issues against customer SLAs — distinguishing a P1 data incident for an institutional customer from a routine query question, and sequencing your work so the highest-impact problems get resolved first. What You’ll Bring - Fluency in AI tools, common failure modes and modern practices. - Fluency in SQL - you can confidently write, optimize, and debug complex queries. - Experience providing technical support for a SaaS or data product. - A working knowledge of blockchain data primitives across ecosystems like Solana and EVM chains. - Familiarity with APIs, data connectors, and ETL tools. - Comfort with scripting or automation in Python, Bash, or similar languages. - Strong understanding of Linux environments and command-line tools. - Excellent communication and documentation skills — you can explain complex concepts simply. - A proactive, empathetic approach to customer relationships. - The ability to work independently and take full ownership of issues from report to resolution. Bonus Points - Experience with data warehouses (Snowflake, BigQuery, Redshift) or BI tools. - Exposure to infrastructure-as-code tools (Terraform, Ansible, etc.). - Experience in debugging API or integration issues across cloud environments. - Familiarity with data modeling or transformation frameworks (dbt, Airbyte, etc.). - Experience with message queues and event buses (Google Pubsub, Kafka etc) DON'T TAKE OUR WORD FOR IT, WHAT OUR CUSTOMERS SAY ABOUT US (allium.so) allium.so [app.ashbyhq.com] WHAT SOME COOL PEOPLE HAVE TO SAY ABOUT US: - The Information's Top 50 Startups (allium.so) - Mario Gabriele from The Generalist's Future 50 Startup List: allium.so - Tomasz Tungus from Theory Ventures: tomtunguz.com - Bucky Moore from Kleiner Perkins: kleinerperkins.com 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 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 - 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. - 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 - 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. - 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. - 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 ABOUT THE TEAM We invite people of all backgrounds (allium.so). 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. [app.ashbyhq.com] [app.ashbyhq.com] ADMINISTRATIVE BENEFITS - 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 All applicants have to answer this pop quiz: "What is an Allium? What is your favorite Allium? allium.so". Bonus points for the right pronunciation.

Requirements

Must-haves

THE 4 BIGGEST BLOCKCHAIN STRENGTHS ARE ALSO ITS WEAKNESS
Permissionless nature leads to fragmentation of meaning
Immutability leads to exponential data + query infrastructure complexity
Neutrality means that no one is accountable for interpretations
BLOCKCHAINS ARE OPTIMIZED FOR WRITES, NOT READS.
Fragmented standards
Exponential complexity
No accountability for interpretation
Events without economic meaning
Finance cannot operate on that, it needs an effective system of record.
ALLIUM IS BUILDING THE SYSTEM OF RECORD FOR ONCHAIN FINANCE
Allium ingests, verifies, and standardizes data across 140+ blockchains and 30+ petabytes of history. We close four structural gaps that prevent blockchains from becoming systems of record:
Semantic Gap: Translating raw events into financial concepts like payments, trades, deposits, and staking income
Standardization Gap: Mapping thousands of protocols into a single canonical cross chain schema

Nice-to-haves

Experience with data warehouses (Snowflake, BigQuery, Redshift) or BI tools.
Exposure to infrastructure-as-code tools (Terraform, Ansible, etc.).
Experience in debugging API or integration issues across cloud environments.
Familiarity with data modeling or transformation frameworks (dbt, Airbyte, etc.).
Experience with message queues and event buses (Google Pubsub, Kafka etc)
DON'T TAKE OUR WORD FOR IT, WHAT OUR CUSTOMERS SAY ABOUT US (HTTPS://WWW.ALLIUM.SO/BLOG#LOVE) https://www.allium.so/blog#love
WHAT SOME COOL PEOPLE HAVE TO SAY ABOUT US:
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
OK, NOW FOR SOME TOUGH LOVE. HERE ARE THE VALUES WE STRIVE FOR AT ALLIUM:
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.

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sqlaigoapipostgrespythonrest

Platform: ashby
Effort: quick

Benefits

Benefits detected in the listing.

Dental

Vision

401(K)

Paid Time Off