Hannah Lindqvist
Senior Analytics Engineer · dbt + Looker LookML · Growth + Finance marts
[ Summary ]
Senior analytics engineer with five years of dbt-first work across two SaaS companies. Owns the growth + finance marts at a Series C SaaS — 220 dbt models, 38 downstream dashboards, 4 product-surface exposures. Authored the MRR + cohort-retention metric definitions in dbt Semantic Layer; metric drift on finance dashboards fell to zero across 6 quarters. Two merged PRs to dbt-utils.
[ Skills ]
Transformation
dbt (Core + Cloud, 220 models)·dbt Semantic Layer + MetricFlow·SQLMesh (familiarity)·Jinja + dbt macros
Warehouse + BI
Snowflake·Looker (LookML)·Hex·Metabase
Modeling + Quality
Kimball dimensional modeling·Activity Schema·dbt-utils + dbt-expectations·Cohort + retention frameworks
[ Experience ]
Senior Analytics Engineer
Q
Quill · Stockholm / Remote
Aug 2022—Present
- Own 220 dbt models across 4 marts (growth, finance, product, ops); model-execution time fell 38% via incremental materialization + clustering keys; freshness SLAs documented per model with ownership.
- Authored the MRR + ARR + cohort-retention metric definitions in dbt Semantic Layer; ran a 4-week reconciliation with the finance team to align warehouse metrics with the GL; metric drift on finance dashboards fell to zero across 6 quarters.
- Built the Looker LookML translation layer for the growth mart (38 Looks + 12 dashboards); analyst self-service queries rose from 240/month to 1,400/month, reducing AE-team ad-hoc query load by 78%.
- Authored the team's dbt style guide (model naming, ref pattern, materialization defaults, test coverage minimums); adopted across 3 data sub-teams; model-PR review time fell from 2 days to under 6 hours.
- Co-authored the company's metric tree (4 layers: input → driver → KPI → north-star); now the canonical map for cross-team metric questions and onboarded into the data-team interview rubric.
Analytics Engineer
K
Klarna · Stockholm, SE
Apr 2020—Jul 2022
- Migrated the growth mart from spreadsheet-driven KPI tracking to a dbt + Looker pipeline; replaced 38 manual weekly reports; cycle time on KPI changes dropped from 5 days to 4 hours.
- Authored the growth-mart cohort framework (cohort-by-acquisition-source, cohort-by-plan, cohort-by-feature-adoption); now powers the weekly growth-review meeting.
- Built the data-lineage layer (dbt-docs + Marquez); surfaced 14 orphaned models — reclaimed via deprecation runbook.
[ Open Source & Community ]
dbt-labs/dbt-utils
Contributor (2 merged PRs)Two merged PRs to dbt-utils — one extended date_spine to support week-aligned partitions; one closed a unicode-collation bug in deduplicate. Plus: Coalesce 2024 lightning-talk speaker — 'Metric trees in practice.'
dbtJinjaSQL
[ Education ]
MSc in Computer Science (Data Science track)
KTH Royal Institute of Technology
Sep 2015—Jun 2019