Dune
Analytics Engineer
Europe, USA East CoastFull-timeGlobal
š Remote
ActivePosted within the last 30 days
Job Description
[AI-summarized by JobStash]
You will design, implement, and maintain SQL-based curated data models that make on-chain concepts reusable and reliable. You will extend datasets with new entities, metrics, and dimensions, write documentation and tests, and create new models when onboarding blockchains. You will reverse-engineer smart contracts and protocol mechanics to determine what to extract and how to model it, use transformation frameworks like dbt or SQLMesh to orchestrate and test changes, ensure pipelines are reliable and cost-aware, manage community contributions via GitHub, and collaborate with product and go-to-market to unlock clear user value.
Requirements
- ā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
- ā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
- āAbility to navigate blockchains and protocols autonomously to determine what matters and how to model it
- āPrior Dune power user experience (nice to have)
- āUnderstanding of Solana account model, programs, and IDL ecosystem (nice to have)
- āExposure to data engineering concepts and pipelines, including testing, observability, and CI for data (nice to have)
Responsibilities
- āDesign, implement, and maintain SQL-based curated models that standardize on-chain concepts across chains and protocols
- āExtend curated datasets with new entities, metrics, and dimensions and provide strong documentation and tests
- āCreate new data models when onboarding additional blockchains, 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
- āUse 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 the public GitHub repository and other channels
- āCollaborate with product and go-to-market to ensure curated models unlock clear user value
Benefits & Perks
- āEquity package with employee-friendly terms, heavily discounted strike price and 10-year exercise window
- ā5 weeks PTO plus local public holidays (swappable)
- āFully remote-first approach with flexible working hours
- āPrivate medical insurance, dental and vision
- āPaid parental leave: 16 weeks primary and 6 weeks secondary caregivers, plus 2-week phased return at full pay
- āQuarterly offsites and yearly travel allowance to connect and co-work
- āAllowance for at-home setup or paid local co-working desk
- āCompany swag
Tech Stack
observabilitystateCIquery engineGitHubsmart contracttestingtracesSQLdata modeling