Analytics Engineer - Finance
About this role
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.
Why Lovable?
Lovable lets anyone and everyone build software with plain English. From solopreneurs to Fortune 100 teams, millions of people use Lovable to transform raw ideas into real products - fast. We are at the forefront of a foundational shift in software creation, which means you have an unprecedented opportunity to change the way the digital world works. Over 2 million people in 200+ countries already use Lovable to launch businesses, automate work, and bring their ideas to life. And we’re just getting started.
We’re a small, talent-dense team building a generation-defining company from Stockholm. We value extreme ownership, high velocity and low-ego collaboration. We seek out people who care deeply, ship fast, and are eager to make a dent in the world.
Responsibilities
- 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 an
Requirements
- Familiarity with subscription/SaaS metrics (MRR, ARR, churn, LTV, cohort analysis)
- Experience working with billing and payment data (Stripe, Chargebee, or similar)
- Expertise with SQL, dbt, SQLMesh or similar tools (data modeling, testing, macros, docs)
- Understanding of dimensional modeling, data contracts, and metrics/semantical layers.
- Hands-on experience with data transformation tools (SQLMesh, dbt, or similar)
- Experience with data warehousing concepts, cloud warehouses (Snowflake, BigQuery, Redshift, Databricks) and BI tools (Looker, Tableau, Power BI, Hex, Metabase, etc)
- Attention to detail and understanding of why accuracy matters for financial data