Analytics Engineer

We're looking for an Analytics Engineer to design, build, and maintain data models and pipelines that power how LI.FI understands its business and the on-chain world.

Requirements

• 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

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 1,000€ personal development budget once you have worked 6+ months (pro-rated the first year)
• One-time 1,000€ remote budget to use on coworking, office setup, etc.