Staff Data Engineer

Summary

Join OpenSea, a leading web3 platform, as a Staff Data Engineer to lead the design and implementation of scalable data infrastructure for millions of NFT transactions. You will architect the data backbone powering insights for this prominent platform, working at the intersection of blockchain analytics and massive-scale data engineering. This role requires expertise in SQL, modern data stack technologies, and experience with data warehousing tools like Snowflake. You will design and implement data pipelines, create dashboards, develop ETL processes, build CDC solutions, and manage data streaming and scheduling systems. The position demands a strong understanding of blockchain/NFT data structures and a proven track record in data engineering. OpenSea offers a remote-first work environment and a competitive salary and benefits package.

Requirements

• Expert-level proficiency in SQL and modern data stack technologies
• Hands-on experience with Snowflake or similar data warehousing tools, including multi-cluster warehouse configuration and optimization
• Strong background in CDC solutions and real-time data streaming (Kafka, Confluent)
• Experience with both SQL and NoSQL databases (Postgres, MongoDB)
• Proven track record building ETL/ELT pipelines that process terabytes of data daily
• Understanding of blockchain/NFT data structures and metadata standards
• Experience implementing data governance, security controls, and access management
• Strong communication skills and ability to work with cross-functional teams
• High ownership mentality

Responsibilities

• Design and implement end-to-end data pipelines for processing blockchain and digital asset data at scale
• Create and maintain business critical dashboards across revenue & monitoring use-cases
• Develop robust ETL processes using SQL to transform raw data into analytics-ready tables
• Implement data modeling solutions for complex domains like NFTs, including metadata, ownership, and analytics
• Build and maintain CDC (Change Data Capture) solutions to synchronize data between MongoDB, Postgres, Kafka, Confluent, and Snowflake
• Configure and maintain data streaming solutions for real-time data processing
• Set up and manage automated scheduling systems for data transformation tasks
• Implement data governance and security controls, including role-based access management
• Optimize and configure multi-cluster Snowflake data warehouses for concurrent query handling

Preferred Qualifications

AI-forward mindset with hands-on experience adopting and integrating AI tools

Benefits

• We cover 100% Dental/Vision/Medical for employees and 90% for dependents
• Our flexible time off policy is aimed at letting our employees take as much time off as they'd like to refresh so long as it doesn't interfere with their ability to meet their goals and contribute effectively to company velocity
• 16 Weeks of Paid Parental Bonding & up to 8 additional weeks for the birthing parent
• We offer access to Spring Health, covering 8 therapy & 8 coaching sessions per year
• 11 Company Holidays
• Fidelity 401K Plan
• Internet/Mobile Reimbursement Plan
• Reimbursement or Monthly Snack Delivery
• Company & Team retreats to get together for fun and collaboration
• Team Member Co-Working and Gathering Expense
• MacBook Pro & WFH Stipend to make sure you are set up for success
• Weekly $50 Uber Eats credit