Analytics Engineer, Finance

TL;DR - We're looking for an Analytics Engineer to own the data foundation that powers financial reporting and analysis at Lovable. You'll build the models that connect billing, subscriptions, and revenue data to ensure Finance has accurate, auditable data for reporting, forecasting, and decision-making. ## What you will do

• Build and maintain dimensional models (SQLMesh) for revenue recognition, subscription metrics, and financial reporting
• Create foundational tables for MRR/ARR, churn, expansion, contraction, and cohort-based revenue analysis
• Manage ingestion pipelines for financial data sources (Stripe, billing systems, payment processors)
• Reconcile data across systems to ensure accuracy between source of truth and reporting layers
• Define and document business logic for financial metrics (recognized revenue, deferred revenue, bookings)
• Monitor data quality and implement validation checks for financial data integrity
• Partner with Finance to translate reporting requirements into reliable, well-structured data models