Senior Data Engineer

About Token Terminal

Token Terminal aggregates, standardizes, and delivers financial and alternative data on blockchains and decentralized applications to both institutional and retail investors. Token Terminal is a full-stack onchain data analytics platform: We operate our own blockchain nodes, manage data extraction pipelines, and implement rigorous QA processes to ensure the highest data quality.

Since launching our platform in 2021, we've rapidly grown to serve a community of over 50,000 monthly active users, including many leading institutions in the Web3 space. Token Terminal is a remote-first company with employees distributed across various parts of the EU and the US. We are committed to fostering a collaborative and supportive remote work culture.

Day-to-day responsibilities

As a senior member working on our blockchain team, your responsibilities will include:

Integrate new chain ecosystems into our data warehouse

• Research and identify the specific blockchain data we need to extract, such as blocks, transactions, and traces.
• Design and implement SQL models for blockchain data, prioritizing ease of analytics use cases and adhering to our standardization practices.
• Understand the intricacies of the blockchain, including its various error cases, and implement rigorous QA tests to ensure the highest data quality.
• Research and understand blockchain business models, and build fundamental business metrics that align with our analytical goals.
• Communicate effectively with blockchain teams to ensure customer satisfaction.
• Track and respond to new developments in integrated blockchains, including both breaking and non-breaking changes in blockchain operations and schema updates.

Expectations

Within your first two months, you will work closely with our team on multiple blockchain integrations, gaining a deep understanding of how data is encoded and decoded across different blockchains. You will also begin learning the Token Terminal standard, our framework for tracking and analyzing crypto projects.

Within six months, you will be a key contributor, having led at least one chain integration and ideally becoming the go-to person for that specific ecosystem.

Within your first year, you will be an expert in at least one chain ecosystem and will play a crucial role in helping your colleagues learn and understand that ecosystem better.

The Token Terminal Stack

We use reliable, industry-standard tools wherever applicable, ensuring our systems are both robust and scalable.

Our infrastructure, including most of our blockchain operations, runs on top of Google Cloud. Over time, we've iteratively developed and refined our proprietary blockchain data extraction framework. Our current, third-generation infrastructure is built in TypeScript and runs extraction jobs within Kubernetes.

We strongly prefer ELT over ETL. Almost all data transformations on raw blockchain data are performed within our BigQuery data warehouse. This approach, coupled with the extensive use of SQL in our codebase, offers significant operational advantages. You'll encounter some elegant and innovative solutions within our SQL codebase.

Most of our SQL is managed with dbt, and we've built a custom orchestrator to manage our dbt projects efficiently. ‍

Qualifications

• Expertise working with data warehousing.
• Strong SQL skills and prior BigQuery, Snowflake, and ClickHouse experience are a bonus.
• Comfortability with TypeScript to improve our tooling and SQL generation.
• Experience with Kubernetes and Terraform is preferred but not a requirement to succeed in this role.

Benefits

• Competitive salary, stock options, and a comprehensive benefits package offered through Remote.com (depending on location).
• We offer mentorship from industry leaders, opportunity to expand your skills and network, and the chance to collaborate with some of the brightest minds in the field.
• Enjoy a flexible vacation policy.
• Work with a global team across various time zones.