Hi, I'm Eric Burmeister.

data engineer - automation and systems enthusiast

Projects

Kansas City Almanac

STATUS: DEVELOPMENT

VISION: I'd like to have a fun weather dashboard for the family with Farmer's Almanac vibes that can be embedded into a Home Assistant dashboard.

PROGRESS: The initial thought was to do it all in Databricks - medallion architecture on Delta Lake, Workflows for orchestration, and Prophet for 14-day ML-driven forecasting, and AI/BI Dashboards. Since Databricks doesn't support public dashboard embedding, I took the opportunity to learn Grafana and rebuilt the dashboard there to pull live data from the Gold tables via Databricks SQL. With time I want to expand the metrics, add fun daily facts and holidays, and look into making the theme and UI more kid-friendly - Grafana does not seem to be a good fit here.

  • Apache Spark
  • Databricks
  • Delta Lake
  • Grafana
  • Pandas
  • Prophet
  • Python
  • REST APIs
  • Linux

High Availability

STATUS: ONLINE

It’s been a lot of fun building out a 3-node Proxmox cluster paired with a 3-node Kubernetes setup across physical machines. Seeing high availability work in practice (through quorum, failover, and recovery) has been great. I’ll continue to containerize more of my services, with the long-term goal of full redundancy and true high availability.

  • Docker
  • Kubernetes
  • Linux
  • Networking
  • Proxmox
  • System Administration

Growing Like Weeds

STATUS: ONLINE

My kids are growing like weeds. This is just a simple Metabase dashboard fed by a few Postgres tables fed by a Python/Pandas script that pulls in new rows from Google Sheets fed by Google Forms.

  • Python
  • Pandas
  • PostgreSQL
  • Google Forms
  • Google Sheets
  • Metabase
  • ETL
  • Data Analytics

Drive.Refuel.Repeat

STATUS: ONLINE

This is what happens when you pull out your phone to record gas tank refill data for nearly ten years. Ingestion is handled by Make.com from Google Forms entries into Supabase's PostgreSQL instance, which is then connected to Metabase.

Data cleaning and transformations are handled entirely in SQL.

  • Google Forms
  • Make.com
  • Metabase
  • PostgreSQL
  • Supabase
  • ETL
  • Data Analytics
  • DBeaver

4Q25 Environment Updates

STATUS: BACKLOG

VISION: To make my homelab situation look like I know what I'm doing.

PROGRESS: I've really enjoyed rebuilding everything in Proxmox VMs and setting up Tailscale for remote access as needed. For now, I am focused on creating an environment to allow experimentation with AI and to make it easier to kick off new projects. The next phase will be to enable deeper observability and resource monitoring with Grafana and Prometheus.

  • AnythingLLM
  • Dify
  • Linux
  • MCP server
  • Moltbot
  • Proxmox
  • System Administration
  • Tailscale
  • Ubuntu Server
  • Virtual Machines

BurmHub

STATUS: DEVELOPMENT

VISION: A self-hosted CRM-inspired platform that centralizes family events, schedules, tasks, projects, and home automation. Ideally, it will integrate with an agent to support conversational querying of all family data.

PROGRESS: After trying out several self-hosted CRM and project management tools, I might just settle on NextCloud + Open WebUI + Postgres. Currently exploring the solutions and integrations offered within the app marketplace.

  • AWS
  • Budibase
  • Data Lake
  • Data Modeling
  • DBeaver
  • Dify
  • Google Cloud
  • Librechat
  • Linux
  • MCP server
  • n8n
  • Ollama
  • PostgreSQL
  • RAG
  • SQL
  • Warehouse Design

Poolboy Q

STATUS: DEVELOPMENT

VISION: AI-powered pool chemical testing assistant that transforms emailed PDF reports into normalized, actionable insights. Leveraging a self-hosted LLM, it instantly analyzes pool data and generates step-by-step chemical dosing and maintenance instructions, delivered directly via email.

PROGRESS: Before this pool season, I will replace the single reviewer step with a voting process by multiple models, and I will replace the long system prompt with a proper RAG pipeline. Before I would've rated the output a 7/10 but I'm optimistic I can get this to a 9/10 since I saw major improvements after adding the review step.

  • Docker
  • Document Library / Vector Store
  • ETL
  • Google Cloud
  • n8n
  • Prompting
  • RAG
  • SQL

AI Lifeguard

STATUS: BACKLOG

VISION: AI-powered cameras monitor our pool area for unattended children.

PROGRESS: Experimenting with vision LLM models and testing frame-masking to boost accuracy. So far, frustrated with results, but optimistic modern models and hardware upgrades can get this done.

  • DevOps
  • Linux
  • n8n
  • Networking
  • Python

Local AI

STATUS: DEVELOPMENT

VISION: Build a private, self-hosted assistant to replace ChatGPT Claude and Google assistant for queries, schedule & task management, collaboration, and home automation needs.

PROGRESS: Replaced AnythingLLM with OpenWebUI, upgraded to Qwen3.5 models, integrating Home Assistant with Ollama, and designing the RAG pipeline.

  • OpenWebUI
  • Linux
  • n8n
  • Ollama
  • Python
  • SQL

kWh Dashboard

STATUS: INACTIVE - SOLD PROPERTY

A simple pipeline that used Python to log into the Evergy account when a new billing notification email was received, extract data from the API and eBill PDFs, and consolidate cost, usage, weather, and solar production metrics for monitoring and analysis. The locally hosted dashboard was powered by Metabase.

  • API
  • DNS
  • FastAPI
  • Github
  • Linux
  • Metabase
  • Python
  • SQL
  • web hosting

Miles To Go

STATUS: ONLINE

A Tableau story visualizing miles and costs over time between vehicles.

  • Spreadsheets
  • SQL
  • Tableau

PMR

STATUS: INACTIVE - SOLD COMPANY

PMR (Preventive Maintenance Report) is a data visualization tool offering clients a metrics-first report following each contract maintenance visit.

  • BlueFolder
  • Spreadsheets
  • macros

Searcher

STATUS: ONLINE

Searcher makes it easy to find replacement parts, diagrams, manuals, and manufacturer portals.

  • bubble.io
  • database
  • Spreadsheets

Skills