On Chain Analytics Engineer
Posted on 3/15/2023
INACTIVE
Largest NFT marketplace
Company Overview
OpenSea's mission is to make digital collectibles available to anyone, through buying or selling these items through a smart contract. OpenSea is a peer-to-peer marketplace for cryptogoods, which include collectibles, gaming items, and other virtual goods backed by a blockchain.
Locations
Remote
Experience Level
Entry
Junior
Mid
Senior
Expert
Desired Skills
BigQuery
Data Analysis
Airflow
Snowflake
Python
CategoriesNew
Data & Analytics
Responsibilities
- Help build and maintain both internal and external abstractions (e.g. on Dune) for core OpenSea and Seaport data tables
- Craft data transformation pipelines to combine various external datasets and internal datasets
- Work closely with the Protocol team to understand and account for the implications of protocol level changes on internal and external datasets
- Work with external analytics providers such as Dune, Nansen, Reservoir, etc. to help move us toward common standards around attribution, data accuracy, etc
- Create monitoring and alerting to ensure data fidelity
- Design a thoughtful system of redundancies and checks across internal and external datasets so we can have deeper insight in data accuracy
- Dig deep into contract calldata and be extremely detail oriented to account for the many edge cases that will crop up to ensure our on chain datasets are as accurate as possible
Desired Qualifications
- 5+ years of experience in data engineering, including fluency with Python, Airflow and Snowflake
- Ability to interpret smart contract output and work closely with blockchain engineers to understand how to extract and standardize data from different contracts
- Crypto/web3 experience, including a love for the community, and/or a degen portfolio
- Fluency with web3 analytics tools including making spells (DBT) in Dune and/or with Nansen/Google Bigquery
- Experience communicating effectively up, down and sideways across the company, with thoughtfulness around optimizing asynchronous communication and tailoring communication to different preferred styles
- Strong cross-functional skills and ability to operate under ambiguous and fast moving problem spaces
- Humility, humor, curiosity, resourcefulness and a relentless drive to grow and learn