Analytics Engineer, Marketing

Lovable Lovable · Coding AI · Stockholm, Sweden · Engineering

Analytics Engineer role focused on building and maintaining the data foundation for marketing decisions. Responsibilities include defining event tracking, building data models using SQLMesh/dbt, managing ingestion pipelines for marketing data sources, and ensuring data quality. Requires expertise in SQL, dbt, dimensional modeling, and familiarity with marketing data concepts and event collection systems.

What you'd actually do

  1. Define and govern event taxonomy for marketing touchpoints (UTMs, referrals, conversions, campaign interactions)
  2. Partner with product engineering to instrument and validate tracking across web, app, and lifecycle channels
  3. Build and maintain dimensional models (SQLMesh) for attribution, channel performance, and customer journey analysis
  4. Create foundational tables for attribution windows, touchpoint sequences, cohort definitions, and channel mapping
  5. Manage ingestion pipelines for marketing data sources (ad platforms, affiliate networks, influencer tools)

Skills

Required

  • SQL
  • dbt
  • SQLMesh
  • dimensional modeling
  • data contracts
  • metrics/semantical layers
  • event collection systems (RudderStack, Segment, Snowplow, GA4)
  • data warehousing concepts
  • cloud warehouses (Snowflake, BigQuery, Redshift, Databricks)
  • BI tools (Looker, Tableau, Power BI, Hex, Metabase, etc)
  • business acumen
  • translate domain logic into scalable data structures

Nice to have

  • marketing data
  • UTM structures
  • attribution concepts
  • ad platform data quirks