Analytics Engineer, Dune

• For this position you MUST have experience analysing onchain data - please show in your application form
• 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

Desirable

• 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
• 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