Languages & Front-End
- JavaScript
- TypeScript
- Python
- HTML / CSS
- jQuery
- Responsive web apps
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
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.
02 Tech stack
Code for the interface, data for the truth, automation for everything that shouldn’t be done by hand.
03 What I’m building toward
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.
04 How I work
Every flow gets a test plan and every script gets documentation.
Front-end, SQL, BI or low-code: I pick up the stack the problem needs.
I want to know why the data is wrong before I decide how to fix it.
05 Selected work
Independent full-stack builds and production work inside a public-sector organization, with real data and real users.
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 BuildMigrated 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.
ProductionEngineered 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 & MigrationReserved for a full web application: responsive front-end, clean API layer and a data model built to grow.
🔒 Awaiting BriefAwaiting scattered data sources to consolidate into one reliable pipeline, model and dashboard.
🔒 Awaiting BriefReserved for the next manual workflow to be replaced by a tested, documented cloud automation.
🔒 Awaiting BriefIf you have a slow process, a messy dataset or an app that needs to exist, send me the brief and I’ll scope it.
English, Spanish, Catalan · learning German and Russian
06 Contact
Open to junior developer and data roles, freelance builds and collaborations: web apps, data pipelines, BI and process automation.