Skip to content
View wirkix's full-sized avatar

Achievements

Achievement: Pull Sharkx2Achievement: YOLO

Achievements

Achievement: Pull Sharkx2Achievement: YOLO

Block or report wirkix

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Content in all repositories owned by your account will be closed.
Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
wirkix/README.md

Hi, I'm Alois 👋

Business Intelligence & data engineering specialist with 10+ years turning data from many sources into dashboards and decisions. Based in México, working remotely in English and Spanish.

I build end-to-end data pipelines: ingestion, warehousing with dbt, streaming, forecasting, and BI. More and more, I add AI to that work.

🌐 Portfolio & CV · 💼 LinkedIn · 🧰 Upwork · 🟢 Open to remote work

Featured projects

Project What it does Stack Try it
Ecobici Pulse Live occupancy map of Mexico City's ~680 bike-share stations, refreshed every 60 s Kafka · TimescaleDB · Supabase Realtime · Next.js Live map
NYC Taxi Demand Forecast Week-ahead hourly demand forecast from NYC TLC trips + weather. 8.7% error vs 14.5% for a seasonal baseline Python · MySQL · scikit-learn · Prophet · GitHub Actions Weekly report
ELT Warehouse with CI NBA data warehouse whose dbt models are tested in CI and refreshed daily dbt · Databricks · GitHub Actions · Metabase Dashboard
Economic Pulse Lakehouse Mexican economic indicators (Banxico, INEGI) through a bronze/silver/gold lakehouse Airflow · PySpark · MinIO · DuckDB · Tableau Tableau viz
Motor Analytics Ask questions about the used-car market in plain language; a Claude agent writes and runs the SQL DuckDB · dbt · Claude API · Streamlit Chat app
Job Market Radar Scrapes remote data-engineering jobs, extracts skills with an LLM, models them into a star schema Airflow · dbt · PostgreSQL · Power BI Report

Toolbox

Data & BI: SQL, PL/SQL, dbt, Oracle, PostgreSQL, MySQL, Databricks, DuckDB, Power BI, Tableau, Oracle BI
Pipelines: Python, Airflow, Kafka, PySpark, Pentaho (PDI), OWB, Docker, GitHub Actions
Cloud & AI: AWS, Supabase, Vercel, Claude API

Pinned Loading

  1. job-market-radar job-market-radar Public

    Scrapes remote data-engineering job postings, enriches them with an LLM (Claude or local Ollama), and models them into a dbt star-schema Postgres warehouse behind a Power BI report.

    Python

  2. motor-analytics motor-analytics Public

    Wide, denormalized used-car analytics table over DuckDB + dbt, queried by a Claude-powered chat agent instead of a fixed dashboard.

    Python

  3. ecobici-pulse ecobici-pulse Public

    Live occupancy map of Mexico City's Ecobici bike-share, streamed via Kafka into TimescaleDB + Supabase Realtime

    Python

  4. economic-pulse-lakehouse economic-pulse-lakehouse Public

    Mexico economic-indicators lakehouse: Banxico + INEGI APIs to MinIO (bronze), PySpark (silver/gold) and DuckDB, orchestrated by Airflow and published as a Tableau Public dashboard.

    Python

  5. elt-warehouse-ci elt-warehouse-ci Public

    NBA ELT warehouse: balldontlie API to Databricks Delta tables, dbt models tested in GitHub Actions CI, refreshed daily and served through a public Metabase dashboard.

    Python

  6. nyc-taxi-demand-forecast nyc-taxi-demand-forecast Public

    Week-ahead hourly NYC taxi demand forecasting: TLC trips + Open-Meteo weather -> MySQL -> gradient boosting / Prophet backtests -> weekly Plotly report

    Python