LI.FI

Analytics Engineer

LI.FI

full-time

Posted on:

Location Type: Remote

Location: Anywhere in Europe

Visit company website

Explore more

AI Apply
Apply

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