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
• If you’re excited about this role but your experience doesn’t align perfectly with every qualification in the job description, we encourage you to apply anyway. You may be just the right candidate for this or other roles

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
• Leverage AI-driven tools and insights to optimize decision-making, streamline workflows, and enhance team productivity