Data product & analytics — Barcelona

Data products, built for real life.

I’m Álvaro. I connect business, data and engineering to build useful things — from analytics platforms to small tools I use every day.

Álvaro Picatoste presenting a metrics model at dbt Meetup Barcelona
Speaking at dbt Meetup Barcelona
Now
Senior Data Analyst / Data Product at IFCO Digital Hub
Building
Tasteando Achu
Since 2016
Energy, EV charging, IoT telemetry and global supply chains

Selected work

06

Each case follows the same thread: the problem, the solution, where AI fits and the results.

Professional

Data products built in my roles

03
IFCO 2025 — 2026 AI-assisted

Asset Loss Metrics

Survival-curve Non-Return Rate and an Assets at Risk view that turn container tracking signals into loss metrics the business acts on.

In production NRR pipeline and Assets at Risk dashboard for North America

DatabricksdbtPythonSQL +2
Wallbox 2021 — 2025

Telemetry Hub

Product ownership of the platform that decides which of 1,147 charger signals are sent, how often and with which definition.

~50% lower cost in the telemetry infrastructure scope

AWSIoT telemetryStreamingTime-series storage
Wallbox 2021 — 2025

Energy Flow Simulator

A household energy simulator that showed partners what a bidirectional charger is worth, configuration by configuration.

10,000 kWh OEM discharge cap challenged with the business case, then raised

PythonOptimisationEnergy modellingDatadis

Side projects

Products and tools I build on my own

03
Tasteando 2025 — now AI-powered

Tasteando

A booking product for Iberian tastings, with payments, customer emails and a separate Instagram AI worker.

Live bookings and payments at tasteando.com, plus an AI worker in production

ReactFastAPISupabaseStripe +2
Jamones Artesan 2024 — now AI-assisted

Holding Analytics

A practical data warehouse for a family business: ERP data, tested dbt models and reporting people can use.

Mon–Fri automated refresh from ERP to sales, customer and margin reporting

PythonPostgreSQLdbt-coreStreamlit +2
Personal project 2026 — now AI-powered

Achu

A Telegram agent that turns plain-language food messages into a local log, running on a repurposed laptop.

0 new apps logging happens in a chat I already use, stored in a CSV I own

OpenClawTelegramLLM APICSV +1

All projects (7)