The Block is hiring a

Web3 Data Engineer (Contract)

The Block delivers deep insight into how the emerging digital assets sector interacts with traditional finance, technology, governments, and markets. We reach hundreds of thousands of technologists, financial market participants, Fortune 500 professionals, global service providers, policymakers, and more through our main website, dedicated Research Portal, podcast, and events.

You will be responsible for developing new data offerings, developing and supporting solutions for product analytics, and capturing feedback from our logging and debugging services to both troubleshoot and make improvements.

An effective Data Engineer should be able to effectively communicate with the Product & Engineering team while developing ETL pipelines that support our data and analytics product efforts. The ideal candidate must be able to prioritize tasks and complete them in a timely manner.

Description of Role

• Fully remote, but must be able to join 12:30PM EDT daily stand up
• We have a list of Exchange APIs that we would like to create data extract and load jobs
• This will be 5+ weeks of work
• Each pair of extract and load jobs will be housed in Airflow
• Your job will be to create the tasks/DAGs in Airflow (Python)


The extract job will consist of:
• Pulling data from the API
• Applying any necessary data transformations (i.e. timestamps, rename columns, etc)
• Store raw data into S3


The Load job will consist of:
• Reading data from S3
• Loading data into Redshift
• Create queries in Redash (from wherever the respective load job ends) that replicates the data needed per API. The logic needed to replicate may be done in full or in part through the SQL query, or during the extract phase

Our Tech Stack

• Python
• AWS
• SQL
• Airflow

Who We Are: The culture of The Block lies in our key behaviors. It’s who we are and it’s how we show up every day.

We are confidently humble. We jump in and roll up our sleeves. We know there’s always more to learn and we operate without egos.

We are actionably curious. We strive to be an expert in our field and always seek opportunities to expand our knowledge and skill set. We put our learnings into practice every day. 

We practice tenacious ownership. Every day when we show up we are contributors, teammates, and owners. We rotate through those three hats with agility and without sacrificing accountability or consistency.

We practice respectful partnership. We treat others as we’d expect to be treated - with respect, concern, understanding, and patience.

During our application process, we collect completely anonymous diversity information. Providing this information is voluntary but we want you to know what we do with it. We use the data to ensure that our recruiting practices are bringing diverse talent to the organization and we are reacting where we are coming up short. We strive to use the data to ensure we have the tools and resources for all employees both during the interview process and should those employees choose to join us at The Block.