Tae Kim — Senior BI & Data Engineering Analyst

Profile

Ten years turning raw data into decisions.

Business Intelligence and Data Analyst with 10+ years of experience using SQL, BigQuery, Power BI, Looker, and large-scale datasets to analyze business performance, develop executive dashboards, define KPIs, and deliver actionable insights. Experienced in transforming complex data from multiple platforms into trusted analytical datasets and self-service reporting solutions. Strong technical foundation in data engineering, data quality, dimensional modeling, and automated reporting across Google Cloud Platform (GCP) and Azure.

Trusted datasets Self-service first No vanity metrics

Experience

4 roles

2022→Now

Google (via BayOne) · Jul 2022 – Present

Senior Business Intelligence Analyst

Analyze campaign and content performance across YouTube, Sprinklr, and Bitly to identify trends and actionable insights.
Develop cross-platform analytical datasets using GoogleSQL (Plx) for reporting and modeling.
Automate data validation and anomaly detection to improve data quality and reporting accuracy.
Develop analytical datasets supporting AI-assisted sentiment and campaign insights.
Build reusable data layers that reduce ad-hoc reporting and improve analytics consistency.
Support executive quarterly and annual reviews through KPI analysis, dashboards, and insights.

GoogleSQLBigQueryLookerGCP

2015→2022

CBS Interactive & 1WorldSync · Jun 2015 – May 2022

Senior Business Intelligence Analyst

Engineered scalable data pipelines across Azure Data Lake, U-SQL, and Hadoop, processing 12M+ daily event logs for analytics across 1,200+ retail partners, including Target, Costco, and Walmart.
Designed modular dimensional data models and optimized warehouse schemas supporting 20+ self-service Power BI and Birst dashboards.
Tuned query performance and partitioned large-scale datasets to improve performance and reduce compute costs.

AzureHadoopPower BIETL/ELT

2014→2015

New York University · Oct 2014 – May 2015

Graduate Research Assistant

Analyzed 400M+ rows of MTA API and GIS data to identify trends in NYC traffic flow.
Built interactive data visualizations supporting transportation planning and policy analysis.

PythonGISData Viz

2012→2020

US Army Reserve · Apr 2012 – Apr 2020

Specialist

Eight years of service. Army Commendation Medal & National Defense Service Medal.

LeadershipDisciplineService

Selected Work

9 dashboards

Analytics dashboards built for Google's developer social programs — campaign performance, engagement analysis, and audience growth across YouTube, Instagram, X, LinkedIn, Threads, and Bluesky.

KPI command center dashboard — **KPI command center**Headline metrics — 815M video views, 255M impressions — with platform breakdowns.

Executive performance dashboard with filters — **Executive performance dashboard**Filterable views of organic video views, hours watched, and engagements by quarter.

Engagement efficiency scatter and stacked bar charts — **Engagement efficiency analysis**Weighted engagements vs. impressions by quarter and platform, with publishing cadence.

Impressions deep dive with bubble charts — **Impressions deep dive**336M quarterly impressions by platform, with bubble analysis of engagement efficiency.

Publishing cadence versus engagement charts — **Publishing cadence vs. engagement**Quarterly output mapped against weighted engagements across six platforms.

Viral post detection table and scatter plots — **Viral post detection**14-day impression and engagement outliers surfaced automatically across platforms.

**YouTube analytics suite**Traffic sources, search terms, viewer geography, and per-video performance.

Account benchmarking scatter plots — **Account benchmarking**Engagement efficiency compared across 30+ developer accounts and quarters.

Subscriber and follower growth charts — **Audience growth tracking**YouTube subscriber and cross-platform follower growth, month by month.

Skills

4 groups

Business & Data Analytics

Business Analysis · KPI & Metric Development · Performance Analysis · Trend Analysis · Ad Hoc Analysis · Data Validation · Anomaly Detection · Executive Reporting

Programming & Query

SQL · GoogleSQL · Python · U-SQL

BI & Visualization

Looker · Google Data Studio · Power BI · Tableau · Birst · Dashboard Development · Interactive Data Visualization

Cloud & Data

Google Cloud Platform (GCP) · BigQuery · Plx · Azure Data Lake · AWS · Hadoop · ETL/ELT · Dimensional Data Modeling

Education

3 degrees

New York University · Jul 2015

Master of Science, Applied Urban Science and Informatics

Big Data · Data Mining for Business Analysis · Programming for Data Science · Applied Data Science · Real-Time and Big Data Analytics

MLA

Harvard University · May 2010

Master of Liberal Arts, Information Technology

Concentration: Information Management Systems

University of Pittsburgh · Dec 2005

Bachelor of Arts

Related coursework: Computer Science

Honors

★ Army Commendation Medal ★ National Defense Service Medal ★ NYU Academic Fellowship — Merit Based