I help teams replace manual reporting, scattered workflows, and unreliable data processes with automated, documented systems.
I'm Jiyoung Roh, a bilingual (Korean–English) Data Automation & BI Consultant. I can sit in a stakeholder meeting, understand the reporting pain, and then go build the Python/SQL pipeline, automation workflow, or dashboard that fixes it — without a middleman between the business problem and the technical solution.
Most of my work starts the same way: a team has outgrown their spreadsheets, their reporting is fragmented, or someone is spending 10 hours a week on something that should take 10 minutes. I'll help clarify whether you need a dashboard, an automation workflow, a data pipeline, or simply a cleaner process — then build it.
I understand the business problem and can implement the technical solution — no translation layer needed.
Everything I build comes with documentation. Your team should be able to maintain it after I leave.
Native Korean, fluent English. I've worked with teams in Seoul, the U.S., and Canada — async-friendly, timezone-flexible.
Your team is copy-pasting between spreadsheets, manually processing PDFs, or running the same query every Monday. I automate it.
Reports live in 5 different places, nobody trusts the numbers, and leadership keeps asking for 'one source of truth.' I build that.
Data needs to move from point A to point B without breaking, losing rows, or requiring someone to babysit it. I build the pipes.
A process that made sense for 3 people doesn't work for 30. I map what's breaking, cut the unnecessary steps, and rebuild it to scale.
You're outgrowing Google Sheets but not ready for a full data team. I set up the warehouse, the pipelines, and the BI layer so you don't have to.
A Canadian fitness chain with 50+ locations had no unified reporting. I built a BigQuery reporting layer, set up Apps Script refreshes to keep data current, and delivered Looker Studio dashboards for cross-location visibility.
A U.S. insurance firm was manually keying data from hundreds of claim PDFs weekly — multiple formats, inconsistent layouts. I built Python extraction with regex/parsing logic to handle each format, then piped structured output into Excel VBA for downstream use.
A U.S.-based workforce intelligence platform needed to go from raw, high-volume datasets to self-serve analytics. I built a DuckDB + Parquet processing workflow, curated reporting layers in BigQuery, and stood up Metabase dashboards for self-serve BI.
HYBE had a multi-department legacy migration originally estimated at 2 years. I handled data cleaning, wrote migration logic, automated repetitive workflows, and built validation checks to ensure integrity — all while live operations continued.
Real numbers from real projects — not hypothetical benchmarks.
BigQuery + Apps Script + Looker Studio replaced 10+ hrs/week of manual work at a 50-location Canadian fitness chain
DuckDB + Parquet + Metabase pipeline built for a U.S.-based workforce intelligence platform — processed daily, self-serve BI for the analytics team
HYBE multi-department legacy migration — data cleaning, migration logic, validation, and workflow automation completed in 5 months against a 2-year estimate
Python + regex parsing replaced manual PDF data entry for an insurance client — multiple formats handled, Excel VBA output for the ops team
If your team is stuck on manual reporting, fragmented spreadsheets, broken pipelines, or PDFs that won't parse — describe the problem. I'll tell you honestly whether I can help and what the approach would look like. Available for consulting, freelance, and longer-term engagements.
Send a short note about your situation — the manual process eating hours, the pipeline nobody maintains, the spreadsheet held together with formulas. I'll respond within 24–48 hours with an honest take.
Inquire about availability