Data Engineer, Software Engineer, Hologram, Inc.
Nov, 2020 - Feb, 20232 years 3 months
Performed backend (API) and data engineering (data warehouse, streaming data, ELT/ETL) on platform team; created 200+ data models and associated business intelligence queries and dashboards.
Translated service agreements; created 12 robust custom billing models (40% total revenue)—identified underbilling errors; recouped $160K+/yr.
Redesigned cell tower location data pipeline; munged three different location services–increased location-matching from 40% to 98%.
Architeched IoT device geolocation streaming API; leveraged Redis, Node.js, GraphQL, and Mapbox—enabled efficient ad-hoc owner/device/location-based queries and plotted realtime session data.
Built time-series database infrastructure; migrated, transformed usage data from data warehouse—enabled anomaly-detection and better monetization via data science.
Replaced manual data entry with external API; built ELT tools, modeled/tested data, created discrepancy alerting—assured accurate logistics data, eliminated customer activation delays/outages/troubleshooting time, saved 20+ labor hrs/wk.
Overhauled manual data entry pipeline: superseded high-maintenance SaaS with open source software; added input validation—eliminated recurring interrupt work; assured data integrity.
Pipelined semistructured customer-reported outage data from workflow API to data warehouse; validated/correlated inputs against existing device data—generated outage history reports; afforded trend analysis, reduced troubleshooting time, provided data science training dataset.