What you'll do

📍Design, develop, and maintain data models aligned with business requirements and our data architecture 📍Manage data pipelines end-to-end, ensuring timely and accurate data delivery 📍Write complex SQL queries and macros to transform data efficiently, optimizing for performance 📍Build data quality checks throughout pipelines to ensure reliable datasets 📍Analyze data from multiple sources (APIs, blockchain, databases) to generate actionable insights 📍Conduct exploratory analyses on on-chain data to identify trends, anomalies, and opportunities 📍Build and maintain dashboards on Dune Analytics and other platforms for internal and public use 📍Support stakeholders by translating business questions into clear analytical projects 📍Integrate data from different sources, ensuring proper validation and accuracy 📍Collaborate with data analysts and analytics engineers to ensure consistency in metrics and definitions 📍Maintain high standards of documentation and integrity across all work 📍Contribute to team processes, share workflow improvements, and mentor junior members

What makes a good candidate

📍At least 3 years of experience in analytics engineering, data analytics, or BI development 📍Expert-level SQL with deep experience in data modeling, complex queries, and optimization 📍Proven data modeling expertise using dbt, sqlmesh, or dataform, with solid understanding of data warehousing and ETL/ELT concepts 📍Hands-on experience building dashboards and reports with visualization tools (Preset, Omni, or Looker)

If you’re passionate about blockchain and decentralized technologies, explore more opportunities in web3 and cryptocurrency careers.