
Analytics Engineer
LI.FI
full-time
Posted on:
Location Type: Remote
Location: Anywhere in Europe
Visit company websiteExplore more
Salary
💰 €80,000 - €100,000 per year
About the role
- 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
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 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)
- 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 with the ability to turn complex data into actionable insights
- Takes full ownership of projects, holds yourself to high execution standards, and knows when to ask for help
- Meticulous about data accuracy, documentation, and self-review
- Clear communicator who adapts to both technical and non-technical audiences
- Comfortable experimenting with new approaches, learning from mistakes, and adapting quickly
- Passionate about crypto/web3 and eager to explore new tools and technologies.
Benefits
- 30 days of PTO
- Flexible remote days
- Flexible working hours
- Equity participation from day 1
- Entitlement to work computer (choice of equipment)
- An annual 1,000€ personal development budget once you have worked 6+ months (pro-rated the first year)
- A one-time 1,000€ remote budget to use on coworking, office setup, etc.
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
SQLdata modelingETLELTdata validationdata cleaningdata quality assurancePythondata pipelineson-chain analytics
Soft Skills
analytical thinkingclear communicationownershipmeticulousnessadaptabilitymentoringcollaborationworkflow improvementproblem-solvingproject management