About the role

The data team turns raw on-chain activity into trustworthy and reusable datasets. As an Analytics Engineer working on curated data, you will sit at the intersection of protocol mechanics, SQL modeling, and transformation tooling.

You will work closely with data engineers and product managers to standardize how key on-chain concepts are represented across chains and protocols, so analysts and developers can build reliably on top of them. ⁠​

Success looks like faster time-to-insight for analysts, fewer one-off queries, and reusable models that scale as we add new ecosystems

In this role, you will

• Design, implement, and maintain SQL-based curated models that standardize on-chain concepts across chains and protocols
• Extend our existing curated datasets with new entities, metrics, and dimensions with strong documentation and tests
• Create new data models when we onboard additional blockchains to Dune, aligning with chain-specific standards and quirks
• Reverse‑engineer smart contracts and protocol mechanics to determine what to extract, how to decode it, and how to model it
• Work hands-on with transformation frameworks (dbt or SQLMesh) to orchestrate, test, and review changes end to end
• Partner with engineers to ensure pipelines are reliable, documented, and cost-aware from raw to curated layers
• Manage and maintain community data contributions through our public Github repository and other channels
• Collaborate with product and go to market to ensure curated models unlock clear user value

You might be a great fit if you have

• Exceptional blockchain data knowledge and the ability to read events, traces, and state with confidence
• Hands-on understanding of how smart contracts work and how protocol designs map to data models
• Strong SQL skills and experience building analytical models on large datasets
• An interest in understanding query engines and applying that knowledge to craft optimized queries
• Practical experience with a data transformation tool such as dbt or SQLMesh
• A builder’s mindset: you can navigate a blockchain and a protocol autonomously to figure out what matters and how to model it
• Leverage AI-driven tools and insights to optimize decision-making, streamline workflows, and enhance team productivity.

Nice to have

• Prior Dune power user experience
• Understanding of Solana’s account model, programs, and IDL ecosystem
• Exposure to data engineering concepts and pipelines, including testing, observability, and CI for data