Open-Source Frameworks & Projects

Reusable data engineering frameworks, metadata-driven ETL architectures, and full-stack applications.

Tiago Marques Portfolio

Nuxt 3Vue.jsTailwind CSSSQLiteTypeScriptNode.js

A modern, dual-persona portfolio website built with Nuxt 3 and full-stack features, designed to showcase both engineering and musical careers.

This website serves as my primary professional portfolio, uniquely designed to represent two distinct professional tracks: Data Engineering/Technology and Professional Accordion Performance.

Technical Highlights

  • Dual-Persona Architecture: A custom routing and state management system that switches the entire site’s theme, navigation, and content context between “Tech” (Teal/Clean) and “Music” (Amber/Warm) modes seamlessly.
  • Full-Stack Nuxt 3: Leverages Nuxt 3’s server-side capabilities for API routes and SEO performance.
  • Dynamic Content (SQLite): Instead of static Markdown files alone, content is synchronized into a local SQLite database (content.db) allowing for complex querying, filtering, and relationship management (e.g., tagging, related posts) at the API level.
  • Agentic Development: The entire codebase was developed in collaboration with advanced AI agents, utilizing an iterative “Architect-Implement-Review” workflow.
  • Performance: Optimized with Tailwind CSS for minimal bundle size and fast load times.

The project demonstrates a modern approach to personal branding, moving away from rigid templates to a bespoke, full-stack solution that adapts to the content.

Databricks Kimball Framework

DatabricksPythonPySparkDelta LakeSQL

A metadata-driven ETL framework for implementing Kimball dimensional modeling on Databricks using PySpark and Delta Lake.

This project provides a robust, reusable framework for processing data warehouses on Databricks following Kimball methodologies. It simplifies the creation and management of Slowly Changing Dimensions (SCD Types 1 & 2) and Fact tables, abstracting complex merge logic into a configuration-driven architecture.

Key Features

  • Metadata-Driven: Define source-to-target mappings, keys, and update logic in JSON/YAML configurations rather than hardcoded logic.
  • SCD Type 1 & 2 Support: Native, optimized support for history tracking (SCD2) and overwrite updates (SCD1) using Delta Lake’s MERGE capabilities.
  • Surrogate Key Management: Automated generation and management of hashing keys or identity columns.
  • Incremental Loading: Efficiently processes only new or modified data to minimize compute costs.
  • Quality & auditing: Built-in logging and data quality checks (expectations) during the pipeline execution.

This framework allows data engineers to focus on business logic and modeling rather than boilerplate infrastructure code for data warehousing.

Alma Menor — Web Architecture & Digital Presence

Nuxt 4Vue.jsTailwind CSSNuxt i18nTypeScriptCloudflare PagesNitro

High-performance bilingual digital media platform and static site generation (SSG) architecture built with Nuxt 4 for the Portuguese folk-fusion duo Alma Menor.

Official digital presence and media platform for Alma Menor, an instrumental Portuguese folk-fusion duo uniting chromatic accordion and Galician bagpipes, founded by Tiago Marques and Tiago Morais.

Technical Highlights

  • Static Site Generation (SSG): Built with Nuxt 4 and Nitro, prerendering all 35 bilingual routes into pure static assets for instant First Contentful Paint (FCP) and near-zero TTFB.
  • Dual-Language Architecture: Full bilingual localization (pt-PT / en-US) powered by @nuxtjs/i18n with prefix-free default routing, dynamic locale negotiation, and complete hreflang alternate mapping.
  • Editorial Typography & Visual Identity: Bespoke aesthetic bridging Portuguese tradition and contemporary minimalism, utilizing textured stone/paper palettes, custom brush typography, and modern Tailwind design tokens.
  • Interactive Media & Performance: Responsive touch-enabled photo carousels, embedded concert videography, and structured discography with zero third-party script bloat.
  • Edge Delivery & CI/CD: Hosted globally on Cloudflare Pages edge network with continuous deployment from GitHub, automated universal SSL, and root-to-subdomain canonical redirects.
  • Semantic SEO & Structured Data: Rich Schema.org JSON-LD graphs (MusicGroup, MusicAlbum, EventSeries, AboutPage) and GA4 measurement for enhanced search visibility.