Data Analyst
Seoul, South Korea
A data analyst at Panel Big Data Center (SQL, R, Python)[1. Building and Operating Market Analysis Platform]- Played a key role in developing a purchase data analysis platform using receipt data to estimate nationwide consumption- Designed logic for 12 market analysis products (including market basket analysis, switching analysis, and HML analysis) and defined 24 indicators- Generated SQL scripts for the development of analysis engines and created procedures[2. Improving data collection monitoring metric]- Redefined the metric for data collection consent rate and altered the sequence and timing of in-app pop-ups, resulting in a 20%p increase in consent rates[3. Data Quality Management]- Built master tables and a history management system- Led the planning of a website for product data cleansing and automated data updates, increasing individual daily workload by 1.8 times- Utilized work log data to quantify workload, effectively persuading leadership to secure additional headcount for workforce expansion- Designed error detection logic and automated manual processes, which shortened the data delivery time to clients by over 10 days, thereby accelerating sales[4. Project Management with Research Department]- Conducted an analysis of COVID-19's impact on the retail sector by examining card payment and visit data for a Korean catering group, leading to the formulation of tailored marketing strategies and resulting in the acquisition of subsequent projects[5. Advertising/PR for Data Business]- Authored one of the trend analysis sections for the company's annual publication, "Trend Monitor" (2021~2024)- Analyzed purchasing trends for press releases