BI / ANALYTICS ENGINEER (WEB3)
I build reliable metric systems—dashboards, automation, and data models—that connect on-chain activity to business decisions. End-to-end ownership across marketing, engineering, and operations. In crypto since 2017; author of an Ethereum book in Korea (6,000+ copies sold) with a YouTube channel reaching 10,000+ subscribers.
EXPERIENCE
2024 - Present
- Built and launched the Eigen Economy real-time blockchain metrics web app, cutting metric latency from 60 minutes to ~1 minute via event-driven aggregation (10 event types across 5 core contracts).
- Shipped Looker Studio dashboards and automated email reports, enabling self-serve KPI access for protocol and go-to-market teams.
- Consolidated BI across 12+ systems by unifying 30+ Google Sheets and 30+ Apps Script projects into a single GitHub-versioned codebase; enabled cross-system joins and per-customer profitability analysis.
- Automated CRM deal lifecycle tracking by linking billing signals to wallet identity via promo codes; auto-populated custom fields and advanced deal stages to create end-to-end customer visibility.
SQLPostgreSQLLooker StudioApps ScriptHubSpotRPC
Dec 2021 - Apr 2024
- Built wallet-to-identity workflows: connected user wallets to internal systems, generated QR codes per NFT, and recorded ownership metadata to smart contracts to support verifiable tracking.
- Automated Discord role assignment by reconciling Discord IDs with NFT ownership, reducing manual community operations work.
SvelteTypeScriptNode.jsHardhatSmart Contracts
Jul 2019 - Nov 2021
- Developed and maintained a DeFi web application supporting lending and leveraged trading; integrated 0x Protocol SDK with Vue.js and TypeScript.
- Shipped and maintained production features across front-end and back-end services (Vue, Node.js, Solidity), focusing on reliability and user experience.
Vue.jsTypeScriptNode.jsSolidity0x Protocol
SELECTED WORK
Real-time blockchain metrics web app that reduced KPI latency from 60 minutes to ~1 minute. Built event-driven aggregation across 10 event types and 5 core contracts, with hourly relational baseline + 1-minute RPC deltas. Powers stakeholder dashboards and automated reporting for protocol and GTM teams.
Built withReal-time MetricsEvent-drivenRPCLooker Studio
Internal BI Platform
Multi-system reporting + CRM automation platform. Unified BI across 12+ systems via a version-controlled Apps Script codebase. Standardized scheduled jobs/triggers and enabled cross-system joins. Automated CRM lifecycle tracking by linking billing signals to on-chain identity.
Built withApps ScriptGoogle SheetsHubSpotData Modeling