Kasper Thomsen

Kasper Thomsen

Senior Data Analyst & Engineer

Barcelona-based expert with 8+ years turning complex data into actionable insights. Specialist in SQL, BigQuery, and Python.

Journey

Scroll through the stack to reveal detailed impact

Payhawk

Senior Data Engineer

PAYHAWK

2025 - Present

100+

Table
Dependencies

  • Expanding BigQuery databases to support global spend management.
  • Managing complex dependencies across 100+ core tables for data integrity.
  • Architecting automated pipelines to provide real-time executive dashboarding.
HP

Scan Program Analyst

HP

2023 - 2025

Scale

Global Data
Models

  • Architected enterprise-level data models in Redshift for scan program tracking.
  • Developed high-impact Looker & PowerBI dashboards for internal stakeholders.
  • Analyzed complex user behavior datasets to drive global program optimizations.
HP

Data Analyst

HP

2022 - 2023

AI

Internal
Innovation

  • Boosted Instant Ink adoption rates by identifying and removing friction points.
  • Spearheaded internal AI training and knowledge sharing for the analytics team.
  • Delivered SQL-based churn prediction insights to drive customer retention.
Vitec

Analytics Lead

VITEC

2020 - 2022

Lead

Technical
Roadmaps

  • Defined the long-term technical analytics roadmap for core product suites.
  • Managed high-value client consulting for custom BI & data tracking solutions.
  • Optimized development pipelines to ensure faster delivery of actionable reports.
Vitec

Analytics Consultant

VITEC

2018 - 2020

400+

Automated
Workflows

  • Engineered automated R and SQL workflows for over 400+ clients.
  • Built real-time internal KPI dashboards to monitor operational performance.
  • Streamlined reporting cycle times by 60% through custom data automation.

Technical Arsenal

Data Engineering

BigQuery Snowflake dbt Redshift PostgreSQL Docker Airflow Jenkins

Analytics & BI

Python SQL Looker LookML Tableau Power BI R Plotly

Cloud & ML

GCP AWS Scikit-learn TensorFlow Ollama AI Integration Azure LLMs

Education

Aarhus University

MSc Business Intelligence

Aarhus University | 2017 – 2019

Specialization in Forecasting, Text Analytics, and Data Mining.

NTU Singapore

BSc Economics & Business Admin

NTU Singapore | 2016 – 2016

Focus on:

  • • International Finance
  • • Communications Strategies
Aarhus University

BSc Business Administration

Aarhus University | 2014 – 2017

Thesis on consumer behavior in autonomous vehicles (Grade: A).

Key Projects

Click a project to explore the architecture

Smart Home Automation & Local LLM

Built an ecosystem of 130+ automated devices via Home Assistant. Integrated a locally hosted Large Language Model (Ollama) for intuitive natural language voice control.

Raspberry Pi Ollama YAML
Smart Home

This ongoing project integrates Ollama with Home Assistant's voice pipeline, allowing conversational control over 130+ privacy-focused devices.

Key Features:
  • • 130+ Devices automated
  • • Local, private LLM logic
  • • Custom YAML & Python scripting

Global Scan Data Architecture (HP)

Architected robust data models using Looker & LookML for massive global datasets. Enabled deep behavior analytics and stakeholder dashboards for HP's scan ecosystem.

Looker LookML SQL
Data Models

Built massive global behavior models for HP scan devices, providing critical insights for product teams via PowerBI.

Objectives:
  • • Robust LookML Modeling
  • • User behavior & friction tracking
  • • Executive reporting dashboards

Custom Video Game & AI Playground

Developed a 2D game using Phaser.js and Vite. Explored practical application of LLMs (ChatGPT, Suno, Gemini) for AI-driven generation of game assets and music.

Phaser.js AI Assets
Video Game

Built from scratch to learn game physics loops while applying advanced generative AI models for music and sprites.

Learnings:
  • • Game Physics & Animation
  • • Suno/ChatGPT Asset Gen
  • • Vite build processing

Get In Touch

Professional Office

Let's connect.

Barcelona / Global Remote

I'm always open to discussing new data challenges, AI integrations, or technical leadership opportunities.

Send a Message