Support Engineer

When we started out in late 2021 our thesis was simple - blockchain data, despite it being public and free, was difficult to understand, clunky to access and troublesome to maintain. Answering a simple question like “Who are the biggest Ethereum token holders over time?” requires an engineering team to run their own RPC nodes, ingest the full history of the blockchain, clean the data, transform the data and finally summon a wizard to cast a complex SQL query.

Why is it so hard? Blockchains have historically been optimized for Writes (getting data onto the blockchain) and less for Reads (getting data OUT of the blockchain). This is because optimization efforts were focused on increasing transaction throughput and building fault tolerant and scalable consensus algorithms. This neglect makes it hard to get data out efficiently and reliably at scale.

To quote Tim Roughgarden, Columbia Professor, “Blockchains are (virtual) computers, not databases.”  They are Turing machines that support general computations, and anyone can write and deploy their own smart contract for their own use case. This nearly infinite number of use cases leads to the fragmentation of data schemas for different purposes. Standardizing these schemas requires deep domain expertise to turn esoteric technical outputs into clear information for specific concepts like tokens, NFTs, stablecoins and DEXs.

Allium tames the chaos by ingesting, sanitizing, and standardizing all this data. As of this post, the data we’ve archived across 100+ blockchains is in the petabytes and growing exponentially.

This is one of the rare times in history where indexing a giant public dataset is sorely needed by all - similar to what Bloomberg did for financial data and what Google organized for public webpage data. With this indexed data, we are fortunate to support trailblazers in this industry and play some role the industry’s most exciting trends:

We serve 2 groups of customers today with the same data but different platform. Analysts who need to answer data questions about the blockchain (think BI) and Engineers who need highly reliable data queryable in near realtime (think Application backends). Our customers include the biggest institutions Visa, Stripe, Grayscale and also the biggest crypto companies such as Phantom, Uniswap. Allium is one of the unique companies in the industry that bridge blockchain and non blockchain worlds.

What You'll Do

• Troubleshoot and resolve complex customer issues involving SQL queries, data pipelines, API integrations and other Allium Integrations (e.g. kafka)

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

What You’ll Bring

• Fluency in SQL — you can confidently write, optimize, and debug complex queries.

• Experience providing technical support for a SaaS or data product.

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

• 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

• Tomasz Tungus from Theory Ventures: https://tomtunguz.com/allium/

• Bucky Moore from Kleiner Perkins: https://www.kleinerperkins.com/perspectives/allium-series-a/

• 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 lack of resources, but lack of resourcefulness.

• High Agency - (One of) the highest commonality 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

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.

Medical, Dental, Vision, Life and AD&D insurance - US folks get 100% coverage for Gold plans, 80% for dependents

Note: The sun never sets on Allium - we hire from any geographical location as long as you are willing to overlap 2 hours overlap on NYC mornings Mon-Thurs from 10am-12pm ET. We have people based in New York, Seattle, Singapore and Australia

All applicants have to answer this pop quiz: "What is an Allium? What is your favorite Allium?". Bonus points for the right pronunciation.