Founded in 2018, with employees across the world, The Block is the leading research, analysis, and news brand in the digital asset space. The Block's team is spread across 5 continents and 15+ time zones, covering the global cryptocurrency space 24/7. At The Block, we see digital assets as a ubiquitous part of the future. As this space continues to evolve, we view our role as the trusted moderator and authoritative voice for those who invest in, work with, make decisions about, or seek to understand digital assets. 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
- We have a list of Exchange APIs that we would like to create data extract and load jobs.
- This will be 4-6 weeks of contractor job.
- Each pair of extract and load jobs will be housed in Airflow.
- Your job will be to create the tasks/DAGs in Airflow (Python).
- Pulling data from the API
- Applying any necessary data transformations (i.e. timestamps, rename columns, etc)
- Store raw data into S3
- Reading data from S3
- Loading data into Redshift
- As part of the load job, you’ll need to use DBT to transform data
- 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
The extract job will consist of:
The Load job will consist of:
Our Tech Stack
- SQL (DBT experience preferred)
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.Why You Should Work Here:We take care of our employees and we have the benefits and perks to support it. Our full-time, US-based employees are eligible for Unlimited PTO, remote-first environment, high health plan employer contributions, monthly wellness stipend, generous parental leave policy, 401k match, fitness partnerships, fertility benefits, One Medical membership, and citibike membership. We’re a remote-first company which allows us to hire the best person for the job regardless of location. Impactful work. Regardless of your role at The Block, you’re making a meaningful contribution to our mission in accelerating the evolution of financial systems through independent reporting and technical research of all projects influencing the future of financial services.What Else Should You Know?The Block is an equal employment opportunity employer. Qualified candidates are considered for employment without regard to race, religion, gender, gender identity, sexual orientation, national origin, age, military or veteran status, disability, or any other characteristic protected by applicable law.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.