Joan Sau · Software & Data Engineer Barcelona · Personal portfolio

I build systems that scale.

I’m Joan. A web developer with a data engineer’s instincts. I take fragmented databases, spreadsheet-driven processes and legacy macros and rebuild them as clean cloud architecture: automated flows, typed code, reliable SQL and dashboards people actually trust.

01 The foundation

It started with systems.

I trained in Web Application Development (DAW) and spent a year as a developer inside Barcelona’s public education consortium, the body that runs enrolment, grants and data for the city’s schools.

There I worked across the Information Systems and data teams: building Power Automate cloud flows and Power Apps for case-processing staff, maintaining the corporate database with SQL, and designing Power BI dashboards for operational decision-making.

The most valuable work was structural. I migrated desktop automations to the cloud, rewrote legacy Excel VBA macros as TypeScript Office Scripts, and built geocoding pipelines that turned raw address files into mapped, territory-aware data.

What I bring to a team: I find the fragile part of a workflow, replace it with something documented and automated, and make sure it keeps running without me.

  1. 01Web development
  2. 02SQL & data modelling
  3. 03BI & analytics
  4. 04Cloud automation
  5. 05Legacy modernization
  6. 06Scalable systems

02 Tech stack

Three layers of the same system.

Code for the interface, data for the truth, automation for everything that shouldn’t be done by hand.

01

Languages & Front-End

  • JavaScript
  • TypeScript
  • Python
  • HTML / CSS
  • jQuery
  • Responsive web apps
02

Data & Databases

  • SQL
  • DAX
  • JSON APIs
  • Dataverse
  • SharePoint lists
  • MS Access
  • Geocoding
  • SFTP data exchange
03

Enterprise & Automations

  • Power BI
  • Power Automate (Cloud Flows)
  • Power Apps (Canvas)
  • Office Scripts
  • Power Platform CLI
  • Access & permissions management

+ Certifications

  • Oracle APEX & DBMS Certification · Oracle APEX · 2025
  • Microsoft AI Copilot Course · Aglaia · 2025
  • Go Programming Course · Worktocloud / Barcelona Activa · 2026

03 What I’m building toward

Engineering, not patching.

The goal: grow as a software and data engineer on a team that ships real systems. I want to design the pipeline, write the code, test the flow and document it well enough that the next developer can pick it up on day one.

  • Web applications
  • Data pipelines
  • Cloud automation
  • Analytics

04 How I work

Different layers. One way of working.

Structured

Every flow gets a test plan and every script gets documentation.

Adaptable

Front-end, SQL, BI or low-code: I pick up the stack the problem needs.

Analytical

I want to know why the data is wrong before I decide how to fix it.

05 Selected work

Built in production.

Independent full-stack builds and production work inside a public-sector organization, with real data and real users.

01 / Realized

Weblaze - Full-Stack Digital Studio

Architected and developed a high-performance digital studio platform from scratch. Built with Next.js and Astro for sub-second load times, featuring headless CMS integration, programmatic SEO architecture, and custom AI support agents (RAG).

Full-Stack Build
02 / Realized

Enterprise Process Automation

Migrated desktop RPA to Power Automate cloud flows for a government entity. Built JSON-parsing data flows and Canvas apps to automate public grant applications and administrative workflows.

Production
03 / Realized

Geospatial Data Pipeline & Legacy Migration

Engineered automated geocoding pipelines feeding SQL databases and Power BI maps. Rewrote legacy business-critical Excel VBA macros into typed TypeScript Office Scripts for cloud execution.

Pipeline & Migration
04 / Available

[Custom Web App]

Reserved for a full web application: responsive front-end, clean API layer and a data model built to grow.

🔒 Awaiting Brief
05 / Available

[Data Engineering]

Awaiting scattered data sources to consolidate into one reliable pipeline, model and dashboard.

🔒 Awaiting Brief
06 / Available

[Process Automation]

Reserved for the next manual workflow to be replaced by a tested, documented cloud automation.

🔒 Awaiting Brief
Three slots open for the next build.

If you have a slow process, a messy dataset or an app that needs to exist, send me the brief and I’ll scope it.

Start a conversation

Outside of work

  • Chess
  • Theoretical economics
  • Philosophy
  • Nutrition
  • Puzzles
  • Strategy games

English, Spanish, Catalan · learning German and Russian

06 Contact

Need a developer to fix your infrastructure? Let’s build it.

Open to junior developer and data roles, freelance builds and collaborations: web apps, data pipelines, BI and process automation.