Analytics Engineer
Skills
About the Role
You will own the full journey from raw data to reliable, well-modeled datasets. You will design and maintain data models, build and operate end-to-end data pipelines, write complex SQL transformations, and implement data quality checks. You will build dashboards, conduct exploratory on-chain analyses, support stakeholders with analytical projects, document your work, and mentor junior members.
Requirements
- 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 experience using dbt sqlmesh or dataform and knowledge of data warehousing and ETL ELT concepts
- Hands on experience building dashboards and reports with Preset Omni or Looker
- Experience working with on chain data especially using Dune Analytics
- Strong Python proficiency
- Experience with data validation cleaning and quality assurance
- Ability to design build and maintain data pipelines end to end
- Understanding of blockchain data structures and on chain analytics
- Strong analytical thinking and ability to turn complex data into actionable insights
- Takes full ownership of projects and maintains high execution standards
- Meticulous about data accuracy documentation and self review
- Clear communicator who adapts to technical and non technical audiences
- Comfortable experimenting learning from mistakes and adapting quickly
- Passionate about crypto web3 and eager to explore new tools and technologies
Responsibilities
- Design develop and maintain data models aligned with business requirements and data architecture
- Manage data pipelines end to end ensuring timely and accurate data delivery
- Write complex SQL queries and macros to transform data and optimize performance
- Build data quality checks throughout pipelines to ensure reliable datasets
- Analyze data from multiple sources including APIs blockchain and 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 data integrity
- Contribute to team processes share workflow improvements and mentor junior members
Benefits
- Annual team offsites
- 30 days of PTO
- Flexible remote days
- Flexible working hours
- Equity participation from day 1
- Entitlement to work computer choice of equipment
- Annual 1000€ personal development budget after 6 months pro rated first year
- One time 1000€ remote budget for coworking or office setup