Blockworks - Senior Data Engineer (Solana)

• As our Senior Data Engineer, you will be directly responsible for leading the creation and execution of our data models and strategies that feed our product. You'll work collaboratively with other members of the engineering team to design, develop, implement, and evolve our data pipeline and approaches. • Every day will look a little different, but in general, you will do things like: • Own Data Sourcing Pipelines: You'll be responsible for helping to architect our data warehousing, ingestion and sourcing strategy, working with multiple SDKs to aggregate data from various sources into Blockwork's own data warehouse. • Own Data Sourcing Pipelines: • Design and Implement ETL Solutions: You'll be responsible for implementing our overall ETL approach, including accessing & setting up blockchain nodes to pull from, sourcing data from 3rd parties, and modeling our internal schemas across our PostgreSQL database(s) • Design and Implement ETL Solutions: • Grow Shared Knowledge: You'll help provide technical leadership, guidance, and assistance to the team in the implementation of established architectures and designs. • Grow Shared Knowledge: • Drive Operational Efficiency: You'll be constantly looking for opportunities to improve data workflows and reliably automate routine tasks. • Drive Operational Efficiency: • Cross-Functional Collaboration: You'll work with other teams across Blockworks, including Research, Product, and Engineering, to lead initiatives and move collaborations forward. • Cross-Functional Collaboration: • Experimentation is frequent at Blockworks. Comfortability with being uncomfortable is a must. • What You’ve Done Before: • For this role, first and foremost, you must have significant knowledge of the crypto industry; interest in crypto is not enough, we’re looking for someone who considers themself crypto native. You have at least 4 (but ideally more) years of hands-on experience with data modeling, schema design, data operations, and data warehousing. During that time, you've personally built backend systems at scale with a focus on data processing and ingestion. You're an ace at Typescript, Go, and/or Python, and you bring incredibly strong expertise in SQL (ideally Postgres, dbt, and Hypertables). You have deep experience creating data warehouses using Timescale, Snowflake, and/or BigQuery, and you also bring experience using DevOps tools and solutions like Docker, CI/CD, and AWS. • It’d Be Great If You’ve Done This: • Experience and demonstrated success in crypto, web3, startup, or incubator environments will move you to the top of the list. A background in designing, building, and managing microservices will also set you apart, especially if you bring expertise in security, privacy, and scalability. We’re especially interested in candidates who can pair technical depth with an ability to thrive in high-growth, fast-paced settings. • What will truly make you stand out is hands-on experience with Solana. If you’ve built and operated Solana ingestion pipelines using RPC, Websocket, or Geyser with resilience to forks and automated backfills, you’ll be a huge asset to our team. We’re looking for engineers who can decode transactions, instructions, and events, and ship modeled data into Postgres, Clickhouse, or Parquet with speed and accuracy. Fluency in decoding native programs such as System, Stake, SPL Token, Token2022, and Memo, along with Anchor programs, while managing IDLs, Borsh layouts, and maintaining an internal decoder registry, would set you apart as a Solana expert.