Analytics Engineer
Upload My Resume
Drop here or click to browse · PDF, DOCX, DOC, RTF, TXT
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 • 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 • Understanding of Solana’s account model, programs, and IDL ecosystem • Exposure to data engineering concepts and pipelines, including testing, observability, and CI for data
Responsibilities
• 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
Benefits
• A competitive salary and equity package 🚀. Both salary and equity is top 25% of companies https://notion.so/Careers-at-Dune-Doing-the-best-work-of-your-life-f25e0b5e1f624d2aaf3ef2c81558ea96#7f745f5112394686bd7c127c720f2024 in the space • Our employee equity scheme has world-class employee-friendly terms with a heavily discounted strike price (~90%) and a 10-year exercise window • 5 weeks PTO + local public holidays (that can be swapped to suit you) 🏖 • A fully remote-first approach 🧑💻 within a distributed team with flexible working hours; you structure your own day • Say goodbye to meeting overload! We believe in a healthy mix of async and sync work, so you can focus on what truly matters—no more wasted time on endless meetings! • Good health is important, so we offer private medical insurance, dental & vision as standard 🩺 • We believe in paid parental leave 👶 to help you celebrate this important milestone, transition to your new life, and bond with your new baby. We offer 16 weeks to primary and 6 weeks to secondary caregivers, fully paid. Plus a 2-week part-time phased return at full pay to help you get used to your new (and slightly more complex!) schedule • Quarterly offsites in various exciting locations as a company or team to connect, work together and have fun (so far in Tuscany 🇮🇹 Berlin 🇩🇪 Austria 🇦🇹 and Athens 🇬🇷). • On top of this 👆each person gets a yearly travel allowance to connect and co-work with someone or a team of people for a few days. • An allowance for your at-home setup, to ensure you are happy, comfortable and productive. If you prefer a local co-working space, we’ll pay for your desk. • Work with some of the best people you’ll ever get to meet! • And of course, you get some awesome Dune swag https://community.dune.com/lookbook! ✌️😎 • ----------------------------------------------------------------------------------------- • We are dedicated to building a diverse, inclusive, and authentic workplace, so 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.