Caleb Grant - Portfolio

~/caleb-grant

$ whoami

Caleb Grant

$ cat about.txt

Building scalable data pipelines, cloud-native workflows,
and interactive web applications.

View Projects About Me

About Me

Background

Data engineer and full-stack developer with a strong foundation in Python, SQL, and modern web technologies. My work bridges clean code, robust infrastructure, and intuitive user experience.

With a background in environmental consulting, I bring domain awareness and a passion for building systems where data quality, automation, and reproducibility are engineering priorities.

Tech Stack

Languages

Python

SQL

Bash

Frameworks

Django

Flask

FastAPI

Databases

PostgreSQL

PostGIS

DuckDB

SQLite

Iceberg

Infrastructure

Docker

AWS

GitHub Actions

Education

Washington State University

Go Cougs!

Focus

Environmental Science Geology GIS Geospatial Analysis

Featured Projects

execsql

Multi-DBMS SQL script processor supporting PostgreSQL, MySQL, SQLite, DuckDB, and more. Features metacommands for conditional execution, looping, data import/export, and CI/CD integration.

Python SQL CLI PostgreSQL

pg-upsert

Python package for interactive upsert operations on PostgreSQL databases. Provides QA checks and automated insert/update workflows from staging tables.

Python PostgreSQL CLI ETL

vitalog

CLI for aggregating Apple Health and SleepCycle data into a local DuckDB database, with AI-powered narrative generation and interactive HTML dashboards featuring D3.js charts and Leaflet maps.

Python DuckDB D3.js Claude AI

MarineEnergy.app

The Marine Energy Environmental Toolkit compiles environmental information for development of marine energy-harvesting technologies. Funded by the US Department of Energy.

R Shiny Web App US DOE

Anniston Soil Management Portal

Geospatial decision support system for PCB soil remediation. Django REST API with PostGIS spatial analysis, multi-method interpolation, and async PDF report generation.

Django PostgreSQL PostGIS REST API

CStories

Community-driven story building app to inform offshore energy planning. Interactive mapping and narrative tools for stakeholder engagement.

Web App Mapping Community

Whistler

Whistler Blackcomb live stream dashboard with mountain cams, real-time conditions, lift status, avalanche forecasts, and travel info. Built with Astro and Tailwind CSS.

Astro Tailwind Live Data