Analytics Engineer
About this role
TL;DR - We are looking for analytics engineers to own the semantic and modeling layer of our warehouse by transforming raw data into well-defined, trustworthy datasets and metrics. You are obsessed with analytical consistency, designing impactful metrics, and building strong foundations for self-service analytics.
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 data models, following modular, tested, and version-controlled practices
- Partner with domain teams to understand business logic and codify it into reusable models and metrics
- Define and document key metrics and data contracts across domains
- Collaborate with Data Platform Engineers to optimize query performance and warehouse cost
Requirements
- Expertise with SQL, dbt, SQLMesh or similar tools (data modeling, testing, macros, docs)
- Experience with data warehousing concepts, cloud warehouses (Snowflake, BigQuery, Redshift, Databricks) and BI tools (Looker, Tableau, Power BI, Hex, Metabase, etc)
- Understanding of dimensional modeling, data contracts, and metrics/semantical layers
- Familiarity with modern ELT and orchestration workflows (Airflow, Dagster, Prefect, etc)
- Strong business acumen and ability to translate domain logic into scalable data structures