Analytics Engineer, Finance

Lovable Lovable · Coding AI · Stockholm, Sweden · Engineering

Analytics Engineer role focused on building and maintaining data models for financial reporting and analysis, connecting billing, subscriptions, and revenue data. Requires expertise in SQL, dbt/SQLMesh, dimensional modeling, and cloud data warehouses. The role involves managing data pipelines, reconciling data, defining business logic, and ensuring data quality for financial metrics.

What you'd actually do

  1. Build and maintain dimensional models (SQLMesh) for revenue recognition, subscription metrics, and financial reporting
  2. Create foundational tables for MRR/ARR, churn, expansion, contraction, and cohort-based revenue analysis
  3. Manage ingestion pipelines for financial data sources (Stripe, billing systems, payment processors)
  4. Reconcile data across systems to ensure accuracy between source of truth and reporting layers
  5. Define and document business logic for financial metrics (recognized revenue, deferred revenue, bookings)

Skills

Required

  • SQL
  • dbt
  • SQLMesh
  • dimensional modeling
  • data contracts
  • metrics/semantical layers
  • data transformation
  • cloud data warehouses (Snowflake, BigQuery, Redshift, Databricks)
  • BI tools (Looker, Tableau, Power BI, Hex, Metabase, etc)
  • subscription/SaaS metrics (MRR, ARR, churn, LTV, cohort analysis)
  • billing and payment data (Stripe, Chargebee, or similar)

Nice to have

  • Golang
  • Rust
  • Grafana
  • OTEL
  • Terraform

What the JD emphasized

  • accuracy matters for financial data